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
尽量一致。