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.