How to solve mysql warning: “InnoDB: page_cleaner: 1000ms intended loop took XXX ms. The settings might not be optimal “?
InnoDB: page_cleaner: 1000ms intended loop took 4013ms. The settings might not be optimal. (flushed=1438 and evicted=0, during the time.) The problem is typical of a MySQL instance where you have a high rate of changes to the database. By running your 5GB import, you’re creating dirty pages rapidly. As dirty pages are created, the page … Read more