重启lnmp后,mysql崩溃了
重启lnmp后,mysql崩溃了，之后我重启下vps,mysql又好，这样的问题已经遇到两次了。回复 1# 的帖子
善用搜索。。https://bbs.vpser.net/viewthread.php?tid=1164 mysql5.1.30初次启动会出现Starting MySQL.Manager of pid-file quit without updating fi的报错，需要注释/etc/my.cnf里的skip-federated注释掉即#skip-federated就OK了！
军哥，我的是lnmp5.0的最新版5.1.48
/etc/my.cnf里面找不到skip-federated 发/usr/local/mysql/var/主机名.err 错误日志 101102 16:54:52 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101102 16:54:53 Event Scheduler: Loaded 0 events
101102 16:54:53 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101102 16:54:55 /usr/local/mysql/libexec/mysqld: Normal shutdown
101102 16:54:55 Event Scheduler: Purging the queue. 0 events
101102 16:54:55 /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 Event Scheduler: Loaded 0 events
101102 16:54:58 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101102 16:54:58 /usr/local/mysql/libexec/mysqld: Normal shutdown
101102 16:54:58 Event Scheduler: Purging the queue. 0 events
101102 16:54:58 /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 Event Scheduler: Loaded 0 events
101102 17:15:36 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101102 17:15:37 mysqld_safe A mysqld process already exists
101102 20:33:56 /usr/local/mysql/libexec/mysqld: Normal shutdown
101102 20:33:56 Event Scheduler: Purging the queue. 0 events
101102 20:33:57 /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 Event Scheduler: Loaded 0 events
101102 20:34:02 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101102 22:48:45 /usr/local/mysql/libexec/mysqld: Normal shutdown
101102 22:48:45 Event Scheduler: Purging the queue. 0 events
101102 22:48:46 /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 Event Scheduler: Loaded 0 events
101102 22:48:49 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101110 17:15:34 /usr/local/mysql/libexec/mysqld: Normal shutdown
101110 17:15:34 Event Scheduler: Purging the queue. 0 events
101110 17:15:34 /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 101110 16:59:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
101110 16:59:07 Can't start server: Bind on TCP/IP port: Address already in use
101110 16:59:07 Do you already have another mysqld server running on port: 3306 ?
101110 16:59:07 Aborting
101110 16:59:07 /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 Can't start server: Bind on TCP/IP port: Address already in use
101110 17:02:09 Do you already have another mysqld server running on port: 3306 ?
101110 17:02:09 Aborting
101110 17:02:09 /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 Can't start server: Bind on TCP/IP port: Address already in use
101110 17:10:54 Do you already have another mysqld server running on port: 3306 ?
101110 17:10:54 Aborting
101110 17:10:54 /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 Event Scheduler: Loaded 0 events
101110 17:16:03 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101110 17:25:16 /usr/local/mysql/libexec/mysqld: Normal shutdown
101110 17:25:16 Event Scheduler: Purging the queue. 0 events
101110 17:25:16 /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 Event Scheduler: Loaded 0 events
101110 17:25:18 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101110 17:31:58 /usr/local/mysql/libexec/mysqld: Normal shutdown
101110 17:31:58 Event Scheduler: Purging the queue. 0 events
101110 17:31:59 /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 Event Scheduler: Loaded 0 events
101110 17:32:00 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101110 17:52:45 /usr/local/mysql/libexec/mysqld: Normal shutdown
101110 17:52:45 Event Scheduler: Purging the queue. 0 events
101110 17:52:45 /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 Event Scheduler: Loaded 0 events
101110 17:52:46 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101110 17:55:25 /usr/local/mysql/libexec/mysqld: Normal shutdown
101110 17:55:25 Event Scheduler: Purging the queue. 0 events
101110 17:55:25 /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 Event Scheduler: Loaded 0 events
101110 17:55:27 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101110 18:03:20 /usr/local/mysql/libexec/mysqld: Normal shutdown
101110 18:03:20 Event Scheduler: Purging the queue. 0 events
101110 18:03:21 /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 Event Scheduler: Loaded 0 events
101110 18:03:21 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101110 18:08:05 /usr/local/mysql/libexec/mysqld: Normal shutdown
101110 18:08:05 Event Scheduler: Purging the queue. 0 events
101110 18:08:05 /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 Event Scheduler: Loaded 0 events
101110 18:08:06 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101110 18:26:24 /usr/local/mysql/libexec/mysqld: Normal shutdown
101110 18:26:24 Event Scheduler: Purging the queue. 0 events
101110 18:26:24 /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 Event Scheduler: Loaded 0 events
101110 18:26:26 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101111 11:36:39 /usr/local/mysql/libexec/mysqld: Normal shutdown
101111 11:36:39 Event Scheduler: Purging the queue. 0 events
101111 11:36:39 /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 Event Scheduler: Loaded 0 events
101111 11:36:41 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101111 13:54:05 /usr/local/mysql/libexec/mysqld: Normal shutdown
101111 13:54:05 Event Scheduler: Purging the queue. 0 events
101111 13:54:05 /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 Event Scheduler: Loaded 0 events
101111 13:54:07 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.48-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
101111 17:09:36 /usr/local/mysql/libexec/mysqld: Normal shutdown
101111 17:09:36 Event Scheduler: Purging the queue. 0 events
101111 17:09:38 /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
回复 6# 的帖子
执行：df -h 看看磁盘占用情况。
页:
[1]