TiDB Dashboard Loading Slowly

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

Original topic: tidb-dashboard加载慢

| username: TiDBer_fzkBTwhP

[Test Environment for TiDB]
[TiDB Version] 6.0.1
[Reproduction Path] After using TiDB for 3 months, with default configurations and a single-node service installed on a 120C/128G server, the monitoring page at http://1.1.1.10:2379/dashboard/#/slow_query takes several seconds to load.
[Problem Encountered: Phenomenon and Impact]
The slow SQL logs on the monitoring page at http://1.1.1.10:2379/dashboard/#/slow_query take several seconds to load.
I checked the information_schema.cluster_slow_query table and it only has a few thousand entries.
[Resource Configuration] 120C/128G/SATA disk
[Attachments: Screenshots/Logs/Monitoring]

| username: 像风一样的男子 | Original post link

Clean up the slow-log under the TiDB service. Accumulating too many logs will slow down the loading.

| username: 有猫万事足 | Original post link

tiup ctl:v<tidb_version_number> pd service-gc-safepoint

Check if the GC is progressing normally?

| username: Fly-bird | Original post link

Restarting Grafana should make it faster.

| username: 随缘天空 | Original post link

On the dashboard monitoring page, check the server’s performance metrics, memory, and CPU usage to see if resources are being excessively occupied by other programs.

| username: zhanggame1 | Original post link

Just clear the slow log backup directly.