content_image/662844.jpg content_image/662849.jpg content_image/662855.jpg
<img src='content_image/662844.jpg'>

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” . 

• max_execution_time 

<img src='content_image/662849.jpg'>

The execution timeout for SELECT  statements, in milliseconds. If the value is 0, timeouts are not enabled. 

max_execution_time  applies as follows: 

•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. 

• 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. 

• max_execution_time  is ignored for SELECT  statements in stored programs. 

• max_heap_table_size 

<img src='content_image/662855.jpg'>

