Bug #75846 page_cleaner thread configuration warning spams error log on laptops

Submitted: 10 Feb 2015 17:17
Reporter: Morgan Tocker Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.7.6 OS:Any
Assigned to: CPU Architecture:Any

[10 Feb 2015 17:17] Morgan Tocker
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)
[17 May 2015 10:08] Daniƫl van Eeden
Also happends on 5.7.7-rc
[12 Dec 2017 21:29] Sveta Smirnova
Duplicate of bug #76661?

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.