Bug #72703 page cleaner should be multi-threaded also for recovery and shutdown

• Submitted: 21 May 2014 6:46
• Modified: 31 Jul 2014 5:45
• Reporter: Yasufumi Kinoshita
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[21 May 2014 6:46] Yasufumi Kinoshita

Description:
From 5.7, page cleaner is multi-threaded for performance scalability.
But it is not used during shutdown and recovery phases.

It should be multi-threaded during shutdown and recovery phases for their optimal performance.

How to repeat:
During shutdown and recovery phases,
can be confirmed that buf_flush_page_cleaner_worker() is not worked.

Suggested fix:
make multi-threaded also for shutdown and recovery phases.

[28 Jul 2014 13:35] Daniel Price

Fixed as of the upcoming 5.7.5 release, and here's the changelog entry:

For optimal shutdown and recovery performance, shutdown and recovery
phases are now supported by the multi-threaded page cleaner feature
("innodb_page_cleaners") that was introduced in MySQL 5.7.4.

Also updated:
http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_page_cleaners
http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-5.html