Bug #76871 purge, change buffer, page cleaner threads be more verbose during long shutdown

Submitted: 28 Apr 2015 13:58
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.6.24 OS:Any
Assigned to: CPU Architecture:Any

[28 Apr 2015 13:58] Shane Bester
Description:
We may wonder what is going on here, since after shutdown command was 
given, we cannot connect to server to look:

2015-04-28 15:18:18 9420 [Note] InnoDB: FTS optimize thread exiting.
2015-04-28 15:18:18 9420 [Note] InnoDB: Starting shutdown...
2015-04-28 15:19:18 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:20:18 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:21:18 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:22:19 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:23:19 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:24:19 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:25:19 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:26:23 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:27:23 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:28:26 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:29:26 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:30:26 9420 [Note] InnoDB: Waiting for purge thread to be suspended
2015-04-28 15:31:06 9420 [Note] InnoDB: Shutdown completed; log sequence number 3292350589
2015-04-28 15:31:06 9420 [Note] Shutting down plugin 'BLACKHOLE'

How to repeat:
.

Suggested fix:
print any useful information that can show what is being done that delays the shutdown?
[6 May 2015 9:32] Simon Mudd
Or include some sort of progress information so it's clear how much longer we need to wait.

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

Page generated in 0.050 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.