我的数据库总是莫名奇妙的出问题， 大牛帮忙给分析下

elves766

无效 现提示

elves766

有一次我用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

完美

没看出什么来，
估计是vps本身性能问题吧。

elves766

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

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

Kvm

唔  楼主的是linode的vps


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

elves766

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

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

过客

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

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