Mysql查询大表出现的一个错误

 

第一次测试执行下面的语句时发生如下错误：bigdata里面有100万条数据

mysql> select count(*) from (select distinct(id) from bigdata) as total;

ERROR 1317 (70100): Query execution was interrupted

等了一会再执行一下就成功了

mysql>  select count(*) from (select distinct(id) from bigdata) as total;
+----------+
| count(*) |
+----------+
|   598898 |
+----------+
1 row in set (6.60 sec)

猜测有可能是系统原因，CPU或内存运行不足导致。