我有一个 MySQL 服务器,它已经完美运行了 230 天。但今天早些时候,MySQL 似乎突然自行重启了。
mysql错误日志只有这个:
131126 17:04:40 InnoDB: The InnoDB memory heap is disabled
131126 17:04:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131126 17:04:40 InnoDB: Compressed tables use zlib 1.2.3.4
131126 17:04:40 InnoDB: Initializing buffer pool, size = 500.0M
131126 17:04:40 InnoDB: Completed initialization of buffer pool
131126 17:04:40 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 1094802773598
131126 17:04:40 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...
InnoDB: Doing recovery: scanned up to log sequence number 1094808016384
...
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 3 row operations to undo
InnoDB: Trx id counter is 135CA8E00
131126 17:10:58 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 4$
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 709588816, file name /var/log/mysql/mysql-bin.000808
InnoDB: Starting in background the rollback of uncommitted transactions
131126 17:11:25 InnoDB: Rolling back trx with id 135CA8B20, 3 rows to undo
131126 17:11:25 InnoDB: Waiting for the background threads to start
InnoDB: Rolling back of trx id 135CA8B20 completed
131126 17:11:25 InnoDB: Rollback of non-prepared transactions completed
131126 17:11:26 InnoDB: 1.1.8 started; log sequence number 1095025187164
131126 17:11:26 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
131126 17:11:40 [Note] Starting crash recovery...
131126 17:11:40 [Note] Crash recovery finished.
131126 17:11:42 [Note] Event Scheduler: Loaded 0 events
131126 17:11:42 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.29-0ubuntu0.12.04.2-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
我们观察到服务器没有承受任何压力。我们使用 ServerDensity 并查看了历史记录,没有发现任何异常。
什么可能导致 MySQL 像这样重新启动?我应该检查哪些日志文件来获取线索?
编辑
- 我找不到任何相关
dmesg
内容syslog