How to put an execution time limit for MySQL Temporary table creation
4
votes
1
answer
2598
views
We can use
SET MAX_EXECUTION_TIME=10;
statement to stop the execution of a SELECT
statement, if it took more than 10 milliseconds to execute the query. But the same wont work for other statements like CREATE TEMPORARY TABLE
and INSERT
etc.
Reference: https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html#optimizer-hints-execution-time
Currently my temporary table creation takes more than 50s to complete. I want to put a limit like 10s. Is it possible in MySQL?
Asked by Sarath S Nair
(163 rep)
Mar 12, 2018, 05:34 AM
Last activity: Apr 26, 2025, 01:09 PM
Last activity: Apr 26, 2025, 01:09 PM