MySQL自动停止

JPF1024 2013-05-08 01:40:36

ERROR! MySQL manager or server PID file could not be found! 每次执行重启的时候都提示这个错误》

lnmp的环境 , mysql 5.1的系统.

最近日志.求高手解决.谢谢



130507 14:49:05 mysqld_safe mysqld from pid file /usr/local/mysql/var/[XXX].COM.pid ended

130507 14:49:05 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

130507 14:49:06  InnoDB: Initializing buffer pool, size = 16.0M

130507 14:49:06  InnoDB: Completed initialization of buffer pool

130507 14:49:06  InnoDB: Started; log sequence number 0 44243

130507 14:49:06 [Note] Event Scheduler: Loaded 0 events

130507 14:49:06 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.

Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

130508 00:25:31 mysqld_safe Number of processes running now: 0

130508 00:25:32 mysqld_safe mysqld restarted

130508 00:28:02 mysqld_safe mysqld from pid file /usr/local/mysql/var/[XXX].COM.pid ended

130508 00:52:44 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

130508  0:52:45  InnoDB: Initializing buffer pool, size = 16.0M

130508  0:52:45  InnoDB: Completed initialization of buffer pool

130508  0:52:45  InnoDB: Started; log sequence number 0 44243

130508  0:52:45 [Note] Recovering after a crash using mysql-bin

130508  0:52:46 [Note] Starting crash recovery...

130508  0:52:46 [Note] Crash recovery finished.

130508  0:52:46 [Note] Event Scheduler: Loaded 0 events

130508  0:52:46 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.

Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

130508  0:53:10 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown



130508  0:53:10 [Note] Event Scheduler: Purging the queue. 0 events

130508  0:53:10  InnoDB: Starting shutdown...

130508  0:53:11  InnoDB: Shutdown completed; log sequence number 0 44243

130508  0:53:11 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete



130508 00:53:11 mysqld_safe mysqld from pid file /usr/local/mysql/var/[XXX].COM.pid ended

130508 00:53:12 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var

130508  0:53:12  InnoDB: Initializing buffer pool, size = 16.0M

130508  0:53:12  InnoDB: Completed initialization of buffer pool

130508  0:53:12  InnoDB: Started; log sequence number 0 44243

130508  0:53:12 [Note] Event Scheduler: Loaded 0 events

130508  0:53:12 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.

Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

130508 01:00:28 mysqld_safe Number of processes running now: 0

130508 01:00:29 mysqld_safe mysqld restarted

130508  1:00:36  InnoDB: Initializing buffer pool, size = 16.0M

130508  1:00:37  InnoDB: Completed initialization of buffer pool

130508  1:00:39  InnoDB: Started; log sequence number 0 44243

130508  1:00:41 [Note] Recovering after a crash using mysql-bin

130508  1:00:41 [Note] Starting crash recovery...

130508  1:00:41 [Note] Crash recovery finished.

130508  1:00:43 [Note] Event Scheduler: Loaded 0 events

130508  1:00:43 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.

Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

130508 01:17:37 mysqld_safe Number of processes running now: 0

130508 01:17:37 mysqld_safe mysqld restarted

130508  1:17:39  InnoDB: Initializing buffer pool, size = 16.0M

130508  1:17:39  InnoDB: Completed initialization of buffer pool

130508  1:17:40  InnoDB: Started; log sequence number 0 44243

130508  1:17:40 [Note] Recovering after a crash using mysql-bin

130508  1:17:40 [Note] Starting crash recovery...

130508  1:17:40 [Note] Crash recovery finished.

130508  1:17:40 [Note] Event Scheduler: Loaded 0 events

130508  1:17:40 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.

Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution