由于数据库的不正常关机导致数据库无法启动
ps -ef|grep mysql
里面没有mysql的任何进程信息
service mysqld start 报错
错误1: mysql目录下面的tmp目录不见了
错误2:
然后在alter日志里面发现以下错误信息:
121016 19:16:19 InnoDB: The InnoDB memory heap is disabled
121016 19:16:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121016 19:16:19 InnoDB: Compressed tables use zlib 1.2.3
121016 19:16:19 InnoDB: Using Linux native AIO
121016 19:16:19 InnoDB: Initializing buffer pool, size = 10.0G
121016 19:16:20 InnoDB: Completed initialization of buffer pool
121016 19:16:20 InnoDB: highest supported file format is Barracuda.
121016 19:16:20 InnoDB: Waiting for the background threads to start
121016 19:16:21 Percona XtraDB (http://www.percona.com) 1.1.7-20.1 started; log sequence number 825493261848
/data1/mysql/bin/mysqld: File '/data1/mysql/log/mysql-bin.001618