mysql 索引 分页_MySQL---正确使用索引、limit分页、执行计划、慢日志查询

1 id2 查询顺序标识3 如：mysql> explain select * from (select nid,name from tb1 where nid < 10) as B;4 +----+-------------+------------+-------+---------------+---------+---------+------+------+-------------+

5 | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

6 +----+-------------+------------+-------+---------------+---------+---------+------+------+-------------+

7 | 1 | PRIMARY | | ALL | NULL | NULL | NULL | NULL | 9 | NULL |

8 | 2 | DERIVED | tb1 | range | PRIMARY | PRIMARY | 8 | NULL | 9 | Using where |

9 +----+-------------+------------+-------+---------------+---------+---------+------+------+-------------+

10 特别的：如果使用union连接气值可能为null11

12

13 select_type14 查询类型15 SIMPLE 简单查询16 PRIMARY 最外层查询17 S