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