Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Aetherdan Posted May 6, 2020 Posted 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.
bfarber Posted May 6, 2020 Posted May 6, 2020 https://stackoverflow.com/questions/41134785/how-to-solve-mysql-warning-innodb-page-cleaner-1000ms-intended-loop-took-xxx Aetherdan 1
Recommended Posts