Server System Variables System Variable max_error_count Scope Global, Session Dynamic Yes SET_VAR  Hint Applies Yes Type Integer Default Value 1024 Minimum Value 0 Maximum Value 65535 The maximum number of error, warning, and information messages to be stored for display by the  SHOW ERRORS  and  SHOW WARNINGS  statements. This is the same as the number of condition areas in the diagnostics area, and thus the number of conditions that can be inspected by  GET DIAGNOSTICS . As of MySQL 8.0.26, setting the session value of this system variable is a restricted operation. The session user must have privileges sufficient to set restricted session variables. See Section 5.1.9.1, “System Variable Privileges” . The execution timeout for  SELECT  statements, in milliseconds. If the value is 0, timeouts are not enabled. max_execution_time  applies as follows: Command-Line Format --max-execution-time=# System Variable max_execution_time Scope Global, Session Dynamic Yes SET_VAR  Hint Applies Yes Type Integer Default Value 0 • max_execution_time • max_heap_table_size • max_execution_time  is ignored for  SELECT  statements in stored programs. • max_execution_time  applies to read-only  SELECT  statements. Statements that are not read only are those that invoke a stored function that modifies data as a side effect. •The global  max_execution_time  value provides the default for the session value for new connections. The session value applies to  SELECT  executions executed within the session that include no  MAX_EXECUTION_TIME( N )  optimizer hint or for which  N  is 0. Command-Line Format --max-heap-table-size=# System Variable max_heap_table_size Scope Global, Session Dynamic Yes SET_VAR  Hint Applies Yes 831