是否检查,组件名称(PK),参数名称(PK),组件节点(PK),检查源表,规范值,规范静态值
enable,系统变量,tidb_auto_analyze_start_time,all_node,mysql.global_variables,22:00 +0800,22:00 +0800
enable,系统变量,tidb_auto_analyze_end_time,all_node,mysql.global_variables,04:00 +0800,04:00 +0800
enable,系统变量,transaction_isolation,all_node,mysql.global_variables,READ-COMMITTED,READ-COMMITTED
enable,系统变量,tidb_gc_life_time,all_node,mysql.global_variables,24h,24h
enable,系统变量,tidb_analyze_version,all_node,mysql.global_variables,1,1
enable,系统变量,tidb_enable_clustered_index,all_node,mysql.global_variables,off,off
enable,系统变量,tidb_skip_isolation_level_check,all_node,mysql.global_variables,0,0
enable,系统变量,tidb_auto_analyze_ratio,all_node,mysql.global_variables,0.1,0.1
enable,系统变量,tidb_stmt_summary_max_stmt_count,all_node,mysql.global_variables,10000,10000
enable,系统变量,tidb_enable_noop_functions,all_node,mysql.global_variables,0(off),0
enable,tidb,token-limit,all_node,information_schema.cluster_config,CPU_CNT * 5/N,20
enable,tidb,enable-telemetry,all_node,information_schema.cluster_config,FALSE,FALSE
enable,tidb,performance.txn-total-size-limit,all_node,information_schema.cluster_config,1073741824,1073741824
enable,tidb,mem-quota-query,all_node,information_schema.cluster_config,10737418240(10G),10737418240
enable,tidb,oom-use-tmp-storage,all_node,information_schema.cluster_config,TRUE,TRUE
enable,tidb,tmp-storage-path,all_node,information_schema.cluster_config,"/tidb-data2/tidbtmp4000 （TiDB-server默认节点），,/tidb-data2/tidbtmp4000
enable,tidb,tmp-storage-quota,all_node,information_schema.cluster_config,"536870912000 (500G)   -- ARM 平台   107374182400 (100G)   -- X86 平台,536870912000
enable,tidb,oom-action,all_node,information_schema.cluster_config,cancel (非管理节点)，log(管理节点),cancel
enable,tidb,memory-usage-alarm-ratio,all_node,information_schema.cluster_config,0.5/N,0.5
enable,tidb,log.file.max-size,all_node,information_schema.cluster_config,300MB,300MB
enable,tidb,log.file.max-days,all_node,information_schema.cluster_config,180,180
enable,tidb,log.file.max-backups,all_node,information_schema.cluster_config,200/N,200
enable,tidb,binlog.enable,all_node,information_schema.cluster_config,TRUE,TRUE
enable,tidb,binlog.ignore-error,all_node,information_schema.cluster_config,TRUE,TRUE
enable,tidb,log.slow-threshold,all_node,information_schema.cluster_config,300,300
enable,tidb,log.query-log-max-len,all_node,information_schema.cluster_config,40960000,40960000
enable,tidb,new_collations_enabled_on_first_bootstrap,all_node,information_schema.cluster_config,TRUE,TRUE
enable,tidb,server-version,all_node,information_schema.cluster_config,99.7.${mysql_latest_minor_version}-TiDB-${tidb_version},99.7.${mysql_latest_minor_version}-TiDB-${tidb_version}
enable,tidb,feedback-probability,all_node,information_schema.cluster_config,0,0
enable,tidb,deploy_dir,all_node,information_schema.cluster_config,/home/db/tidb/tidb-deploy/tidb-4000,/home/db/tidb/tidb-deploy/tidb-4000
enable,tidb,log_dir,all_node,information_schema.cluster_config,/home/db/tidb/tidb-deploy/tidb-4000/log,/home/db/tidb/tidb-deploy/tidb-4000/log
enable,tidb,max-procs,all_node,information_schema.cluster_config,CPU_CNT* 0.8 / N,3
enable,tikv,readpool.storage.use-unified-pool,all_node,information_schema.cluster_config,TRUE,TRUE
enable,tikv,storage.block-cache.capacity,all_node,information_schema.cluster_config,MEM_TOTAL * 0.5/N,4004316
enable,tikv,raftstore.apply-pool-size,all_node,information_schema.cluster_config,3,3
enable,tikv,raftstore.store-pool-size,all_node,information_schema.cluster_config,3,3
enable,tikv,server.grpc-concurrency,all_node,information_schema.cluster_config,5,5
enable,tikv,gc.enable-compaction-filter,all_node,information_schema.cluster_config,TRUE,TRUE
enable,tikv,server.labels,all_node,information_schema.cluster_config," zone: bj," zone: bj
enable,tikv,deploy_dir,all_node,information_schema.cluster_config,/home/db/tidb/tidb-deploy/tikv-20160 (多实例需要修改),/home/db/tidb/tidb-deploy/tikv-20160
enable,tikv,log_dir,all_node,information_schema.cluster_config,/home/db/tidb/tidb-deploy/tikv-20160/log (多实例需要修改),/home/db/tidb/tidb-deploy/tikv-20160/log
enable,tikv,data_dir,all_node,information_schema.cluster_config,/tidb-data1/tikv-20160 (多实例需要修改/tidb-data2),/tidb-data1/tikv-20160
enable,pd,replication.max-replicas,all_node,information_schema.cluster_config,3(B/C 类系统)  5（A/A+ 类系统）,3
enable,pd,replication.location-labels,all_node,information_schema.cluster_config,"[""zone"","[""zone""
enable,pd,replication.isolation-levels,all_node,information_schema.cluster_config,,
enable,pd,log.file.max-size,all_node,information_schema.cluster_config,300MB,300MB
enable,pd,log.file.max-days,all_node,information_schema.cluster_config,180,180
enable,pd,log.file.max-backups,all_node,information_schema.cluster_config,50,50
enable,pd,low-space-ratio,all_node,information_schema.cluster_config,0.8,0.8
enable,pd,high-space-ratio,all_node,information_schema.cluster_config,0.7,0.7
enable,pd,enable-cross-table-merge,all_node,information_schema.cluster_config,TRUE,TRUE
enable,pd,dashboard.enable-telemetry,all_node,information_schema.cluster_config,FALSE,FALSE
enable,pd,deploy_dir,all_node,information_schema.cluster_config,/home/db/tidb/tidb-deploy/pd-2379 ,/home/db/tidb/tidb-deploy/pd-2379 
enable,pd,log_dir,all_node,information_schema.cluster_config,/home/db/tidb/tidb-deploy/pd-2379/log,/home/db/tidb/tidb-deploy/pd-2379/log
enable,pd,data_dir,all_node,information_schema.cluster_config,/tidb-data1/pd-data ,/tidb-data1/pd-data 
enable,pd,schedule.max-store-down-time,all_node,information_schema.cluster_config,120m,120m
enable,tiflash,profiles.default.max_threads,all_node,information_schema.cluster_config,cpu_cnt/5,0
enable,tiflash,logger.count,all_node,information_schema.cluster_config,200,200
enable,tiflash,profiles.default.max_memory_usage_for_all_queries,all_node,information_schema.cluster_config,MEM_TOTAL * 0.7,5606042
enable,tiflash,deploy_dir,all_node,information_schema.cluster_config,/home/db/tidb/tidb-deploy/tiflash-9000,/home/db/tidb/tidb-deploy/tiflash-9000
enable,tiflash,log_dir,all_node,information_schema.cluster_config,/home/db/tidb/tidb-deploy/tiflash-9000/log,/home/db/tidb/tidb-deploy/tiflash-9000/log
enable,tiflash,storage.main.dir,all_node,information_schema.cluster_config,"[""/tidb-data1/tiflash-9000"","[""/tidb-data1/tiflash-9000""
enable,tiflash,flash.proxy.labels,all_node,information_schema.cluster_config," [zone=zone1," [zone=zone1
