Sample Header Ad - 728x90

Mysql - Set timeout for Alter table & Update scripts

0 votes
1 answer
1219 views
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.
Asked by Urbanleg (375 rep)
Sep 12, 2021, 11:57 AM
Last activity: Jun 1, 2025, 06:07 PM