Shulou(Shulou.com)06/01 Report--

1) id: the identification of each operation performed independently, indicating the order in which the object is operated; if the id value is large, it is executed first; if the same, the execution order is from top to bottom.

2) select_type: the type of each select clause in the query

3) table: first name, the name of the object being manipulated, usually the table name, but in other formats.

4) partitions: matching partition information (NULL for non-partition table values).

5) type: type of connection operation

6) possible_keys: alternate index (list the indexes that may be used).

7) key: the index selected by the optimizer; the commonly used "ANALYZE TABLE" command enables the optimizer to select the index correctly.

8) key_len: the length of the index key selected by the optimizer, in bytes.

9) ref: represents the reference object of the object being manipulated in this row (the referenced object may be a constant denoted by "const", or it may be an object pointed to by the key of other tables).

10) rows: the number of tuples scanned by the query execution (this is an estimate for InnoDB).

11) filtered: according to the percentage of the number of tuples filtered by the data on the condition table, "rows × filtered/100" can calculate the number of tuples filtered, that is, the actual number of tuples.

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.