暂无图片
MySQL日志报错
我来答
分享
暂无图片 匿名用户
MySQL日志报错

巡检发现MySQL 的错误日志中有如下错误(每天凌晨会有报错),哪位大佬帮忙瞅瞅,是否有需要调整的参数

2022-04-20T05:45:40.707831Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6480ms. The settings might not be optimal. (flushed=0 and evicted=206, during the time.)
2022-04-20T05:45:52.211153Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6130ms. The settings might not be optimal. (flushed=30 and evicted=0, during the time.)
2022-04-20T05:45:59.535947Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4092ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2022-04-20T05:46:19.702741Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5959ms. The settings might not be optimal. (flushed=2 and evicted=18, during the time.)
2022-04-20T05:46:49.064078Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11934ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2022-04-20T05:47:29.637584Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4098ms. The settings might not be optimal. (flushed=1 and evicted=7, during the time.)
2022-04-20T05:47:36.356332Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5718ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2022-04-20T05:50:02.965215Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4527ms. The settings might not be optimal. (flushed=1 and evicted=14, during the time.)
2022-04-20T05:50:46.533383Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4148ms. The settings might not be optimal. (flushed=0 and evicted=16, during the time.)
2022-04-20T05:51:41.744932Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4512ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2022-04-20T05:56:22.460767Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4374ms. The settings might not be optimal. (flushed=7 and evicted=148, during the time.)
2022-04-20T06:02:26.898372Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4859ms. The settings might not be optimal. (flushed=2 and evicted=193, during the time.)
2022-04-20T06:09:05.398142Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4038ms. The settings might not be optimal. (flushed=3 and evicted=145, during the time.)

我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
薛晓刚

看看是不是在做备份?

暂无图片 评论
暂无图片 有用 0
打赏 0
yangzhi825

这个系统要求每小时备份一次,但是这个报错是集中在凌晨的时候。

暂无图片 评论
暂无图片 有用 0
打赏 0
薛晓刚

备份的时候会有锁和阻塞。每小时我估计是你增量。凌晨全量。

我猜不会每小时都全量吧


全量阻塞的厉害一点。

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏