高手帮忙看看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_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 doublewrite InnoDB: buffer... 120828 14:52:36 InnoDB: Started; log sequence number 0 44243 120828 14:52:36 [Note] Recovering after a crash using mysql-bin 120828 14:52:37 [Note] Starting crash recovery... 120828 14:52:37 [Note] Crash recovery finished. 120828 14:52:37 [Note] Event Scheduler: Loaded 0 events 120828 14:52:37 [Note] /usr/local/mysql/libexec/mysqld: ready for connections. Version: '5.1.54-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 120828 14:53:05 mysqld_safe Number of processes running now: 0 120828 14:53:05 mysqld_safe mysqld restarted 120828 15:04:00 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var 120828 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.0M 120828 15:04:01 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 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 doublewrite InnoDB: buffer... 120828 15:04:01 InnoDB: Started; log sequence number 0 44243 120828 15:04:01 [Note] Recovering after a crash using mysql-bin 120828 15:04:01 [Note] Starting crash recovery... 120828 15:04:01 [Note] Crash recovery finished. 120828 15:04:01 [Note] Event Scheduler: Loaded 0 events 120828 15:04:01 [Note] /usr/local/mysql/libexec/mysqld: ready for connections. Version: '5.1.54-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 120828 15:04:02 mysqld_safe A mysqld process already exists
欢迎大家阅读《好手帮忙看看mysql挂掉的原因,有日志》,跪求各位点评,by 搞代码
微信 赏一包辣条吧~
支付宝 赏一听可乐吧~