Hi
How about giving all users (or at least a group of "senior" users) a way to kill long running queries (if not whitelisted)? It has been policy for some time now that anything running more than an hour unannounced can be killed - so why not allow more people to do it?
This is a good idea, but then this could be done automatically too.
It think on something like a cronjob that searches for long running queries every 15 minutes, sends an email to the user if the query was running longer than 30 minutes and kills them after two hours.
BTW, is it possible to give the replication process a higher priority within the database server?
regards, Aka