补充explain
mysql> explain select count(*) from (select * from querylog_20160809 where querytime>='2016-08-09 00:00:04' and querytime<='2016-08-09 10:50:04' group by domain order by null) as a ;
+----+-------------+-------------------+------+---------------+------+---------+------+---------+------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------------------+------+---------------+------+---------+------+---------+------------------------------+
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Select tables optimized away |
| 2 | DERIVED | querylog_20160809 | ALL | countnum | NULL | NULL | NULL | 2926112 | Using where; Using temporary |
+----+-------------+-------------------+------+---------------+------+---------+------+---------+------------------------------+
2 rows in set (11.28 sec)
mysql> explain select domain,sum(querynum) as num from querylog_201608 where querytime>='2016-08-09 00:00:04' and querytime<='2016-08-09 10:50:04' group by domain order by num desc limit 0,100;
+----+-------------+-------------------+-------+---------------+----------+---------+------+---------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------------------+-------+---------------+----------+---------+------+---------+----------------------------------------------+
| 1 | SIMPLE | querylog_201608 | range | countnum | countnum | 4 | NULL | 1290525 | Using where; Using temporary; Using filesort |
+----+-------------+-------------------+-------+---------------+----------+---------+------+---------+----------------------------------------------+
1 row in set (0.00 sec)