Mysql index usage monitoring analysis _ MySQL

Monitoring Analysis of mysql index usage bitsCN. commysql index usage monitoring analysis show status like 'handler _ read % ';

Handler_read_first indicates the number of times the index header is read. if the value is very high, it indicates that there are many full index scans. Handler_read_key indicates the number of times an index is used. if we add a new index, we can check whether Handler_read_key has been increased. if so, SQL uses indexes. Handler_read_next indicates that the following indexes are read. generally, range scan occurs. Handler_read_prev indicates the upper column of the index to be read, which usually occurs in order... DESC. Handler_read_rnd indicates reading rows at a fixed position. if the value is very high, it indicates that a large number of result sets are sorted, full table scanning is performed, and no proper KEY is used for associated queries. Handler_read_rnd_next indicates that many table scans are performed and query performance is low. Author gzh0222bitsCN.com