Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
On MySQL 5.7. I would like to prevent all alter table scripts \ update scripts that are taking longer than 10 minutes to run.
Is it possible?
I've tried to set MAX_EXECUTION_TIME and it does work but only for SELECT queries. I still could execute a long update\alter query.
No straightforward way.
You could write code to perform SHOW PROCESSLIST every minute, ignore system actions that run 'forever', locate only "alter/update" commands (but not scripts), check the "Time", and issue "kill pid".
If this is a team effort, I would (instead) implement a review process for every "alter/update script" to try to fix scripts before attempting them.
Keep in mind that killing a command after 10 minutes:
ROLLBACK (in the case of UPDATE), again wasting resources.