It would be cool/helpful/life affirming to be able to kill rds queries via innotop. Does anyone know if a plugin exists for this?
Here's why innotop can't kill queries out of the box: Amazon RDS doesn't allow the killing of queries in the same way as a standard mysql installation: access to KILL() is not allowed. Instead they provide the interface CALL mysql.rds_kill_query($query_id);.