My Oracle Support Banner

MySQL 5.7 Log Messages: page_cleaner: 1000ms intended loop took 8120ms. The settings might not be optimal. (flushed=0 and evicted=25273, during the time.) (Doc ID 2014477.1)

Last updated on AUGUST 31, 2017

Applies to:

MySQL Server - Version 5.7 to 5.7 [Release 5.7]
Information in this document applies to any platform.

Goal

Guidance for configuring the server when seeing these messages frequently:

[Note] InnoDB: page_cleaner: 1000ms intended loop took 4120ms. The settings might not be optimal. (flushed=0 and evicted=85273, during the time.)
[Note] InnoDB: page_cleaner: 1000ms intended loop took 5280ms. The settings might not be optimal. (flushed=0 and evicted=117010, during the time.)
[Note] InnoDB: page_cleaner: 1000ms intended loop took 5338ms. The settings might not be optimal. (flushed=0 and evicted=135394, during the time.)
[Note] InnoDB: page_cleaner: 1000ms intended loop took 18890ms. The settings might not be optimal. (flushed=0 and evicted=18927, during the time.)
[Note] InnoDB: page_cleaner: 1000ms intended loop took 6591ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.