MySQL view current thread of execution _ close current some threads show Processlist_kill

Each connection to the mysqld is run in a separate thread, and you can use the show Processlist statement to see which threads are running and terminate a thread with the kill thread_id statement.

If you have super privileges, you can terminate all threads and statements. Otherwise, you can only view and terminate your own threads and statements.

You can also use the Mysqladmin processlist and mysqladmin kill commands to check and terminate threads.

1. SHOW processlist

2. Kill 6

3, again show processlist, can see the effect:

In most cases, it may take some time for the thread to terminate, because the terminating token will only be checked at a specific interval;

The thread is releasing the resource, and it's really dead after a while.

MySQL view current thread of execution _ close current some threads show Processlist_kill