Kill a process in MySQL

In MySQL to kill a process we have to first find out the process ID. For that purpose we need to look into the processlist using the following command.

          mysql> SHOW PROCESSLIST;

After identifying the proper ID of the process, to kill the process following command is used.

      mysql> KILL PROCESSID;

If the process is generated from a query then

      mysql> KILL QUERY PROCESSID;