第一次测试执行下面的语句时发生如下错误: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或内存运行不足导致。