Mysql Kill A Query Page

The next morning, Maya added a monitoring alert for queries running longer than 60 seconds. She also taught the dev team how to catch themselves:

-- Find long-running queries SELECT id, user, time, state, info FROM information_schema.PROCESSLIST WHERE command != 'Sleep' AND time > 60; -- Kill one KILL QUERY <id>; mysql kill a query

“API latency > 5 seconds. 500 errors spike.” The next morning, Maya added a monitoring alert