MySQL日志表月统计排重_mysql处理日志统计的问题sum和group by速度好慢？

补充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)