InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation  For more information, see Help and Support Center at http://www.mysql.com.

https://blog.csdn.net/qq_42952310/article/details/102986498

my.iml 中 update/add  :
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

windows系统安装mysql, InnoDB: File .\ib_logfile0: ‘aio read‘ returned OS error 187. Cannot continue oper InnoDB: File .\ib_logfile0: 'aio read' returned OS error 187. Cannot continue operation For more information, see Help and Support Center at http://www.mysql.com. https://blog.csdn.net/qq_42952310/article/details/102986498my.iml 中 update/add :in... innodb _data_ file _path用来指定 innodb tablespace文件，如果我们不在My.cnf文件中指定 innodb _data_home_dir和 innodb _data_ file _path那么默认会在datadir目录下创建 ib data1 作为 innodb tablespace。 在测试环境下没有设置过多的详细参数就初始化并启动了服务，后期优化的过程中发现 innodb _data_ file _path设置过小： root@node1 14:59: [(none)]> show variables like '% innodb _data_ file _path%';