高手帮忙看看mysql挂掉的原因,有日志
昨天晚上10点多发现mysql挂了,也不知道是什么时候挂的,然后翻出昨天mysql的错误日志,下面是昨天全部的记录
- Assembly code
120828 12:31:52 InnoDB: Started; log sequence number 0 44243120828 12:31:52 [Note] Recovering after a crash using mysql-bin120828 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: 0120828 12:31:59 mysqld_safe mysqld restarted120828 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.0M120828 12:32:02 InnoDB: Completed initialization of buffer poolInnoDB: The log sequence number in ibdata files does not matchInnoDB: 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 doublewriteInnoDB: buffer...120828 12:32:08 InnoDB: Started; log sequence number 0 44243120828 12:32:08 [Note] Recovering after a crash using mysql-bin120828 12:32:09 [Note] Starting crash recovery...120828 12:32:09 [Note] Crash recovery finished.120828 12:32:09 [Note] Event Scheduler: Loaded 0 events120828 12:32:09 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.Version: '5.1.54-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution120828 12:32:17 mysqld_safe Number of processes running now: 0120828 12:32:17 mysqld_safe mysqld restarted120828 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.0M120828 12:32:18 InnoDB: Completed initialization of buffer poolInnoDB: The log sequence number in ibdata files does not matchInnoDB: 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 doublewriteInnoDB: buffer...120828 12:32:18 InnoDB: Started; log sequence number 0 44243120828 12:32:18 [Note] Recovering after a crash using mysql-bin120828 12:32:18 [Note] Starting crash recovery...120828 12:32:18 [Note] Crash recovery finished.120828 12:32:19 [Note] Event Scheduler: Loaded 0 events120828 12:32:19 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.Version: '5.1.54-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution120828 12:32:54 mysqld_safe Number of processes running now: 0120828 12:32:54 mysqld_safe mysqld restarted120828 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.0M120828 12:32:54 InnoDB: Completed initialization of buffer poolInnoDB: The log sequence number in ibdata files does not matchInnoDB: 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 doublewriteInnoDB: buffer...120828 12:32:59 mysqld_safe mysqld from pid file /usr/local/mysql/var/li519-164.pid ended120828 14:52:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var120828 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.0M120828 14:52:35 InnoDB: Completed initialization of buffer poolInnoDB: The log sequence number in ibdata files does not matchInnoDB: the log sequence number in the ib_logfiles!120828 14:52:35 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 doublewriteInnoDB: buffer...120828 14:52:36 InnoDB: Started; log sequence number 0 44243120828 14:52:36 [Note] Recovering after a crash using mysql-bin120828 14:52:37 [Note] Starting crash recovery...120828 14:52:37 [Note] Crash recovery finished.120828 14:52:37 [Note] Event Scheduler: Loaded 0 events120828 14:52:37 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.Version: '5.1.54-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution120828 14:53:05 mysqld_safe Number of processes running now: 0120828 14:53:05 mysqld_safe mysqld restarted120828 15:04:00 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var120828 15:04:01 [Note] Plugin 'FEDERATED' is disabled.120828 15:04:01 [Note] Plugin 'ndbcluster' is disabled.120828 15:04:01 InnoDB: Initializing buffer pool, size = 8.0M120828 15:04:01 InnoDB: Completed initialization of buffer poolInnoDB: The log sequence number in ibdata files does not matchInnoDB: the log sequence number in the ib_logfiles!120828 15:04:01 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 doublewriteInnoDB: buffer...120828 15:04:01 InnoDB: Started; log sequence number 0 44243120828 15:04:01 [Note] Recovering after a crash using mysql-bin120828 15:04:01 [Note] Starting crash recovery...120828 15:04:01 [Note] Crash recovery finished.120828 15:04:01 [Note] Event Scheduler: Loaded 0 events120828 15:04:01 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.Version: '5.1.54-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution120828 15:04:02 mysqld_safe A mysqld process already exists
[解决办法]
只有昨天下午三点的日志?
[解决办法]
[解决办法]
没有mysqld进程,重启mysql服务器。
[解决办法]
查看一下进程
ps -aux | grep mysqld