Can the CLUSTER_SLOW_QUERY table be cleaned directly?

Translated
1

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

Original topic: CLUSTER_SLOW_QUERY表可以直接清理吗？

| username: TiDBer_pkQ5q1l0

[TiDB Usage Environment] Production Environment
[TiDB Version] v5.2.1
[Reproduction Path] Operations performed that led to the issue
[Encountered Issue: Issue Phenomenon and Impact]
The CLUSTER_SLOW_QUERY table query is very slow, and the data volume is quite large. Can the data in this table be deleted by time?
[Attachments: Screenshots/Logs/Monitoring]

image
image1249×138 12.6 KB

image

2
| username: 裤衩儿飞上天 | Original post link

Just go ahead and delete the slow logs.

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

Go to the system host and delete the historical slow logs,
SHOW config WHERE NAME LIKE ‘%slow-query-file%’

4
| username: TiDBer_pkQ5q1l0 | Original post link

After clearing, it’s gone. Thanks to both of you.

5
| username: system | Original post link

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