2
votes
1answer
350 views

MySQL: nothing listening on port 3306 but the processes still exist. How to graceful shutdown?

Percona-XtraDB-Cluster-server-5.5.24-23.6.340.rhel5 This is a slave server. mysqladmin shutdown hangs at: [Note] Event Scheduler: Purging the queue. 24 events [Note] Slave I/O thread killed while ...
1
vote
1answer
285 views

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

Trying to kill a process that running a MySQL database backup, and has the tables locked. What will happen if I kill the process?
4
votes
5answers
421 views

Give me my KILL-power when something goes wrong

We've had it a few times now. Suddenly our production server won't respond because a process is in an infinite loop, or the MySQL server stops serving new requests because one query is blocking ...