大表count 致使宕机

发布时间：2022-06-29 12:48 所属栏目：115 来源：互联网

导读：对表做 select count(*) from tbname; 异常信息如下点击(此处)折叠或打开 016-03-24 21:37:28 17887 [ERROR] InnoDB: Tried to read 16384 bytes at offset 50072698880. Was only able to read 8192. 2016-03-24 21:37:28 7faab67f6700 InnoDB: Operating

　　对表做 select count(*) from tbname;

　　异常信息如下

　　点击(此处)折叠或打开

　　016-03-24 21:37:28 17887 [ERROR] InnoDB: Tried to read 16384 bytes at offset 50072698880. Was only able to read 8192.
　　2016-03-24 21:37:28 7faab67f6700 InnoDB: Operating system error number 11 in a file operation.
　　InnoDB: Error number 11 means 'Resource temporarily unavailable'.
　　InnoDB: Some operating system error numbers are described at
　　InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
　　2016-03-24 21:37:28 7faab67f6700 InnoDB: File operation call: 'read' returned OS error 111.
　　2016-03-24 21:37:28 7faab67f6700 InnoDB: Cannot continue operation.
　　pure virtual method called
　　pure virtual method called
　　terminate called without an active exception
　　terminate called without an active exception
　　13:37:28 UTC - mysqld got signal 6 ;

　　This could be because you hit a bug. It is also possible that this binary

　　ulimit -a 没超过限制

　　可能是表数据文件损坏，在slave上执行没有报错。

（编辑：ASP站长网）