In mysql 5.6.21 is there any variable available just like max_statement_time?

Question

can I limit the maximum time allowed for a query to run in mysql 5.6.21?

max_statement_time wasn't introduced until 5.7.4 – SteveFerg Oct 31 '15 at 07:06 — SteveFerg, Oct 31 '15 at 07:06

score 0 · Answer 1 · answered Oct 31 '15 at 06:52

0

Try this :-

time in milliseconds

SELECT MAX_STATEMENT_TIME = 1000 * FROM table;

or use this :-

SET GLOBAL MAX_STATEMENT_TIME=1000;

if its not work please try this :-

SHOW PROCESSLIST
Run KILL [process id]

answered Oct 31 '15 at 06:52

Abhishek Sharma

i am using version 5.6.21 for mysql. – patel sagar Oct 31 '15 at 06:58
http://stackoverflow.com/questions/4794747/mysql-can-i-limit-the-maximum-time-allowed-for-a-query-to-run – Abhishek Sharma Oct 31 '15 at 06:59
Please use `KILL QUERY [process id]`if you want to kill one particular query or it will kill all queries sharing this process id in the same session like a page request. – mgutt Feb 06 '17 at 20:16

1 Answers1