mysql> select * from stat where date='2014-01-09';
Query aborted by Ctrl+C
ERROR 1317 (70100): Query execution was interrupted
mysql> explain select * from stat where date='2014-01-09';
+----+-------------+-------+------+---------------+------+---------+------+---------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+------+---------+-------------+
| 1 | SIMPLE | stat | ALL | NULL | NULL | NULL | NULL | 2223634 | Using where |
+----+-------------+-------+------+---------------+------+---------+------+---------+-------------+
1 row in set (0.00 sec)
mysql> alter table stat add index megaindex (date);