How to set a maximum execution time for a mysql query?

mysql sql time limit
microry picture microry · Jan 6, 2009 · Viewed 106k times · Source

I would like to set a maximum execution time for sql queries like set_time_limit() in php. How can I do ?

Answer

Westy92 picture Westy92 · Apr 27, 2014

I thought it has been around a little longer, but according to this,

MySQL 5.7.4 introduces the ability to set server side execution time limits, specified in milliseconds, for top level read-only SELECT statements.

SELECT 
/*+ MAX_EXECUTION_TIME = 1000 */ --in milliseconds
* 
FROM table;

Note that this only works for read-only SELECT statements.

Update: This variable was added in MySQL 5.7.4 and renamed to max_execution_time in MySQL 5.7.8. (source)

Related questions

Mysql Datediff query

I need to get the result from the table, which the date should be difference of 5 from the current date. ie., specific_date column is present in my table. The format of the date is YYYY-MM-DD. I need the query …

Read More
mysql infile convert string to time format

I have a TSV that I'm trying to infile into a mySQL table. A couple columns are time formats, but they don't match the standard time format of HH:MM:SS, instead they look like HH:MM AM/PM I've …

Read More
Checking a table for time overlap?

I have a MySQL table with the following fields: name starttime endtime starttime and endtime are MySQL TIME fields (not DATETIME). I need a way to periodically "scan" the table to see if there are any overlaps in time ranges …

Read More