ubuntu mysql fail_ubuntu下处理mysql无法启动故障一例

故障现象：

mysql无法启动

1: dmesg |grep mysql

[101353.820000] init: mysql post-start process (9077) terminated with status 1

[101354.650000] init: mysql main process (9113) terminated with status 1

[101354.650000] init: mysql respawning too fast, stopped

2: grep mysql /var/log/syslog

213 Apr  1 19:35:33 Asiulo kernel: [101110.450000] init: mysql post-start process (8815) terminated with status 1

214 Apr  1 19:35:33 Asiulo kernel: [101110.590000] init: mysql main process (8846) terminated with status 1

215 Apr  1 19:35:33 Asiulo kernel: [101110.590000] init: mysql respawning too fast, stopped

3: tail -100 /var/log/mysql/error.log

1 130401 10:27:28 [Note] Plugin 'FEDERATED' is disabled.

2 130401 10:27:28 InnoDB: The InnoDB memory heap is disabled

3 130401 10:27:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins

4 130401 10:27:28 InnoDB: Compressed tables use zlib 1.2.7

5 130401 10:27:28 InnoDB: Using Linux native AIO

6 130401 10:27:28 InnoDB: Initializing buffer pool, size = 128.0M

7 130401 10:27:28 InnoDB: Completed initialization of buffer pool

8 130401 10:27:28 InnoDB: highest supported file format is Barracuda.

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

10 InnoDB: the log sequence number in the ib_logfiles!

11 130401 10:27:28  InnoDB: Database was not shut down norma