求助军哥mysql问题！
服务器安装了discuz论坛，该论坛之前放在另外一个服务器，mysql版本应该比lnmp的mysql版本老，然后前段时间把论坛搬到了用lnmp的服务器上，刚开始还正常，过了一段时间发现数据表总出现问题（论坛禁用帐号和删帖时报错），我查了些资料，用修复数据表的方法暂时恢复正常，可过段时间又一样的问题。今天出现同样问题的时候直接导致网站无法访问，我/root/lnmp restart重启到Shutting down MySQL.........，就一直无法在进行下去，网站访问也是无法链接，服务器能ping通。查了军哥论坛的帖子，也看到有类似问题的存在，有个说是mysql日志太大造成无法关闭mysql，我这边最开始的时候就禁止了日志，所以现在都不知道怎样才好。
目前的方式是重启服务器，然后能暂时访问一段时间。
我觉得问题应该在于mysql一直在运行或者卡死导致无法关闭和重启，而我又找不到强制重启mysql的办法。关于安装的discuz论坛有可能是mysql版本不一样造成的问题，我可以先把论坛移到原来mysql版本的服务器，把mysql升级到lnmp一样的mysql版本后再搬过来。
请求军哥给个解决办法，多谢！
[ 本帖最后由 sandywk 于 2013-4-5 13:08 编辑 ] /usr/local/mysql/var/主机名.err里面的错误信息发上来侃侃 1304050:00:35 /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_home_feed' is marked as crashed and last (automatic?) repair failed
130405 10:48:12 /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_home_feed' is marked as crashed and last (automatic?) repair failed
130405 10:48:12 /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_home_feed' is marked as crashed and last (automatic?) repair failed
130405 10:53:19 /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_member.MYI'; try to repair it
130405 10:53:19 Got error 126 when reading table './sq_metnavy/metcms2011_common_member'
130405 10:53:19 /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_member.MYI'; try to repair it
130405 10:53:19 Got error 126 when reading table './sq_metnavy/metcms2011_common_member'
130405 10:54:19 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:29 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:38 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:52 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:54 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:54 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:59 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:55:35 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:55:46 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:55:47 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:04 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:06 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:08 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:17 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:27 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:37 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:52 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:54 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:57 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:58 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:00 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:00 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:00 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:07 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:13 /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_member.MYI'; try to repair it
130405 10:57:13 Got error 126 when reading table './sq_metnavy/metcms2011_common_member'
130405 10:57:14 /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_member.MYI'; try to repair it
130405 10:57:14 Got error 126 when reading table './sq_metnavy/metcms2011_common_member'
130405 10:57:15 /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_member.MYI'; try to repair it
130405 10:57:15 Got error 126 when reading table './sq_metnavy/metcms2011_common_member'
130405 10:57:18 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:44 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:47 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:14 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:16 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:26 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:31 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:31 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:31 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:31 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:32 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:33 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:33 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:33 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:34 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:35 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:35 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:36 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:36 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:36 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:36 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:37 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:37 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:37 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:38 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:38 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:38 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:39 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:39 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:39 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:40 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:40 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:40 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:40 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:41 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:41 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:42 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:42 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:42 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:42 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:43 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:43 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache' 130405 10:58:43 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:44 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:44 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:44 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:45 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:45 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:45 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:46 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:46 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:46 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:47 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:47 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:47 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:47 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:48 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:48 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:48 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:49 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:49 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:49 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:50 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:50 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:51 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:51 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:51 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:52 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:52 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:52 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:53 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:53 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:54 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:54 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:54 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:55 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:55 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:55 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:55 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:56 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:56 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:56 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:57 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:57 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:57 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:58 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:58 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:58 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:59 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:59 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:59:00 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:59:00 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:59:01 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:59:01 Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:59:03 /usr/local/mysql/libexec/mysqld: Normal shutdown 看着上面的错误信息的话是提示的表有问题
不过这个一般应该不会影响mysql启动 130405 10:59:03 Event Scheduler: Purging the queue. 0 events
130405 10:59:03 /usr/local/mysql/libexec/mysqld: Shutdown complete
130405 10:59:03 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
130405 10:59:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 10:59:05 Event Scheduler: Loaded 0 events
130405 10:59:05 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'socket: '/tmp/mysql.sock'port: 3306Source distribution
130405 10:59:44 /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_failedlogin.MYI'; try to repair it
130405 11:02:26 /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_common_failedlogin' is marked as crashed and should be repaired
130405 11:05:35 /usr/local/mysql/libexec/mysqld: Normal shutdown
130405 11:05:35 Event Scheduler: Purging the queue. 0 events
130405 11:05:37 /usr/local/mysql/libexec/mysqld: Forcing close of thread 35user: 'sq_metnavy'
130405 11:14:28 mysqld_safe A mysqld process already exists
130405 11:35:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 11:35:14 Event Scheduler: Loaded 0 events
130405 11:35:14 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'socket: '/tmp/mysql.sock'port: 3306Source distribution
130405 11:40:13 /usr/local/mysql/libexec/mysqld: Normal shutdown
130405 11:40:13 Event Scheduler: Purging the queue. 0 events
130405 11:40:14 /usr/local/mysql/libexec/mysqld: Shutdown complete
130405 11:40:14 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
130405 11:40:15 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 11:40:15 Event Scheduler: Loaded 0 events
130405 11:40:15 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'socket: '/tmp/mysql.sock'port: 3306Source distribution
130405 11:41:45 /usr/local/mysql/libexec/mysqld: Normal shutdown
130405 11:41:45 Event Scheduler: Purging the queue. 0 events
130405 11:41:45 /usr/local/mysql/libexec/mysqld: Shutdown complete
130405 11:41:45 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
130405 11:41:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 11:41:46 Event Scheduler: Loaded 0 events
130405 11:41:46 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'socket: '/tmp/mysql.sock'port: 3306Source distribution
130405 11:44:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 11:44:11 Event Scheduler: Loaded 0 events
130405 11:44:11 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'socket: '/tmp/mysql.sock'port: 3306Source distribution
130405 11:44:57 /usr/local/mysql/libexec/mysqld: Normal shutdown
130405 11:44:57 Event Scheduler: Purging the queue. 0 events
130405 11:44:57 /usr/local/mysql/libexec/mysqld: Shutdown complete
130405 11:44:57 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
130405 11:44:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 11:44:58 Event Scheduler: Loaded 0 events
130405 11:44:58 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'socket: '/tmp/mysql.sock'port: 3306Source distribution
130405 11:48:43 mysqld_safe A mysqld process already exists
130405 11:49:11 /usr/local/mysql/libexec/mysqld: Normal shutdown
130405 11:49:11 Event Scheduler: Purging the queue. 0 events
130405 11:49:11 /usr/local/mysql/libexec/mysqld: Shutdown complete
130405 11:49:11 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
130405 11:49:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 11:49:13 Event Scheduler: Loaded 0 events
130405 11:49:13 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'socket: '/tmp/mysql.sock'port: 3306Source distribution
130405 11:51:07 /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_common_failedlogin' is marked as crashed and should be repaired
130405 11:52:22 /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_common_failedlogin' is marked as crashed and should be repaired
130405 11:52:58 /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_common_failedlogin' is marked as crashed and should be repaired
130405 11:53:58 /usr/local/mysql/libexec/mysqld: Normal shutdown
130405 11:53:58 Event Scheduler: Purging the queue. 0 events
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 363user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 347user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 338user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 317user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 312user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 282user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 254user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 225user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 219user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 217user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 168user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 140user: 'sq_metnavy'
130405 11:54:00 /usr/local/mysql/libexec/mysqld: Forcing close of thread 46user: 'sq_metnavy' 130405 12:45:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 12:45:23 Event Scheduler: Loaded 0 events
130405 12:45:23 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'socket: '/tmp/mysql.sock'port: 3306Source distribution
130405 12:53:21 /usr/local/mysql/libexec/mysqld: Normal shutdown
130405 12:53:21 Event Scheduler: Purging the queue. 0 events
130405 12:53:21 /usr/local/mysql/libexec/mysqld: Shutdown complete
130405 12:53:21 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
130405 12:53:23 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 12:53:23 Event Scheduler: Loaded 0 events
130405 12:53:23 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'socket: '/tmp/mysql.sock'port: 3306Source distribution
以上是昨天出现故障的时间段所有的报错信息，请帮忙看看具体什么原因，如果表有问题，修复数据表就OK了吧？ 修复表应该就可以了
页:
[1]