ITPub博客

首页 > 数据库 > MySQL > 大表count(*) 导致宕机

大表count(*) 导致宕机

原创 MySQL 作者:G8bao7 时间:2016-03-24 21:54:07 0 删除 编辑

对表做 select count(*) from tbname;

异常信息如下

点击(此处)折叠或打开

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

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



ulimit -a 没超过限制

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




来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26250550/viewspace-2063414/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-11-04

  • 博文量
    486
  • 访问量
    1184095