5

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.

datsb
  • 195
  • 1
  • 2
  • 6

1 Answers1

8

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.

danblack
  • 8,258
  • 2
  • 12
  • 28