mysql如何查看事务日记_mysqlinnodb无法启动，查看系统事务日志为

1. 2017-07-27T03:16:42.462038Z 0 [ERROR] InnoDB: The

Auto-extending innodb_system data file

'/data/mysql/barry_mysql/data/ibdata1' is of a different size 768

pages (rounded down to MB) than specified in the .cnf file: initial

65536 pages, max 0 (relevant if non-zero) pages!

2. 2017-07-27T03:16:42.462105Z 0 [ERROR] InnoDB: Plugin

initialization aborted with error Generic error

3. 2017-07-27T03:16:43.563231Z 0 [ERROR] Plugin 'InnoDB' init

function returned error.

4. 2017-07-27T03:16:43.563302Z 0 [ERROR] Plugin 'InnoDB'

registration as a STORAGE ENGINE failed.

5. 2017-07-27T03:16:43.563323Z 0 [ERROR] Failed to initialize

plugins.

6. 2017-07-27T03:16:43.563338Z 0 [ERROR] Aborting

如果有日志2~5，可以尝试停止mysql，删除“mysql-5.7.13-winx64\data”中的ib_logfile1和ib_logfile0.然后重启

如果有日志1，可以同时删除ibdata1。以上错误容易发生在。更新InnoDB的日志文件计数器以跳过引起崩溃的查询，