设为首页收藏本站
切换到窄版

VPS侦探论坛

 找回密码
 注册
VPS侦探论坛»VPS侦探论坛 › 技术交流区 › LNMP一键安装包 › 求助军哥mysql问题！
返回列表 发新帖
查看: 6444|回复: 7

求助军哥mysql问题！

[复制链接]
sandywk
发表于 2013-4-5 13:04:30 | 显示全部楼层 |阅读模式

服务器安装了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 编辑 ]
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复

举报

煮机名
发表于 2013-4-5 15:58:25 | 显示全部楼层


/usr/local/mysql/var/主机名.err  里面的错误信息发上来侃侃
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

sandywk
 楼主| 发表于 2013-4-6 11:15:43 | 显示全部楼层

130405  0:00:35 [ERROR] /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_home_feed' is marked as crashed and last (automatic?) repair failed
130405 10:48:12 [ERROR] /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_home_feed' is marked as crashed and last (automatic?) repair failed
130405 10:48:12 [ERROR] /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_home_feed' is marked as crashed and last (automatic?) repair failed
130405 10:53:19 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_member.MYI'; try to repair it
130405 10:53:19 [ERROR] Got error 126 when reading table './sq_metnavy/metcms2011_common_member'
130405 10:53:19 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_member.MYI'; try to repair it
130405 10:53:19 [ERROR] Got error 126 when reading table './sq_metnavy/metcms2011_common_member'
130405 10:54:19 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:29 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:38 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:52 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:54 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:54 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:54:59 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:55:35 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:55:46 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:55:47 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:04 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:06 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:08 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:17 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:27 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:37 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:52 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:54 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:57 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:56:58 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:00 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:00 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:00 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:07 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:13 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_member.MYI'; try to repair it
130405 10:57:13 [ERROR] Got error 126 when reading table './sq_metnavy/metcms2011_common_member'
130405 10:57:14 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_member.MYI'; try to repair it
130405 10:57:14 [ERROR] Got error 126 when reading table './sq_metnavy/metcms2011_common_member'
130405 10:57:15 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_member.MYI'; try to repair it
130405 10:57:15 [ERROR] Got error 126 when reading table './sq_metnavy/metcms2011_common_member'
130405 10:57:18 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:44 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:57:47 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:14 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:16 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:26 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:31 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:31 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:31 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:31 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:32 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:33 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:33 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:33 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:34 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:35 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:35 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:36 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:36 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:36 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:36 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:37 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:37 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:37 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:38 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:38 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:38 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:39 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:39 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:39 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:40 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:40 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:40 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:40 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:41 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:41 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:42 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:42 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:42 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:42 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:43 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:43 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复 支持 反对

举报

sandywk
 楼主| 发表于 2013-4-6 11:15:55 | 显示全部楼层



130405 10:58:43 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:44 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:44 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:44 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:45 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:45 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:45 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:46 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:46 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:46 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:47 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:47 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:47 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:47 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:48 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:48 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:48 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:49 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:49 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:49 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:50 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:50 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:51 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:51 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:51 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:52 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:52 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:52 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:53 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:53 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:54 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:54 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:54 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:55 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:55 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:55 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:55 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:56 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:56 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:56 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:57 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:57 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:57 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:58 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:58 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:58 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:59 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:58:59 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:59:00 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:59:00 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:59:01 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:59:01 [ERROR] Got error 127 when reading table './sq_metnavy/metcms2011_common_syscache'
130405 10:59:03 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

licess
发表于 2013-4-6 15:36:04 | 显示全部楼层

看着上面的错误信息的话是提示的表有问题

不过这个一般应该不会影响mysql启动

军哥运维代购：http://shop63846532.taobao.com/
回复 支持 反对

举报

sandywk
 楼主| 发表于 2013-4-6 22:58:15 | 显示全部楼层

130405 10:59:03 [Note] Event Scheduler: Purging the queue. 0 events
130405 10:59:03 [Note] /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 [Note] Event Scheduler: Loaded 0 events
130405 10:59:05 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130405 10:59:44 [ERROR] /usr/local/mysql/libexec/mysqld: Incorrect key file for table './sq_metnavy/metcms2011_common_failedlogin.MYI'; try to repair it
130405 11:02:26 [ERROR] /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_common_failedlogin' is marked as crashed and should be repaired
130405 11:05:35 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

130405 11:05:35 [Note] Event Scheduler: Purging the queue. 0 events
130405 11:05:37 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 35  user: '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 [Note] Event Scheduler: Loaded 0 events
130405 11:35:14 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130405 11:40:13 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

130405 11:40:13 [Note] Event Scheduler: Purging the queue. 0 events
130405 11:40:14 [Note] /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 [Note] Event Scheduler: Loaded 0 events
130405 11:40:15 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130405 11:41:45 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

130405 11:41:45 [Note] Event Scheduler: Purging the queue. 0 events
130405 11:41:45 [Note] /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 [Note] Event Scheduler: Loaded 0 events
130405 11:41:46 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130405 11:44:10 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 11:44:11 [Note] Event Scheduler: Loaded 0 events
130405 11:44:11 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130405 11:44:57 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

130405 11:44:57 [Note] Event Scheduler: Purging the queue. 0 events
130405 11:44:57 [Note] /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 [Note] Event Scheduler: Loaded 0 events
130405 11:44:58 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130405 11:48:43 mysqld_safe A mysqld process already exists
130405 11:49:11 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

130405 11:49:11 [Note] Event Scheduler: Purging the queue. 0 events
130405 11:49:11 [Note] /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 [Note] Event Scheduler: Loaded 0 events
130405 11:49:13 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130405 11:51:07 [ERROR] /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_common_failedlogin' is marked as crashed and should be repaired
130405 11:52:22 [ERROR] /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_common_failedlogin' is marked as crashed and should be repaired
130405 11:52:58 [ERROR] /usr/local/mysql/libexec/mysqld: Table './sq_metnavy/metcms2011_common_failedlogin' is marked as crashed and should be repaired
130405 11:53:58 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

130405 11:53:58 [Note] Event Scheduler: Purging the queue. 0 events
130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 363  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 347  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 338  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 317  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 312  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 282  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 254  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 225  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 219  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 217  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 168  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 140  user: 'sq_metnavy'

130405 11:54:00 [Warning] /usr/local/mysql/libexec/mysqld: Forcing close of thread 46  user: 'sq_metnavy'
回复 支持 反对

举报

sandywk
 楼主| 发表于 2013-4-6 22:59:04 | 显示全部楼层

130405 12:45:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
130405 12:45:23 [Note] Event Scheduler: Loaded 0 events
130405 12:45:23 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
130405 12:53:21 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

130405 12:53:21 [Note] Event Scheduler: Purging the queue. 0 events
130405 12:53:21 [Note] /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 [Note] Event Scheduler: Loaded 0 events
130405 12:53:23 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

以上是昨天出现故障的时间段所有的报错信息，请帮忙看看具体什么原因，如果表有问题，修复数据表就OK了吧？
美国VPS推荐： 遨游主机、Linode、LOCVPS、主机云、搬瓦工、80VPS、Vultr等美国VPS主机。中国VPS推荐： 阿里云、腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
回复 支持 反对

举报

licess
发表于 2013-4-7 12:49:45 | 显示全部楼层

修复表应该就可以了
Linux下Nginx+MySQL+PHP自动安装工具：https://lnmp.org
回复 支持 反对

举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-12-28 10:14 , Processed in 0.027987 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表