求助军哥，lnmp1.2的mysql突然挂了，附上日志，求解决
151031 04:01:36 mysqld_safe Number of processes running now: 0151031 04:01:37 mysqld_safe mysqld restarted
2015-10-31 04:01:39 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-10-31 04:01:39 8079 Plugin 'FEDERATED' is disabled.
2015-10-31 04:01:39 7f302b5e8720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-10-31 04:01:39 8079 InnoDB: Using atomics to ref count buffer pool pages
2015-10-31 04:01:39 8079 InnoDB: The InnoDB memory heap is disabled
2015-10-31 04:01:39 8079 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-10-31 04:01:39 8079 InnoDB: Memory barrier is not used
2015-10-31 04:01:39 8079 InnoDB: Compressed tables use zlib 1.2.3
2015-10-31 04:01:39 8079 InnoDB: Using CPU crc32 instructions
2015-10-31 04:01:39 8079 InnoDB: Initializing buffer pool, size = 16.0M
2015-10-31 04:01:39 8079 InnoDB: Completed initialization of buffer pool
2015-10-31 04:01:40 8079 InnoDB: Highest supported file format is Barracuda.
2015-10-31 04:01:40 8079 InnoDB: The log sequence numbers 4607677 and 4607677 in ibdata files do not match the log sequence number 4880103 in the ib_logfiles!
2015-10-31 04:01:40 8079 InnoDB: Database was not shutdown normally!
2015-10-31 04:01:40 8079 InnoDB: Starting crash recovery.
2015-10-31 04:01:40 8079 InnoDB: Reading tablespace information from the .ibd files...
2015-10-31 04:01:40 8079 InnoDB: Restoring possible half-written data pages
2015-10-31 04:01:40 8079 InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 624432200, file name mysql-bin.000012
2015-10-31 04:01:40 8079 InnoDB: 128 rollback segment(s) are active.
2015-10-31 04:01:40 8079 InnoDB: Waiting for purge to start
2015-10-31 04:01:40 8079 InnoDB: 5.6.23 started; log sequence number 4880103
2015-10-31 04:01:40 8079 Recovering after a crash using mysql-bin
2015-10-31 04:01:48 8079 Starting crash recovery...
2015-10-31 04:01:48 8079 Crash recovery finished.
2015-10-31 04:01:48 8079 Server hostname (bind-address): '*'; port: 3306
2015-10-31 04:01:48 8079 IPv6 is available.
2015-10-31 04:01:48 8079 - '::' resolves to '::';
2015-10-31 04:01:48 8079 Server socket created on IP: '::'.
2015-10-31 04:01:48 8079 Event Scheduler: Loaded 0 events
2015-10-31 04:01:48 8079 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.23-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
151031 04:03:28 mysqld_safe Number of processes running now: 0
151031 04:03:28 mysqld_safe mysqld restarted
2015-10-31 04:03:28 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-10-31 04:03:28 8238 Plugin 'FEDERATED' is disabled.
2015-10-31 04:03:28 7f9a6f9ba720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-10-31 04:03:28 8238 InnoDB: Using atomics to ref count buffer pool pages
2015-10-31 04:03:28 8238 InnoDB: The InnoDB memory heap is disabled
2015-10-31 04:03:28 8238 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-10-31 04:03:28 8238 InnoDB: Memory barrier is not used
2015-10-31 04:03:28 8238 InnoDB: Compressed tables use zlib 1.2.3
2015-10-31 04:03:28 8238 InnoDB: Using CPU crc32 instructions
2015-10-31 04:03:28 8238 InnoDB: Initializing buffer pool, size = 16.0M
2015-10-31 04:03:28 8238 InnoDB: Completed initialization of buffer pool
2015-10-31 04:03:29 8238 InnoDB: Highest supported file format is Barracuda.
2015-10-31 04:03:29 8238 InnoDB: The log sequence numbers 4607677 and 4607677 in ibdata files do not match the log sequence number 4880113 in the ib_logfiles!
2015-10-31 04:03:29 8238 InnoDB: Database was not shutdown normally!
2015-10-31 04:03:29 8238 InnoDB: Starting crash recovery.
2015-10-31 04:03:29 8238 InnoDB: Reading tablespace information from the .ibd files...
2015-10-31 04:03:29 8238 InnoDB: Restoring possible half-written data pages
2015-10-31 04:03:29 8238 InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 624432200, file name mysql-bin.000012
2015-10-31 04:03:29 8238 InnoDB: 128 rollback segment(s) are active.
2015-10-31 04:03:29 8238 InnoDB: Waiting for purge to start
2015-10-31 04:03:29 8238 InnoDB: 5.6.23 started; log sequence number 4880113
2015-10-31 04:03:29 8238 Recovering after a crash using mysql-bin
2015-10-31 04:03:29 8238 Starting crash recovery...
2015-10-31 04:03:29 8238 Crash recovery finished.
2015-10-31 04:03:29 8238 Server hostname (bind-address): '*'; port: 3306
2015-10-31 04:03:29 8238 IPv6 is available.
2015-10-31 04:03:29 8238 - '::' resolves to '::';
2015-10-31 04:03:29 8238 Server socket created on IP: '::'.
2015-10-31 04:03:29 8238 Event Scheduler: Loaded 0 events
2015-10-31 04:03:29 8238 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.23-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
151031 04:06:35 mysqld_safe Number of processes running now: 0
151031 04:06:35 mysqld_safe mysqld restarted
2015-10-31 04:06:36 0 TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-10-31 04:06:36 8465 Plugin 'FEDERATED' is disabled.
2015-10-31 04:06:36 7fcc2c177720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-10-31 04:06:36 8465 InnoDB: Using atomics to ref count buffer pool pages
2015-10-31 04:06:36 8465 InnoDB: The InnoDB memory heap is disabled
2015-10-31 04:06:36 8465 InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-10-31 04:06:36 8465 InnoDB: Memory barrier is not used
2015-10-31 04:06:36 8465 InnoDB: Compressed tables use zlib 1.2.3
2015-10-31 04:06:36 8465 InnoDB: Using CPU crc32 instructions
2015-10-31 04:06:36 8465 InnoDB: Initializing buffer pool, size = 16.0M
2015-10-31 04:06:36 8465 InnoDB: Completed initialization of buffer pool
151031 04:06:36 mysqld_safe mysqld from pid file /usr/local/mysql/var/DreamSever.pid ended
上面是错误信息，
因为每天4点我都定时执行数据库全部备份操作，之前没问题，就今天突然出错了！
备份脚本是：
#使用命令导出SQL数据库,并且按数据库分个压缩
for db in `mysql -u$MYSQL_USER -p$MYSQL_PASS -B -N -e 'SHOW DATABASES' | xargs`; do
(mysqldump -u$MYSQL_USER -p$MYSQL_PASS ${db} --events --skip-lock-tables | gzip -9 - > ${db}.sql.gz)
done
请军哥看下是那里的问题导致的，万分感谢！ 检查一下数据库目录权限
有监控没，崩溃时内存占用多少
前面都没问题，可以尝试删除/usr/local/mysql/var/下的ib_logfile0、ib_logfile1、ibdata1，然后重启试试
还不行可以尝试/etc/my.cnf 里加下面添加上
innodb_force_recovery = 3
试试 数据库占用内存挺高！
页:
[1]