Mysql.stats_histograms health is 0, causing full table scans and high machine load

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

Original topic: mysql.stats_histograms 健康度是0 ,导致一直全表扫,机器负载高

| username: foxchan

[TiDB Usage Environment] Production Environment
[TiDB Version] 6.1.5
[Reproduction Path] Enable partition table dynamic pruning, manually check and collect statistics after auto-analyse, full table scan
[Encountered Problem: Problem Phenomenon and Impact]
image

How can I force a hit or repair the health?

| username: tidb菜鸟一只 | Original post link

Manually collecting statistics, isn’t it possible? ANALYZE TABLE mysql.stats_histograms;

| username: foxchan | Original post link

Got it, thanks.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.