Why doesn't TiDB automatically analyze when the statistics are 0?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 统计信息为0,tidb后台为何没有自动analyze?

| username: Hacker_cCDQit0H

[TiDB Usage Environment] Production environment v5.2.2

The values of the three parameters are as follows:

Currently, I don’t understand. According to the official documentation, theoretically, tidb_auto_analyze_ratio = 1190862/315060 = 3.7798, which is obviously greater than 0.5, but it hasn’t been automatically updated. I would appreciate it if the technical experts could provide some guidance. Thank you very much.

| username: 考试没答案 | Original post link

SHOW ANALYZE STATUS;

| username: 考试没答案 | Original post link

SHOW VARIABLES LIKE '%tidb_analyze_version%';
| username: Hacker_cCDQit0H | Original post link

The default value of tidb_enable_table_partition is AUTO, which means that the partition table feature is enabled by default. If you want to disable it, you can set it to OFF.

| username: Kongdom | Original post link

Check if there are any analyze-related error messages in the tidb.log

| username: 考试没答案 | Original post link

Does the version not support automatic collection of statistics?

| username: 考试没答案 | Original post link

The image is not visible. Please provide the text you need translated.

| username: Hacker_cCDQit0H | Original post link

Thank you.

| username: Hacker_cCDQit0H | Original post link

Thank you, thank you.

| username: Kongdom | Original post link

:handshake: :handshake: :handshake: