MYSQL InnoDB page_cleaner

MYSQL提示

[Note] InnoDB: page_cleaner: 1000ms intended loop took 7111ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
[Note] InnoDB: page_cleaner: 1000ms intended loop took 8120ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
[Note] InnoDB: page_cleaner: 1000ms intended loop took 10863ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
[Note] InnoDB: page_cleaner: 1000ms intended loop took 4328ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)

原因
在MySQL 5.7.8中,innodb_page_cleaners默认值从1更改为4。 如果页面清除程序线程数超过缓冲池实例数,则innodb_page_cleaners将自动设置为与innodb_buffer_pool_instances相同的值.
解决方法

  • 1.检查对应参数
    mysql> SHOW GLOBAL VARIABLES LIKE 'innodb_buffer_pool_instances'
    innodb_page_cleaners | 1
  • 2.设置innodb_page_cleaners 大于当前值,如果要设置成4,则对应的innodb_buffer_pool_instances=4
点赞