mysql how to kill individual process/query
Enter the console as root
mysql -u root -p
Then kill the process (where 1234 = the thread ID)
kill 1234
It's also a good idea to use a tool like "mtop" to monitor which processes and queries are slow, killing them is a temporary fix while you try to isolate the actual problem.
Tags:
mysql, individual, queryenter, console, quot, mtop, processes, queries, isolate,