如题,
查看错误日志显示:
2020-08-10 17:20:06 8596 [Note] Plugin 'FEDERATED' is disabled.
2020-08-10 17:20:06 8596 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-08-10 17:20:06 8596 [Note] InnoDB: The InnoDB memory heap is disabled
2020-08-10 17:20:06 8596 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-10 17:20:06 8596 [Note] InnoDB: Memory barrier is not used
2020-08-10 17:20:06 8596 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-10 17:20:06 8596 [Note] InnoDB: Not using CPU crc32 instructions
2020-08-10 17:20:06 8596 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2020-08-10 17:20:06 8596 [Note] InnoDB: Completed initialization of buffer pool
2020-08-10 17:20:06 8596 [Note] InnoDB: Highest supported file format is Barracuda.
2020-08-10 17:20:06 15ec InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2020-08-10 17:20:06 8596 [ERROR] InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation
在服务里面net start mysql 启动显示1067错误,
添加 default-storage-engine=MYISAM 没有效果,
解决方案为在在innodb配置节的最后加上
innodb_flush_method=normal