Show And Kill Threads in MySQL
Show And Kill Threads in MySQL:
We can see which threads are running with the SHOW PROCESSLIST statement. When we use this, it gives id (process id),user,host,database,state etc.. . If you have the PROCESS privilege,you can see all threads using the mysqladmin processlist command. Otherwise, you can see only your own threads. We can kill a thread with the KILL statement.
Syntax:
SHOW PROCESSLIST;
KILL [CONNECTION | QUERY] thread_id;
