mac windows系统安装mysql, InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot cont，

作者：你好赵伟 | 2024-06-30 13:42:11

踩

returned os error 187

日志报错：InnoDB: File .\ib_logfile101: ‘aio write’ returned OS error 187. Cannot continue operation

解决方法：

Make a fresh installation of mysql when it hang “in service start…”
make this:
open with notepad++ the file my.ini file and to innodb section add this:
#*** INNODB Specific options ***
innodb_buffer_pool_size = 256M
innodb_log_file_size = 256M
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = normal

Save the file, after
go a usually on windows
c:\ProgramData\MySQL\MySQL Server5.5\data and cancel this file:
DESKTOP-K1N1S7A.err
ib_logfile0
ib_logfile1
ibdata1
***简单粗暴在my.iml 中添加
innodb_buffer_pool_size = 256M
innodb_log_file_size = 256M
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = normal
然后启动

我的是安装时卡在 setart server***

https://bugs.mysql.com/bug.php?id=85020

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/你好赵伟/article/detail/772792