Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to monitor index usage in mysql. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article.

A brief Analysis of Index Utilization Monitoring

Show status like 'Handler_read%'

Handler_read_first represents the number of times the index header is read, and if this value is high, there are a lot of full index scans.

Handler_read_key represents the number of times an index is used. If we add a new index, we can see if Handler_read_key has increased. If so, sql uses the index. Www.2cto.com

Handler_read_next stands for reading the following indexes, and range scan usually occurs.

Handler_read_prev stands for reading the above column of the index, which usually occurs in ORDER BY. DESC .

Handler_read_rnd stands for reading rows in a fixed position, and if this value is high, a large number of result sets are sorted, a full table scan is performed, and the appropriate KEY is not used in the associated query.

The Handler_read_rnd_next representative does a lot of table scans and the query performance is poor.

On how to monitor index usage in mysql to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.