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

Admin 1
Viewed 147571

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

limit time mysql sql
5 Answers

Please rewrite your query like

select /*+ MAX_EXECUTION_TIME(1000) */ * from table

this statement will kill your query after the specified time

user_45660660
Related