mysql 停止运行 很可能是磁盘空间不够 df -lh 看看 有大用 有大大用

#service mysql status

 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

180924  8:04:42  InnoDB: Waiting for the background threads to start

180924  8:04:43 InnoDB: 5.5.54 started; log sequence number 163700321

180924  8:04:43 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

180924  8:04:43 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

180924  8:04:43 [Note] Server socket created on IP: '0.0.0.0'.

180924  8:05:25 [Note] Plugin 'FEDERATED' is disabled.

180924  8:05:26 InnoDB: The InnoDB memory heap is disabled

180924  8:05:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins

180924  8:05:26 InnoDB: Compressed tables use zlib 1.2.3

180924  8:05:26 InnoDB: Initializing buffer pool, size = 16.0M

180924  8:05:26 InnoDB: Completed initialization of buffer pool

180924  8:05:27 InnoDB: highest supported file format is Barracuda.

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

180924  8:05:27  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...

180924  8:07:35  InnoDB: Waiting for the background threads to start

180924  8:07:36 InnoDB: 5.5.54 started; log sequence number 163700321

180924  8:07:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

180924  8:07:36 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

180924  8:07:36 [Note] Server socket created on IP: '0.0.0.0'.

180924  8:07:37 [Note] Event Scheduler: Loaded 0 events

180924  8:07:37 [Note] /www/wdlinux/mysql-5.5.54/bin/mysqld: ready for connectio                             ns.

Version: '5.5.54'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

180924  8:23:15 [Note] Plugin 'FEDERATED' is disabled.

180924  8:23:15 InnoDB: The InnoDB memory heap is disabled

180924  8:23:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins

180924  8:23:15 InnoDB: Compressed tables use zlib 1.2.3

180924  8:23:16 InnoDB: Initializing buffer pool, size = 16.0M

180924  8:23:16 InnoDB: Completed initialization of buffer pool

180924  8:23:17 InnoDB: highest supported file format is Barracuda.

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

180924  8:23:17  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...

180925  4:14:03 [Note] Plugin 'FEDERATED' is disabled.

180925  4:14:03 InnoDB: The InnoDB memory heap is disabled

180925  4:14:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins

180925  4:14:03 InnoDB: Compressed tables use zlib 1.2.3

180925  4:14:03 InnoDB: Initializing buffer pool, size = 16.0M

180925  4:14:03 InnoDB: Completed initialization of buffer pool

180925  4:14:03 InnoDB: highest supported file format is Barracuda.

InnoDB: The log sequence number in ibdata files does not match

InnoDB: the log sequence number in the ib_logfiles!

180925  4:14:03  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...