468x60

giovedì 17 giugno 2021

How to Kill MySQL Queries

The command SHOW PROCESSLIST lists all the open connections to the server

 mysql> SHOW PROCESSLIST;

In order to kill a thread completely, use the KILL command followed by the thread ID returned by SHOW PROCESSLIST:

mysql> KILL 1234;

468x60

Cerca su Google

Cerca nel Blog con Google