mysql> explain SELECT * FROM email_group_1 where email_gp_id > 0
ORDER BY email_gp_id ASC LIMIT 200000 , 100;
+----+-------------+---------------+-------+---------------------+---------+---------+------+--------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------------+-------+---------------------+---------+---------+------+--------+-------------+
| 1 | SIMPLE | email_group_1 | range | PRIMARY,email_gp_id | PRIMARY | 4 | NULL | 246179 | Using where |
+----+-------------+---------------+-------+---------------------+---------+---------+------+--------+-------------+
1 row in set
mysql> explain SELECT * FROM email_group_1
ORDER BY email_gp_id ASC LIMIT 200000 , 100;
+----+-------------+---------------+------+---------------+------+---------+------+--------+----------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------------+------+---------------+------+---------+------+--------+----------------+
| 1 | SIMPLE | email_group_1 | ALL | NULL | NULL | NULL | NULL | 246348 | Using filesort |
+----+-------------+---------------+------+---------------+------+---------+------+--------+----------------+
1 row in set
mysql>
能让查询从10多秒变成1秒左右,但是尾页时会有点慢.