MySQL [(none)]> show variables like ‘%ana%’;
±----------------------------------------±--------------------------------------------------+
| Variable_name | Value |
±----------------------------------------±--------------------------------------------------+
| tidb_analyze_column_options | ALL |
| tidb_analyze_distsql_scan_concurrency | 4 |
| tidb_analyze_partition_concurrency | 1 |
| tidb_analyze_skip_column_types | json,blob,mediumblob,longblob,mediumtext,longtext |
| tidb_analyze_version | 2 |
| tidb_auto_analyze_concurrency | 1 |
| tidb_auto_analyze_end_time | 22:00 +0000 |
| tidb_auto_analyze_partition_batch_size | 3 |
| tidb_auto_analyze_ratio | 0.2 |
| tidb_auto_analyze_start_time | 16:00 +0000 |
| tidb_enable_analyze_snapshot | OFF |
| tidb_enable_auto_analyze | ON |
| tidb_enable_auto_analyze_priority_queue | ON |
| tidb_enable_fast_analyze | OFF |
| tidb_max_auto_analyze_time | 43200 |
| tidb_mem_quota_analyze | -1 |
| tidb_persist_analyze_options | ON |
±----------------------------------------±--------------------------------------------------+
大佬我的参数是这样的，ananlyze以后还是没有留存统计信息