MySQLexplain怎么获取查询指令信息-创新互联
这篇文章主要为大家展示了MySQL explain怎么获取查询指令信息,内容简而易懂,希望大家可以学习一下,学习完之后肯定会有收获的,下面让小编带大家一起来看看吧。
explain用于获取查询执行计划信息,
一、语法
只需要在select前加上explain即可,如:
mysql> explain select 1; +----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+----------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+----------------+ | 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | No tables used | +----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+----------------+
分享名称:MySQLexplain怎么获取查询指令信息-创新互联
链接分享:http://tyjierui.cn/article/ceehjo.html