Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 统计信息为0,tidb后台为何没有自动analyze?
[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.