innodb 日志文件异常引起innodb 启动失败
innodb 日志文件异常引起innodb 启动失败
110531 09:19:16 mysqld_safe Starting mysqld daemon with databases from /data/mysql_dataInnoDB: The InnoDB memory heap is disabledInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Compressed tables use zlib 1.2.3110531 9:19:17 InnoDB: Initializing buffer pool, size = 1.0G110531 9:19:17 InnoDB: Completed initialization of buffer pool110531 9:19:17 InnoDB: Log file ./ib_logfile0 did not exist: new to be createdInnoDB: Setting log file ./ib_logfile0 size to 10 MB（日志文件异常）InnoDB: Database physically writes the file full: wait...InnoDB: Error: all log files must be created at the same time.InnoDB: All log files must be created also in database creation.InnoDB: If you want bigger or smaller log files, shut down theInnoDB: database and make sure there were no errors in shutdown.InnoDB: Then delete the existing log files. Edit the .cnf file（需要删除redo文件，重建）InnoDB: and start the database again.110531 9:19:17 [ERROR] Plugin 'InnoDB' init function returned error.110531 9:19:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.110531 9:19:17 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist110531 9:19:17 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. The table is probably corrupted110531 9:19:17 [ERROR] mysql.user has no `Event_priv` column at position 29110531 9:19:17 [ERROR] Cannot open mysql.event110531 9:19:17 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.110531 9:19:17 [Note] /usr/local/mysql-5.1.57/bin/mysqld: ready for connections.Version: '5.1.57-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution110531 9:22:09 [Warning] Statement may not be safe to log in statement format. Statement: ALTER TABLE general_log MODIFY event_time TIMESTAMP NOT NULL, MODIFY user_host MEDIUMTEXT NOT NULL, MODIFY thread_id INTEGER NOT NULL, MODIFY server_id INTEGER UNSIGNED NOT NULL, MODIFY command_type VARCHAR(64) NOT NULL, MODIFY argument MEDIUMTEXT NOT NULL110531 9:22:09 [Warning] Statement may not be safe to log in statement format. Statement: ALTER TABLE slow_log MODIFY start_time TIMESTAMP NOT NULL, MODIFY user_host MEDIUMTEXT NOT NULL, MODIFY query_time TIME NOT NULL, MODIFY lock_time TIME NOT NULL, MODIFY rows_sent INTEGER NOT NULL, MODIFY rows_examined INTEGER NOT NULL, MODIFY db VARCHAR(512) NOT NULL, MODIFY last_insert_id INTEGER NOT NULL, MODIFY insert_id INTEGER NOT NULL, MODIFY server_id INTEGER UNSIGNED NOT NULL, MODIFY sql_text MEDIUMTEXT NOT NULL
?解决办法：
删除ib_logfile0 ib_logfile1 文件
重启mysql服务。
