How to Monitor Index Effectiveness in TiDB Version 6.5.1

Translated
1

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

Original topic: tidb6.5.1版本如何监控索引有效

| username: wenyi

How to monitor index effectiveness in TiDB version 6.5.1?
The view select * from performance_schema.table_io_waits_summary_by_index_usage is not available in 6.5.1.

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

It seems that there is no good solution for TiDB at the moment. You can only enable the general log and then record the unused indexes from it?

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

Hello: Do you want to check a single index or check whether all the indexes in the inspection database are being used?

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

If it’s just an index:
image
Invisible, check the slow log. If it affects the system, it means this index is being used.

Quite aggressive! High risk factor.

5
| username: wenyi | Original post link

Are all the indexes under the inspection database used?

6
| username: wenyi | Original post link

It is recommended that the official provide a view to clearly see whether an index is being used and its usage frequency.

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

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

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

My table has no data. Please check on your end.