The meaning of the MySQL query plan output column

Source: Internet
Author: User
Tags mysql query

"One: The meaning of the MySQL query plan output column:
1.id: The identification of each operation performed independently, indicating the order in which the objects are manipulated, the larger the ID value, the first execution, and, if the same, the order of execution from top to bottom.
2.select_type: The type of each SELECT clause in the query.
3.table: Name, the name of the object being manipulated, usually the table name, but there are other formats.
4.partitions: Matching partition information (null for non-partitioned table values).
5.type: The type of connection operation.
6.possible_keys: Alternate index (lists the indexes that may be used).
7.key: The index selected by the optimizer; The Analyze table command is often used to enable the optimizer to correctly select an index.
8.key_len: The length of the index key selected by the optimizer, in bytes.
9.ref: A Reference object that represents the object that the bank is manipulating (the referenced object may be a const representation, or it may be the object that the key of the other table points to).
10.rows: The number of tuples scanned by the query execution (this value 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 x filtered/100 can find out the number of tuples that have been filtered, that is, the actual number of tuples.
12.extra:mysql important supplemental information to query plans during query optimizer execution of queries. "

The meaning of the MySQL query plan output column

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.