今天在 navicat 中发现 mysql 很卡,本着重启试试的原则,先重启试试,于是先 service mysql stop,但是发现停服务也停半天,看日志发现一个问题
2016-12-10 10:53:30 2411 [Note] InnoDB: Waiting for purge thread to be suspended 2016-12-10 10:54:30 2411 [Note] InnoDB: Waiting for purge thread to be suspended 2016-12-10 10:55:30 2411 [Note] InnoDB: Waiting for purge thread to be suspended 2016-12-10 10:56:31 2411 [Note] InnoDB: Waiting for purge thread to be suspended 2016-12-10 10:57:31 2411 [Note] InnoDB: Waiting for purge thread to be suspended
这个过程持续了大约 10 分钟,终于才关掉,查了一下,看到一些说明,例如,http://m.blog.chinaunix.net/uid-20776139-id-5718603.html,https://www.percona.com/blog/2010/09/02/how-long-innodb-shutdown-may-take/,https://bugs.mysql.com/bug.php?id=58868,发现这个过程还不能强断,不然的话启动起来还要修复
PS,看看人家,连日志都这么有文采
2016-12-10 10:52:28 2411 [Note] Giving 34 client threads a chance to die gracefully 2016-12-10 10:52:28 2411 [Note] Event Scheduler: Purging the queue. 0 events 2016-12-10 10:52:28 2411 [Note] Shutting down slave threads 2016-12-10 10:52:30 2411 [Note] Forcefully disconnecting 29 remaining clients