This will display a list of active threads, including their `id`, `user`, `host`, `db`, `command`, `time`, `state`, and `info`.
Adjust the $THRESHOLD variable to your needs. Always test scripts in a controlled environment before running them on production systems. mysql kill long running queries
Look for:
: This command lists the current running queries. You can filter by time to find queries that have been running for a long time. This will display a list of active threads,
SELECT 'Killing thread id: ', id, ' with user: ', user, ' and query: ', info FROM information_schema.processlist WHERE command = 'Query' AND time > @time_limit; including their `id`
: For more detailed insights, query the information_schema.processlist or performance_schema.threads tables.
A simple bash script to find and kill queries older than a certain threshold: