Description:
I have 5.7.6 installed on my laptop. Whenever it wakes from sleep, a warning is printed to the error log in the default configuration.
As a FR, it may be worth considering not printing these messages at least in the case that flushed=0, evicted=0.
How to repeat:
2015-02-10T01:57:53.839039Z 0 [Note] ./bin/mysqld: ready for connections.
Version: '5.7.6-m16-enterprise-commercial-advanced' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial)
2015-02-10T06:21:58.219933Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 3569335ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2015-02-10T10:47:26.011608Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4201645ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2015-02-10T16:07:19.557573Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19161233ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2015-02-10T17:11:04.015183Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 709758ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
Suggested fix:
if flushed=0 and evicted=0 skip message?
Kind of related to #71662 (InnoDB background threads should be configurable to reduce power consumption)
