日志报错: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