mysqlkill-process

How to find MySQL process list and to kill those processes?

The MySQL database hangs, due to some queries.

How can I find the processes and kill them?

Solution

  • Here is the solution:

    1. Login to DB;
    2. Run a command SHOW FULL PROCESSLIST; to get the process id with status and query itself which causes the database hanging;
    3. Select the process id and run a command KILL <pid>; to kill that process.

    Sometimes it is not enough to kill each process manually. So, for that we've to go with some trick:

    1. Login to MySQL;
    2. Run a query SELECT CONCAT('KILL ',id,';') FROM information_schema.PROCESSLIST WHERE User='user'; to print all processes with KILL command;
    3. Copy the query result, paste and remove a pipe | sign, copy and paste all again into the query console. HIT ENTER. BooM it's done.