Home / server / Questions / 198545
Accepted
blunders
Asked: 2010-11-06 03:41:22 +0800 CST

What happens when you kill a process that has database tables locked?

  • 772

Trying to kill a process that running a MySQL database backup, and has the tables locked. What will happen if I kill the process?

mysql process kill

1 Answers

  1. Best Answer

    It depends on the process that is doing the backup. Also, it depends on the signal you have sent to the process.

    If you killed the process using a SIGTERM signal, the process may have implemented a proper signal handler. In this case, the process will be able to unlock the table before exiting.

    If you killed the process using a SIGKILL signal (kill -9), the process will not have a chance to clean things up before exiting. So, the tables will remain locked. In this case, only mysql server will be able to unlock the tables (I am not sure if it will really do this).

    • 1