MySQL 响应缓慢

今天在 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

Leave a Reply

Your email address will not be published. Required fields are marked *