v7.5.7升级v8.5.8有哪儿些注意事项
【TiDB 使用环境】生产环境
【TiDB 版本】v7.5.7
【部署方式】机器部署
【遇到的问题：问题现象及影响】
计划将TiDB集群从v7.5.7升级到v8.5.8，升级后有哪儿些注意事项，参数调整
当前v7.5.7配置文件
server_configs:
tidb:
log.file.max-backups: 100
log.file.max-days: 30
log.slow-threshold: 100
tmp-storage-path: /data1/tidb-tmp-storage
tmp-storage-quota: 107374182400
tikv:
log.file.max-backups: 100
log.file.max-days: 30
raftstore.apply-pool-size: 6
raftstore.store-pool-size: 6
readpool.unified.max-thread-count: 10
readpool.coprocessor.use-unified-pool: true
readpool.storage.use-unified-pool: true
raftstore.raft-base-tick-interval: 2s
server.grpc-compression-type: gzip
pd:
log.file.max-backups: 100
log.file.max-days: 30
replication.location-labels: ["zone", "host"]
当前v7.5.7参数调整
set global tidb_enable_rate_limit_action=false;
set global tidb_enable_pseudo_for_outdated_stats=OFF;
set global tidb_enable_index_merge=ON;
set global tidb_server_memory_limit="80%";
set global tidb_enable_auto_analyze=off;
set global tidb_auto_analyze_start_time='00:00 +0800';
set global tidb_auto_analyze_end_time='00:30 +0800';
set global tidb_ddl_enable_fast_reorg =off;
set global tidb_enable_metadata_lock=off;
set global tidb_committer_concurrency=1024;
set global tidb_analyze_version=2;
set global tidb_cost_model_version=2;
set global tidb_stats_load_sync_wait=100;
set global tidb_stats_load_pseudo_timeout=ON;
set global sql_mode='';
set global tidb_max_chunk_size=4096;
SET GLOBAL tidb_enable_top_sql = 1;
set global tidb_gc_life_time="24h";
set global tidb_remove_orderby_in_subquery=off;
set global tidb_opt_advanced_join_hint=on;
set global max_execution_time=0;
set global tidb_enable_paging=off;
set global tidb_opt_objective='determinate';
set global tidb_opt_ordering_index_selectivity_threshold=1;
set global tidb_opt_prefer_range_scan=on;
已知注意事项：
1、调整region-max-size、region-split-size、region-split-keys、region-max-keys