SELECT trx_mysql_thread_id FROM INNODB_TRX JOIN PROCESSLIST ON trx_mysql_thread_id=PROCESSLIST.ID WHERE trx_started < NOW() - INTERVAL 1 MINUTE

#!/bin/bash

set -e
set -u

epoch=$(date +%s)

while true
do
    mysql -se "SELECT ID,TIME_MS,INFO FROM INFORMATION_SCHEMA.processlist WHERE COMMAND = 'Sleep' AND Time > 0;" | while read id time_ms info
    do
        echo "killed_at: $epoch, id: $id, time_ms: $time_ms, info: $info" >> ./mysql_killed.log
        echo "Killed: ${id}, ${info}"
        mysql -se"KILL ${id};"
    done

    sleep 2
done