snippetsqlMinor
How to inquire about current value of MAX_EXECUTION_TIME
Viewed 0 times
valuemax_execution_timeaboutcurrenthowinquire
Problem
I understand that I can set the value of the global MAX_EXECUTION_TIME by running (from mysql client):
But how do I just inquire its value?
GET instead of SET does not seem to accomplish that.
SET GLOBAL MAX_EXECUTION_TIMEBut how do I just inquire its value?
GET instead of SET does not seem to accomplish that.
Solution
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.
Context
StackExchange Database Administrators Q#285480, answer score: 7
Revisions (0)
No revisions yet.