Mysql查询大表出现的一个错误
时间：2021-07-01 10:21:17
帮助过：2人阅读
> 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或内存运行不足导致。
Mysql查询大表出现的一个错误
标签：
