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

by

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)

More Related Contents:

  1. Combining UNION and LIMIT operations in MySQL query
  2. Checking a table for time overlap?
  3. Recreating a query using INNER JOIN? [duplicate]
  4. Using LIMIT within GROUP BY to get N results per group?
  5. How to perform grouped ranking in MySQL
  6. MySQL Trigger after update only if row has changed
  7. MySQL “WITH” clause
  8. Ordering by specific field value first
  9. MySQL “Group By” and “Order By”
  10. How to change the CHARACTER SET (and COLLATION) throughout a database?
  11. MySQL Query to select data from last week?
  12. The total number of locks exceeds the lock table size
  13. update multiple rows using limit in mysql?
  14. Mysql 1050 Error “Table already exists” when in fact, it does not
  15. MySQL “IN” operator performance on (large?) number of values
  16. How to get the latest record in each group using GROUP BY? [duplicate]
  17. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  18. MySQL Select last 7 days
  19. SQL unique varchar case sensitivity question
  20. How do I count columns of a table
  21. Difference between two table structure
  22. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  23. How to retrieve JSON data from MySQL?
  24. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  25. Why MySQL is giving error “Not allowed to return a result set from a function”?
  26. When to use a left outer join?
  27. MySQL 5.6 – DENSE_RANK like functionality without Order By
  28. INSERT INTO Table from multiple tables
  29. Execute INSERT if table is empty?
  30. Mysql How do you create a clustered index?

Leave a Comment