auto restart on kill

Sorry if this is a FAQ - I’ve googled high and low for an answer and not found anything specific.

I’m running Percona 5.6.29 under ubuntu 14.04. Recently, I had to issue “kill -9” to shut down a mysqld process (I really had no option - I’d issued a normal service shutdown command which had triggered mysqladmin shutdown; the error log showed clearly that the shutdown process had started; after 20 minutes, it had still not shut down fully; I verified that no data was being written to either the error log or to any files in the database directory.)

After the “kill -9”, mysqld restarted automatically (and - fortunately - successfully.)

My question is - how can mysqld be prevented from restarting automatically after a “kill -9”? I appreciate that under normal conditions, if mysql crashes for some reason, it should try to restart (I think.) However, in this particular case, I really didn’t want it to restart before I had had a chance to look through the logs and do other forensic checks and cleanups. If there had been a serious error condition, an automatic restart could have resulted in even more damage.

MySQL uses two processes, mysqld and mysqld_safe, if you kill mysqld process only and leave mysqld_safe running it will spawn another mysqld process. If you need to kill mysql kill both mysqld and mysqld_safe processes (kill -9 pidof_mysqld pidof_mysqld_safe)