日期:2014-05-16  浏览次数:20821 次

高手帮忙看看mysql挂掉的原因,有日志
昨天晚上10点多发现mysql挂了,也不知道是什么时候挂的,然后翻出昨天mysql的错误日志,下面是昨天全部的记录

Assembly code

120828 12:31:52  InnoDB: Started; log sequence number 0 44243
120828 12:31:52 [Note] Recovering after a crash using mysql-bin
120828 12:31:52 [Note] Starting crash recovery...
120828 12:31:52 [Note] Crash recovery finished.
120828 12:31:59 mysqld_safe Number of processes running now: 0
120828 12:31:59 mysqld_safe mysqld restarted
120828 12:32:00 [Note] Plugin 'FEDERATED' is disabled.
120828 12:32:00 [Note] Plugin 'ndbcluster' is disabled.
120828 12:32:02  InnoDB: Initializing buffer pool, size = 8.0M
120828 12:32:02  InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120828 12:32:02  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120828 12:32:08  InnoDB: Started; log sequence number 0 44243
120828 12:32:08 [Note] Recovering after a crash using mysql-bin
120828 12:32:09 [Note] Starting crash recovery...
120828 12:32:09 [Note] Crash recovery finished.
120828 12:32:09 [Note] Event Scheduler: Loaded 0 events
120828 12:32:09 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120828 12:32:17 mysqld_safe Number of processes running now: 0
120828 12:32:17 mysqld_safe mysqld restarted
120828 12:32:18 [Note] Plugin 'FEDERATED' is disabled.
120828 12:32:18 [Note] Plugin 'ndbcluster' is disabled.
120828 12:32:18  InnoDB: Initializing buffer pool, size = 8.0M
120828 12:32:18  InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120828 12:32:18  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120828 12:32:18  InnoDB: Started; log sequence number 0 44243
120828 12:32:18 [Note] Recovering after a crash using mysql-bin
120828 12:32:18 [Note] Starting crash recovery...
120828 12:32:18 [Note] Crash recovery finished.
120828 12:32:19 [Note] Event Scheduler: Loaded 0 events
120828 12:32:19 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
120828 12:32:54 mysqld_safe Number of processes running now: 0
120828 12:32:54 mysqld_safe mysqld restarted
120828 12:32:54 [Note] Plugin 'FEDERATED' is disabled.
120828 12:32:54 [Note] Plugin 'ndbcluster' is disabled.
120828 12:32:54  InnoDB: Initializing buffer pool, size = 8.0M
120828 12:32:54  InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120828 12:32:54  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120828 12:32:59 mysqld_safe mysqld from pid file /usr/local/mysql/var/li519-164.pid ended
120828 14:52:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
120828 14:52:35 [Note] Plugin 'FEDERATED' is disabled.
120828 14:52:35 [Note] Plugin 'ndbcluster' is disabled.
120828 14:52:35  InnoDB: Initializing buffer pool, size = 8.0M
120828 14:52:35  InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log