×

Loading...
Ad by
  • 予人玫瑰，手有余香：加拿大新天地工作移民诚聘求职顾问&行业导师！
Ad by
  • 予人玫瑰，手有余香：加拿大新天地工作移民诚聘求职顾问&行业导师！

@Calgary

查了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

  • 老程序员第一次用copilot的一点点体会
  • 现在社区游泳池招救生员巡逻，过一会还要不停的点人头，这工作是否很快就被AI代替了，装一个摄像头后面是AI处理系统，这样只招一个等着救人就行了，人头沉下水一定时间立马强光照射，还可以分析水下人的状况来判断是否溺水等
  • 新冠疫苗引发心肌炎? 最新研究这样看
  • 这道几何题有解吗?
  • SAM 2 Demo
    • 枫下论坛主坛 /  工作学习 /  专业技术讨论