[乐意黎]MySQL日志 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5595ms.

如下所示, MySQL日志中有如下记录:

2018-07-03T01:14:23.720861Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8372ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-03T01:18:18.220232Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13804ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-03T01:20:05.130688Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12417ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-03T01:20:56.718211Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5595ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)

2018-07-03T01:23:15.650508Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5595ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)

 

解决方法: 

修改 my.cnf 文件

增加:

 

innodb_buffer_pool_size=125G

innodb_buffer_pool_instances=2

innodb_log_file_size=512M

innodb_log_files_in_group=2

innodb_page_cleaners=2


 

 

发布了430 篇原创文章 · 获赞 415 · 访问量 925万+
展开阅读全文

没有更多推荐了,返回首页

©️2019 CSDN 皮肤主题: 编程工作室 设计师: CSDN官方博客

分享到微信朋友圈

×

扫一扫,手机浏览