MySQLでプロセスリストから遅いクエリのセッションをKILLするSQLを生成するSQL

processlist.md

SELECT
  *,
  CONCAT(CONCAT('KILL ', id), ';') AS KILL_SQL,
  CONCAT(CONCAT('CALL mysql.rds_kill(', id), ');') AS KILL_SQL_FOR_RDS
FROM
  INFORMATION_SCHEMA.PROCESSLIST
WHERE
  db = 'your_db'
  AND info LIKE '%probrem_query%'
  AND user = 'your_user'
  AND host LIKE '%your_host%'
  AND command LIKE 'Query'
  AND time > 10 -- sec
  AND id <> CONNECTION_ID()