求助:docker的mysql配置出问题,系统报警告page_cleaner

风月无边 2020-05-14 12:15:48
最近使用docker搭建了一个mysql数据库进行测试,发现总是出现如下问题,甚是苦恼,调整参数好久也不见好,不知道为什么,来求助一下,是哪方面的原因,如何解决?

mysql57  | 2020-05-14T04:07:24.151431Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4252ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:07:38.309338Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4156ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:07:45.676443Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4367ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:07:55.043402Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4366ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:05.352199Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4307ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:12.785909Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4434ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:20.211744Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4426ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:41.410495Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4197ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:46.895191Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4484ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:55.280145Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4384ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:09:00.556009Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4275ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)



另外谁有好用的生产环境的mysql的docker-compose文件,发一个学习学习。谢谢。
...全文
736 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

56,687

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧