The other day a colleague and friend of mine, Peter Boros, had a case where one of our clients had to track down the process shutting down MySQL. This blog is based on the discussion we had about that internally.
Our client wanted Peter to identify the culprit behind periodic shutdowns. This proved to be slightly more difficult than usual, for reasons that you might guess from the title of this blog.
Here is what Peter saw in the logs:
150928 15:15:33 [Note] /usr/sbin/mysqld: Normal shutdown 150928 15:15:36 [Note] Event Scheduler: Purging the queue. 0 events 150928 15:15:39 [Warning] /usr/sbin/mysqld: Forcing close of thread 411515 user: 'dashboard' 150928 15:15:40 InnoDB: Starting shutdown... 150928 15:15:59 InnoDB: Shutdown completed; log sequence number 4873840375 150928 15:16:00 [Note] /usr/sbin/mysqld: Shutdown …[Read more]