阅读背景:

Mysql优化系列之查询性能优化前篇2

来源:互联网 

接前一篇,这一篇主要总结下几个经常要用的命令

命令一:explain+sql

mysql> explain select * from servers;
+----+-------------+---------+------+---------------+------+---------+------+------+-------+
| id | select_type | table   | type | possible_keys | key  | key_len | ref  | rows | Extra |
+----+-------------+---------+------+---------------+------+---------+------+------+-------+
|  1 | SIMPLE      | servers | ALL  | NULL          | NULL | NULL    | NULL |    1 | NULL  |
+----+-------------+---------+------+---------------+------+---------+------+------+-------+
row in set (0.03 sec)
m



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: