×

Loading...
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

@Las Vegas

查了log没有？比如我那里的log在/usr/local/var/H50.err

thisunreal(饭得志)
本文发表在 rolia.net 枫下论坛InnoDB: Crash recovery may have failed for some .ibd files!
InnoDB: cannot read directory ., error 9
InnoDB: Error: os_file_readdir_next_file() returned -1 in
InnoDB: directory .
InnoDB: Crash recovery may have failed for some .ibd files!
InnoDB: cannot read directory ., error 9
InnoDB: Error: os_file_readdir_next_file() returned -1 in
InnoDB: directory .
InnoDB: Crash recovery may have failed for some .ibd files!
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060301 18:42:03 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 48309.
InnoDB: Doing recovery: scanned up to log sequence number 0 48309
InnoDB: Last MySQL binlog file position 0 79, file name ./H50-bin.000024
060301 18:42:03 InnoDB: Flushing modified pages from the buffer pool...
060301 18:42:03 InnoDB: Started; log sequence number 0 48309
/usr/local/libexec/mysqld: ready for connections.
Version: '4.1.14' socket: '/tmp/mysql.sock' port: 3306 Source distribution更多精彩文章及讨论，请光临枫下论坛 rolia.net
(#2814788@0)
Last Updated: 2006-3-2
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 工作学习 / 专业技术讨论 / 这里有熟悉mysql的大侠吗？我的mysql database 每天零晨的时候必会hang,一直找不出原因，请帮忙诊断一下，多谢！ -turnip(turnip); 2006-3-2 (#2814741@0)
    • 查了log没有？比如我那里的log在/usr/local/var/H50.err -thisunreal(饭得志); 2006-3-2 {1034} (#2814788@0)
      本文发表在 rolia.net 枫下论坛InnoDB: Crash recovery may have failed for some .ibd files!
      InnoDB: cannot read directory ., error 9
      InnoDB: Error: os_file_readdir_next_file() returned -1 in
      InnoDB: directory .
      InnoDB: Crash recovery may have failed for some .ibd files!
      InnoDB: cannot read directory ., error 9
      InnoDB: Error: os_file_readdir_next_file() returned -1 in
      InnoDB: directory .
      InnoDB: Crash recovery may have failed for some .ibd files!
      InnoDB: Restoring possible half-written data pages from the doublewrite
      InnoDB: buffer...
      060301 18:42:03 InnoDB: Starting log scan based on checkpoint at
      InnoDB: log sequence number 0 48309.
      InnoDB: Doing recovery: scanned up to log sequence number 0 48309
      InnoDB: Last MySQL binlog file position 0 79, file name ./H50-bin.000024
      060301 18:42:03 InnoDB: Flushing modified pages from the buffer pool...
      060301 18:42:03 InnoDB: Started; log sequence number 0 48309
      /usr/local/libexec/mysqld: ready for connections.
      Version: '4.1.14' socket: '/tmp/mysql.sock' port: 3306 Source distribution更多精彩文章及讨论，请光临枫下论坛 rolia.net
      • 查过了，log里没有任何可疑之处。非常之奇怪。 -turnip(turnip); 2006-3-2 (#2814819@0)
        • 操作系统是什么 -thisunreal(饭得志); 2006-3-2 {178} (#2814844@0)
          如果是Unix 先查crontab -l, at -l，找那个时间点运行的可疑程序。

          找不到了安装个２４小时监视系统的工具。比如AIX可以用nmon，Windows可以用Performance检测工具。 重点关注内存利用率？
          • Freebsd 5.2.1, cron job 查过了，没有任何job相关，内存不应该啊，这个机器内存超过4G. 唉，这个问题真是困扰好久了。不知道mysql 内部有没有什么debug command? -turnip(turnip); 2006-3-2 (#2814857@0)
            • 把SERVER TIME调到凌晨，调！ -walacato(ERIC); 2006-3-3 (#2816282@0)

More Topics

  • Torvalds patch improves Linux performance by 2.6%
  • GitHub Spark
  • 脑洞大开，突发奇想，用力来传播信息
  • 看大家讨论日语，俺也正在认真学习。其实语言问题应该是很快也很容易就解决的，可能比自动驾驶来的还快。TREK里面，全宇宙的人都在大脑里安装了UNIVERSAL TRANSLATOR，外星人之间相互交流无障碍。废话少说，看视频。。。加上个MIC和耳机，不同国家的人就可以无障碍交流。
  • 肉脸真有搞 IT 的？Linux 把俄国中国伊朗踢出去了好像肉脸 IT 没啥感觉似的
    • 枫下论坛主坛 /  工作学习 /  专业技术讨论