全球主机交流论坛

标题: 我的数据库总是莫名奇妙的出问题，大牛帮忙给分析下 [打印本页]

作者: elves766 时间: 2012-5-25 21:31
标题: 我的数据库总是莫名奇妙的出问题，大牛帮忙给分析下
有一次我用dz后台自带的备份备份了下数据库，刷新后网站就提示出错了（数据库）

之后频繁出现同样的问题。。附上错误日志。。
120525  0:00:03 [Note] Event Scheduler: Purging the queue. 0 events
120525  0:00:05 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 00:00:05 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 00:00:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525  0:00:05 [Note] Event Scheduler: Loaded 0 events
120525  0:00:05 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120525  3:00:03 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120525  3:00:03 [Note] Event Scheduler: Purging the queue. 0 events
120525  3:00:05 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 03:00:05 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 03:00:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525  3:00:06 [Note] Event Scheduler: Loaded 0 events
120525  3:00:06 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120525  6:00:02 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120525  6:00:02 [Note] Event Scheduler: Purging the queue. 0 events
120525  6:00:04 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 06:00:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 06:00:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525  6:00:04 [Note] Event Scheduler: Loaded 0 events
120525  6:00:04 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120525  9:00:02 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120525  9:00:02 [Note] Event Scheduler: Purging the queue. 0 events
120525  9:00:04 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 09:00:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 09:00:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525  9:00:05 [Note] Event Scheduler: Loaded 0 events
120525  9:00:05 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120525 12:00:02 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120525 12:00:02 [Note] Event Scheduler: Purging the queue. 0 events
120525 12:00:04 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 12:00:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 12:00:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525 12:00:05 [Note] Event Scheduler: Loaded 0 events
120525 12:00:05 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120525 12:15:10 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120525 12:15:10 [Note] Event Scheduler: Purging the queue. 0 events
120525 12:15:12 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 12:15:12 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 12:15:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525 12:15:13 [Note] Event Scheduler: Loaded 0 events
120525 12:15:13 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120525 15:00:02 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120525 15:00:02 [Note] Event Scheduler: Purging the queue. 0 events
120525 15:00:04 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 15:00:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 15:00:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525 15:00:05 [Note] Event Scheduler: Loaded 0 events
120525 15:00:05 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120525 18:00:02 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120525 18:00:02 [Note] Event Scheduler: Purging the queue. 0 events
120525 18:00:04 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 18:00:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 18:00:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525 18:00:05 [Note] Event Scheduler: Loaded 0 events
120525 18:00:05 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120525 19:56:44 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120525 19:56:44 [Note] Event Scheduler: Purging the queue. 0 events
120525 19:56:46 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 19:56:46 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 19:56:48 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525 19:56:48 [Note] Event Scheduler: Loaded 0 events
120525 19:56:48 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120525 21:00:02 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120525 21:00:02 [Note] Event Scheduler: Purging the queue. 0 events
120525 21:00:04 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 21:00:04 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 21:00:04 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525 21:00:04 [Note] Event Scheduler: Loaded 0 events
120525 21:00:04 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120525 21:27:06 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

120525 21:27:06 [Note] Event Scheduler: Purging the queue. 0 events
120525 21:27:08 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

120525 21:27:08 mysqld_safe mysqld from pid file /usr/local/mysql/var/li408-127.pid ended
120525 21:27:09 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120525 21:27:09 [Note] Event Scheduler: Loaded 0 events
120525 21:27:09 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

作者: Administrator 时间: 2012-5-25 21:32
提示: 作者被禁止或删除内容自动屏蔽

作者: 完美 时间: 2012-5-25 21:32
没看出什么来，
估计是vps本身性能问题吧。

作者: elves766 时间: 2012-5-25 21:34

Administrator 发表于 2012-5-25 21:32
数据库会停掉么

对数据库就停止工作了。。。重新lnmp就好了

作者: Administrator 时间: 2012-5-25 21:36
提示: 作者被禁止或删除内容自动屏蔽

作者: Kvm 时间: 2012-5-25 21:38
唔楼主的是linode的vps

/usr/local/mysql/var/ 下的日志啥的删除掉然后再观察下

作者: elves766 时间: 2012-5-25 21:40

Kvm 发表于 2012-5-25 21:38
唔楼主的是linode的vps

你砸知道。。我试试奥。。

作者: elves766 时间: 2012-5-25 22:27
无效现提示

作者: 过客 时间: 2012-5-25 22:38

elves766 发表于 2012-5-25 21:34
对数据库就停止工作了。。。重新lnmp就好了

其实我觉得你备份数据库不如在ssh下，停止数据库，然后tar打包来得更快。

欢迎光临全球主机交流论坛 (https://fd.vvwvv.eu.org/)