MySQL Forums
Forum List  »  General

Monitor InnoDB slow shutdown
Posted by: Tim Huff
Date: June 22, 2018 02:38PM

I've initiated a slow InnoDB shutdown (innodb_fast_shutdown = 0), and it has been taking several hours. At the moment, it has been shutting down for over 24 hours. I've been watching the MySQL log, and the same two messages are repeating. "InnDB: Waiting for change buffer merge to complete number of bytes of change buffer just merged: 8576" and "InnoDB: Waiting for master thread to be suspended." While it is great to know that InnoDB is still doing something, is there any way to tell how much more cleaning up it has to do? The socket is gone so I can't use mysqladmin or the standard command line client. Thoughts?

Options: ReplyQuote


Subject
Written By
Posted
Monitor InnoDB slow shutdown
June 22, 2018 02:38PM


Sorry, you can't reply to this topic. It has been closed.

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.