mysql服务器断电_mysql服务器断电引起的风波

我在虚拟机上模拟mysql服务器突然断电的场景，在mysql正常运行的情况下直接重启服务器，结果mysql数据库起不来了，详细情况如下：

环境：

操作系统           系统内核版本                                  mysql 版本

CentOS 5.4       Linux  2.6.18-164.el5  x86_64        5.6.14

1. 重启服务器后(模拟断电)，启动mysql报错

[root@langkeziju2 bin]# ./mysqld_safe --user=mysql &

131104 10:02:26 mysqld_safe Logging to '/data0/mysql-3307/data/langkeziju2.err'.

131104 10:02:26 mysqld_safe Starting mysqld daemon with databases from /data0/mysql-3307/data

131104 10:02:28 mysqld_safe mysqld from pid file /data0/mysql-3307/data/langkeziju2.pid ended

2.在错误日志中查看究竟

[root@langkeziju2 bin]# vi  /data0/mysql-3307/data/langkeziju2.err

2013-11-04 10:02:27 5816 [Note] InnoDB: The InnoDB memory heap is disabled

2013-11-04 10:02:27 5816 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2013-11-04 10:02:27 5816 [Note] InnoDB: Compressed tables use zlib 1.2.3

2013-11-04 10:02:27 5816 [Note] InnoDB: Using Linux native AIO

2013-11-04 10:02:27 5816 [Note] InnoDB: Using CPU crc32 instructions

2013-11-04 10:02:27 5816 [Note] InnoDB: Initializing buffer pool, size = 100.0M

2013-11-04 10:02:27 5816 [Note] InnoDB: Completed initialization of buffer pool

2013-11-04 10:02:28 5816 [Note] InnoDB: Highest supported file format is Barracuda.