日志报错: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
Now you can resume the installation ad yoy see the service start.
Note, If the installation not continue... no problem, close ed remake the installation.
来源:
https://bugs.mysql.com/bug.php?id=85020
本文提供了一种解决InnoDB文件系统错误187的方法,通过调整MySQL配置文件my.ini中的InnoDB参数来修复该问题,包括缓冲池大小、日志文件大小等设置。

1843

被折叠的 条评论
为什么被折叠?



