InnoDB: page_cleaner DB Errors

Aetherdan · May 6, 2020

Hi Guys,

My forum is struggling these days 😞

The forum is constantly timing out, when i check the database logs i can see the following:

2020-05-06T02:12:00.555325Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7004ms. The settings might not be optimal. (flushed=412 and evicted=0, during the time.)
2020-05-06T02:12:41.497259Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4274ms. The settings might not be optimal. (flushed=155 and evicted=0, during the time.)
2020-05-06T02:13:02.705711Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4450ms. The settings might not be optimal. (flushed=181 and evicted=0, during the time.)
2020-05-06T02:13:10.180725Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4041ms. The settings might not be optimal. (flushed=112 and evicted=0, during the time.)
2020-05-06T02:13:20.464165Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6909ms. The settings might not be optimal. (flushed=441 and evicted=0, during the time.)
2020-05-06T02:13:31.730989Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7266ms. The settings might not be optimal. (flushed=442 and evicted=0, during the time.)
2020-05-06T02:14:02.772803Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4041ms. The settings might not be optimal. (flushed=149 and evicted=0, during the time.)
2020-05-06T02:14:26.089674Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8500ms. The settings might not be optimal. (flushed=549 and evicted=0, during the time.)
2020-05-06T02:14:36.056480Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6967ms. The settings might not be optimal. (flushed=451 and evicted=0, during the time.)

Also find attached a screenshot of all the background processes running after a server reboot! This database stuff has been ongoing for a few weeks now intermittently.

My database is MySQL on RDS (Amazon) Anyone experienced such issues? I have tried to tweak my innodb_page_cleaners settings with no success.