MySQL的莫名故障

August 19th, 2010 no comment

博客的wordpress的mysql数据库突然故障,报了一下错误,同时把我VPS的CPU搞到了100%

Aug 18 23:36:29 www mysqld: 100818 23:36:29 [ERROR] /usr/sbin/mysqld: Table './qingran_blog/wp_commentmeta' is marked as crashed and should be repaired
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [Warning] Checking table:   './qingran_blog/wp_commentmeta'
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [ERROR] /usr/sbin/mysqld: Table './qingran_blog/wp_comments' is marked as crashed and should be repaired
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [Warning] Checking table:   './qingran_blog/wp_comments'
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [ERROR] /usr/sbin/mysqld: Table './qingran_blog/wp_options' is marked as crashed and should be repaired
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [Warning] Checking table:   './qingran_blog/wp_options'
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [ERROR] /usr/sbin/mysqld: Table './qingran_blog/wp_postmeta' is marked as crashed and should be repaired
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [Warning] Checking table:   './qingran_blog/wp_postmeta'
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [ERROR] /usr/sbin/mysqld: Table './qingran_blog/wp_posts' is marked as crashed and should be repaired
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [Warning] Checking table:   './qingran_blog/wp_posts'
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [ERROR] /usr/sbin/mysqld: Table './qingran_blog/wp_term_relationships' is marked as crashed and should be repaired
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [Warning] Checking table:   './qingran_blog/wp_term_relationships'
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [ERROR] /usr/sbin/mysqld: Table './qingran_blog/wp_term_taxonomy' is marked as crashed and should be repaired
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [Warning] Checking table:   './qingran_blog/wp_term_taxonomy'
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [ERROR] /usr/sbin/mysqld: Table './qingran_blog/wp_terms' is marked as crashed and should be repaired
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [Warning] Checking table:   './qingran_blog/wp_terms'
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [ERROR] /usr/sbin/mysqld: Table './qingran_blog/wp_usermeta' is marked as crashed and should be repaired
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [Warning] Checking table:   './qingran_blog/wp_usermeta'
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [ERROR] /usr/sbin/mysqld: Table './qingran_blog/wp_users' is marked as crashed and should be repaired
Aug 18 23:36:29 www mysqld: 100818 23:36:29 [Warning] Checking table:   './qingran_blog/wp_users'
Aug 18 23:40:48 www ntpd[2718]: synchronized to 91.189.94.4, stratum 2

奇怪了,这个mysql的访问量很低,怎么会有如此问题?尝试mysqld restart,备份数据库,执行mysqlcheck和myisamchk,居然任何错误没有,一切正常。。。
这是我遇到的第n次mysql奇怪问题这两天找时间换PostgreSQL!