Hi,
I see some queries are blocked in MV_BLOCKED_QUERIES and I want to delete them. I tried using the statement "KILLALL QUERIES LIKE ‘…’ " but it didn’t work and the blocked queries still appeared in the Active Queries page.
How can I delete these queries?
Thank you very much in advance.
You can kill all the blocked queries by issuing KILL statements for each one, identified by the Id returned by SHOW PROCESSLIST.
If you want to kill all blocked queries under program control, you can write an external application program that queries processlist or runs SHOW PROCESSLIST, then gather the “Id” values return for the blocked queries, and then issue “KILL” statements for each of them.
Hello Hanson!
It solved my problem. I created a program to execute a series of kill commands using the IDs obtained from the MV_BLOCKED_QUERIES table. Thanks for your suggestion.
1 Like