重启lnmp后,mysql崩溃了

ljb0901

重启lnmp后,mysql崩溃了，之后我重启下vps,mysql又好，这样的问题已经遇到两次了。

licess

善用搜索。。
https://bbs.vpser.net/viewthread.php?tid=1164

ljb0901

mysql5.1.30  初次启动会出现Starting MySQL.Manager of pid-file quit without updating fi[FAILED]的报错，需要注释/etc/my.cnf里的skip-federated注释掉即#skip-federated就OK了！
军哥，我的是lnmp5.0的最新版5.1.48
/etc/my.cnf里面找不到skip-federated

licess

发/usr/local/mysql/var/主机名.err 错误日志

ljb0901

101102 16:54:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101102 16:54:53 [Note] Event Scheduler: Loaded 0 events
101102 16:54:53 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101102 16:54:55 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101102 16:54:55 [Note] Event Scheduler: Purging the queue. 0 events
101102 16:54:55 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101102 16:54:55 mysqld_safe mysqld from pid file /usr/local/mysql/var/server.znsoft.com.pid ended
101102 16:54:56 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101102 16:54:58 [Note] Event Scheduler: Loaded 0 events
101102 16:54:58 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101102 16:54:58 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101102 16:54:58 [Note] Event Scheduler: Purging the queue. 0 events
101102 16:54:58 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101102 16:54:58 mysqld_safe mysqld from pid file /usr/local/mysql/var/server.znsoft.com.pid ended
101102 17:15:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101102 17:15:36 [Note] Event Scheduler: Loaded 0 events
101102 17:15:36 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101102 17:15:37 mysqld_safe A mysqld process already exists
101102 20:33:56 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101102 20:33:56 [Note] Event Scheduler: Purging the queue. 0 events
101102 20:33:57 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101102 20:33:58 mysqld_safe mysqld from pid file /usr/local/mysql/var/server.znsoft.com.pid ended
101102 20:33:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101102 20:34:02 [Note] Event Scheduler: Loaded 0 events
101102 20:34:02 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101102 22:48:45 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101102 22:48:45 [Note] Event Scheduler: Purging the queue. 0 events
101102 22:48:46 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101102 22:48:46 mysqld_safe mysqld from pid file /usr/local/mysql/var/server.znsoft.com.pid ended
101102 22:48:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101102 22:48:49 [Note] Event Scheduler: Loaded 0 events
101102 22:48:49 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101110 17:15:34 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101110 17:15:34 [Note] Event Scheduler: Purging the queue. 0 events
101110 17:15:34 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 17:15:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/server.znsoft.com.pid ended

ljb0901

101110 16:59:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 16:59:07 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101110 16:59:07 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101110 16:59:07 [ERROR] Aborting

101110 16:59:07 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 16:59:07 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101110 17:02:08 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 17:02:09 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101110 17:02:09 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101110 17:02:09 [ERROR] Aborting

101110 17:02:09 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 17:02:09 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101110 17:10:53 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 17:10:54 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
101110 17:10:54 [ERROR] Do you already have another mysqld server running on port: 3306 ?
101110 17:10:54 [ERROR] Aborting

101110 17:10:54 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 17:10:54 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101110 17:16:02 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 17:16:03 [Note] Event Scheduler: Loaded 0 events
101110 17:16:03 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101110 17:25:16 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101110 17:25:16 [Note] Event Scheduler: Purging the queue. 0 events
101110 17:25:16 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 17:25:16 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101110 17:25:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 17:25:18 [Note] Event Scheduler: Loaded 0 events
101110 17:25:18 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101110 17:31:58 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101110 17:31:58 [Note] Event Scheduler: Purging the queue. 0 events
101110 17:31:59 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 17:31:59 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101110 17:31:59 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 17:32:00 [Note] Event Scheduler: Loaded 0 events
101110 17:32:00 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101110 17:52:45 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101110 17:52:45 [Note] Event Scheduler: Purging the queue. 0 events
101110 17:52:45 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 17:52:45 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101110 17:52:46 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 17:52:46 [Note] Event Scheduler: Loaded 0 events
101110 17:52:46 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101110 17:55:25 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101110 17:55:25 [Note] Event Scheduler: Purging the queue. 0 events
101110 17:55:25 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 17:55:25 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101110 17:55:26 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 17:55:27 [Note] Event Scheduler: Loaded 0 events
101110 17:55:27 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101110 18:03:20 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101110 18:03:20 [Note] Event Scheduler: Purging the queue. 0 events
101110 18:03:21 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 18:03:21 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101110 18:03:21 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 18:03:21 [Note] Event Scheduler: Loaded 0 events
101110 18:03:21 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101110 18:08:05 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101110 18:08:05 [Note] Event Scheduler: Purging the queue. 0 events
101110 18:08:05 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 18:08:05 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101110 18:08:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 18:08:06 [Note] Event Scheduler: Loaded 0 events
101110 18:08:06 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101110 18:26:24 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101110 18:26:24 [Note] Event Scheduler: Purging the queue. 0 events
101110 18:26:24 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101110 18:26:24 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101110 18:26:25 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 18:26:26 [Note] Event Scheduler: Loaded 0 events
101110 18:26:26 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101111 11:36:39 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101111 11:36:39 [Note] Event Scheduler: Purging the queue. 0 events
101111 11:36:39 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101111 11:36:39 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101111 11:36:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101111 11:36:41 [Note] Event Scheduler: Loaded 0 events
101111 11:36:41 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101111 13:54:05 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101111 13:54:05 [Note] Event Scheduler: Purging the queue. 0 events
101111 13:54:05 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101111 13:54:06 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended
101111 13:54:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101111 13:54:07 [Note] Event Scheduler: Loaded 0 events
101111 13:54:07 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
101111 17:09:36 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown

101111 17:09:36 [Note] Event Scheduler: Purging the queue. 0 events
101111 17:09:38 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

101111 17:09:38 mysqld_safe mysqld from pid file /usr/local/mysql/var/szjume.com.pid ended

licess

执行：df -h 看看磁盘占用情况。