mysql handler 详解_Mysql参数详解_Handler

• Handler_read_first[656]——越高越好

The number of times the first entry in an index was read. If this value is high, it suggests that the server

is doing a lot of full index scans; for example, SELECT col1 FROM foo, assuming that col1is

indexed.

• Handler_read_key[656]——越高越好

The number of requests to read a row based on a key. If this value is high, it is a good indication that

your tables are properly indexed for your queries.

• Handler_read_last[656]

The number of requests to read the last key in an index. With ORDER BY, the server will issue a first-key

request followed by several next-key requests, whereas with With ORDER BY DESC, the server will issue

a last-key request followed by several previous-key requests. This variable was added in MySQL 5.6.1.

• Handler_read_next[656]

The number of requests to read the next row in key order. This value is incremented if you are querying

an index column with a range constraint or if you are doing an index scan.

• Handler_read_prev[656]

The number of requests to read the previous row in key order. This read method is mainly used to

optimize ORDER BY ... DESC.

• Handler_read_rnd[656]——如果该值很大，说明查询排序比较多

The number of requests to read a row based on a fixed position. This value is high if you are doing a

lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to

scan entire tables or you have joins that do not use keys properly.

• Handler_read_rnd_next[657]——从文件中读取数据，越低越好

The number of requests to read the next row in the data file. This value is high if you are doing a lot of

table scans. Generally this suggests that your tables are not properly indexed or that your queries are

not written to take advantage of the indexes you have.