mysql 导入sql数据时报错

InnoDB: page_cleaner: 1000ms intended loop took ？？？？ms. The settings might 。。。。。

 

在配置文件中添加：

[mysqld]
innodb_buffer_pool_instances=8
innodb_io_capacity_max = 40000
innodb_io_capacity = 20000
innodb_buffer_pool_size = 125G
innodb_page_cleaners=8

innodb_page_cleaners和

innodb_buffer_pool_instances
尽量一致。