Mysql查询大表出现的一个错误
标签：
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或内存运行不足导致。