4

I understand that I can set the value of the global MAX_EXECUTION_TIME by running (from mysql client):

SET GLOBAL MAX_EXECUTION_TIME

But how do I just inquire its value?

GET instead of SET does not seem to accomplish that.

0

1 Answer 1

7

SHOW VARIABLES LIKE 'MAX_EXECUTION_TIME' or select @@max_execution_time for retrieval.

"The execution timeout for SELECT statements, in milliseconds. If the value is 0, timeouts are NOT enabled." per documentation.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.