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)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S4 (Feature request)
• Version: 5.6.24
• OS: Any
• 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.