运行中的 mysql 突然关闭了

2018-11-15 10:30:35 3452 [Note] Plugin 'FEDERATED' is disabled. 2018-11-15 10:30:35 3452 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-11-15 10:30:35 3452 [Note] InnoDB: The InnoDB memory heap is disabled 2018-11-15 10:30:35 3452 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-11-15 10:30:35 3452 [Note] InnoDB: Memory barrier is not used 2018-11-15 10:30:35 3452 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-11-15 10:30:35 3452 [Note] InnoDB: Using CPU crc32 instructions 2018-11-15 10:30:35 3452 [Note] InnoDB: Initializing buffer pool, size = 512.0M 2018-11-15 10:30:35 3452 [Note] InnoDB: Completed initialization of buffer pool 2018-11-15 10:30:35 3452 [Note] InnoDB: Highest supported file format is Barracuda. 2018-11-15 10:30:36 3452 [Note] InnoDB: The log sequence numbers 329132395 and 329132395 in ibdata files do not match the log sequence number 341178818 in the ib_logfiles! 2018-11-15 10:30:36 3452 [Note] InnoDB: Database was not shutdown normally! 2018-11-15 10:30:36 3452 [Note] InnoDB: Starting crash recovery. 2018-11-15 10:30:36 3452 [Note] InnoDB: Reading tablespace information from the .ibd files... 2018-11-15 10:30:39 3452 [Note] InnoDB: Restoring possible half-written data pages 2018-11-15 10:30:39 3452 [Note] InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0 8014580, file name mysql-bin.000044 2018-11-15 10:30:41 3452 [Note] InnoDB: 128 rollback segment(s) are active. 2018-11-15 10:30:41 3452 [Note] InnoDB: Waiting for purge to start 2018-11-15 10:30:41 3452 [Note] InnoDB: 5.6.36 started; log sequence number 341178818 2018-11-15 10:30:41 3452 [Note] Recovering after a crash using mysql-bin 2018-11-15 10:30:41 3452 [Note] Starting crash recovery... 2018-11-15 10:30:41 3452 [Note] Crash recovery finished. 2018-11-15 10:30:42 3452 [Note] Server hostname (bind-address): '*'; port: 4580 2018-11-15 10:30:42 3452 [Note] IPv6 is available. 2018-11-15 10:30:42 3452 [Note] - '::' resolves to '::'; 2018-11-15 10:30:42 3452 [Note] Server socket created on IP: '::'. 2018-11-15 10:30:42 3452 [Note] Event Scheduler: Loaded 0 events 2018-11-15 10:30:42 3452 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.36-log' socket: '/tmp/mysql.sock' port: 4580 Source distribution 2018-11-15 10:40:16 5810 [Note] Plugin 'FEDERATED' is disabled. 2018-11-15 10:40:16 5810 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-11-15 10:40:16 5810 [Note] InnoDB: The InnoDB memory heap is disabled 2018-11-15 10:40:16 5810 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-11-15 10:40:16 5810 [Note] InnoDB: Memory barrier is not used 2018-11-15 10:40:16 5810 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-11-15 10:40:16 5810 [Note] InnoDB: Using CPU crc32 instructions 2018-11-15 10:40:16 5810 [Note] InnoDB: Initializing buffer pool, size = 512.0M 2018-11-15 10:40:16 5810 [Note] InnoDB: Completed initialization of buffer pool 2018-11-15 10:40:16 5810 [Note] InnoDB: Highest supported file format is Barracuda. 2018-11-15 10:40:16 5810 [Note] InnoDB: The log sequence numbers 329132395 and 329132395 in ibdata files do not match the log sequence number 341499308 in the ib_logfiles! 2018-11-15 10:40:16 5810 [Note] InnoDB: Database was not shutdown normally! 2018-11-15 10:40:16 5810 [Note] InnoDB: Starting crash recovery. 2018-11-15 10:40:16 5810 [Note] InnoDB: Reading tablespace information from the .ibd files... 2018-11-15 10:40:18 5810 [Note] InnoDB: Restoring possible half-written data pages 2018-11-15 10:40:18 5810 [Note] InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0 272993, file name mysql-bin.000045 2018-11-15 10:40:19 5810 [Note] InnoDB: 128 rollback segment(s) are active. 2018-11-15 10:40:19 5810 [Note] InnoDB: Waiting for purge to start 2018-11-15 10:40:19 5810 [Note] InnoDB: 5.6.36 started; log sequence number 341499308 2018-11-15 10:40:19 5810 [Note] Recovering after a crash using mysql-bin 2018-11-15 10:40:19 5810 [Note] Starting crash recovery... 2018-11-15 10:40:19 5810 [Note] Crash recovery finished. 2018-11-15 10:40:20 5810 [Note] Server hostname (bind-address): '*'; port: 4580 2018-11-15 10:40:20 5810 [Note] IPv6 is available. 2018-11-15 10:40:20 5810 [Note] - '::' resolves to '::'; 2018-11-15 10:40:20 5810 [Note] Server socket created on IP: '::'. 2018-11-15 10:40:20 5810 [Note] Event Scheduler: Loaded 0 events 2018-11-15 10:40:20 5810 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.36-log' socket: '/tmp/mysql.sock' port: 4580 Source distribution 2018-11-15 10:50:15 7647 [Note] Plugin 'FEDERATED' is disabled. 2018-11-15 10:50:15 7647 [Note] InnoDB: Using atomics to ref count buffer pool pages 2018-11-15 10:50:15 7647 [Note] InnoDB: The InnoDB memory heap is disabled 2018-11-15 10:50:15 7647 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-11-15 10:50:15 7647 [Note] InnoDB: Memory barrier is not used 2018-11-15 10:50:15 7647 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-11-15 10:50:15 7647 [Note] InnoDB: Using CPU crc32 instructions 2018-11-15 10:50:15 7647 [Note] InnoDB: Initializing buffer pool, size = 512.0M 2018-11-15 10:50:15 7647 [Note] InnoDB: Completed initialization of buffer pool 2018-11-15 10:50:15 7647 [Note] InnoDB: Highest supported file format is Barracuda. 2018-11-15 10:50:15 7647 [Note] InnoDB: The log sequence nubers 329132395 and 329132395 in ibdata files do not match the log sequence number 341872567 in the ib_logfiles! 2018-11-15 10:50:15 7647 [Note] InnoDB: Database was not shutdown normally! 2018-11-15 10:50:15 7647 [Note] InnoDB: Starting crash recovery. 2018-11-15 10:50:15 7647 [Note] InnoDB: Reading tablespace information from the .ibd files... 2018-11-15 10:50:18 7647 [Note] InnoDB: Restoring possible half-written data pages 2018-11-15 10:50:18 7647 [Note] InnoDB: from the doublewrite buffer... InnoDB: Last MySQL binlog file position 0 349361, file name mysql-bin.000046 

错误日志如上 zabbix 监控到内存 Lack of available memory

然后数据库就自动关闭了，是因为内存的不足，导致 do not match the log sequence 吗？