Not the answer you need?
Register and ask your own question!

service mysql stop is being ignored. How to fix?

mwarblemwarble ContributorCurrent User Role Supporter
I'm running cluster 5.7 with MySQL 5.7 on Debian 9 and issuing a "service mysql stop" doesn't seem to do anything. If I issue "service mysql restart" it does seem to shutdown mysql gracefully and restart it. However, stop, does nothing. This is a problem because rebooting the node without stopping mysql first gracefully forces crash recovery on startup which takes quite a while and is unnecessary. Is there a fix or workaround for this problem?

Comments

  • alibelalibel Entrant Current User Role Novice
    Try
    mysqladmin -u root -p shutdown
    

    I have a similar problem on a cluster of three nodes.

    Do you have a new cluster installation with an empty database or was the database imported from another server?
  • Evgeniy PatlanEvgeniy Patlan Percona Percona Staff Role
    Hi. In general it depends on the way you have started mysql process.
    If you have started mysql as
    service mysql start
    then
    service mysql stop
    should help you to stop it.
    In case you have started
    /etc/init.d/mysql bootstrap-pxc
    So in this case you should stop bootstrapped node using
    /etc/init.d/mysql bootstrap-stop
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.