• ADADADADAD

    大表count(*) 导致宕机[ mysql数据库 ]

    mysql数据库 时间:2024-12-24 19:12:15

    作者:文/会员上传

    简介:

    对表做 select count(*) from tbname;

    异常信息如下

    点击(此处)折叠或打开016-03-24 21:37:28 17887 [ERROR] InnoDB: Tried to read 16384 bytes at offset 50072698880

    以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。


    对表做 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 7faab67f6700InnoDB: 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 atInnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html2016-03-24 21:37:28 7faab67f6700InnoDB: File operation call: 'read' returned OS error 111.2016-03-24 21:37:28 7faab67f6700InnoDB: Cannot continue operation.pure virtual method calledpure virtual method calledterminate called without an active exceptionterminate called without an active exception13: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上执行没有报错




    大表count(*) 导致宕机.docx

    将本文的Word文档下载到电脑

    推荐度:

    下载
    热门标签: count大表宕机