Kill Mysql Query Info

SELECT CONCAT('KILL ', id, ';') AS kill_command FROM information_schema.processlist WHERE user = 'app_user' AND command != 'Sleep';

MySQL provides two distinct modifiers for the KILL statement depending on whether you want to end the specific query or the entire user connection. kill mysql query

Once you’ve identified the problematic query (e.g., ID 12345 ), note it down. SELECT CONCAT('KILL ', id, ';') AS kill_command FROM