content_image/709844.jpg content_image/709852.jpg content_image/709851.jpg
<img src='content_image/709844.jpg'>

The maximum number of stage instruments. For information about how to set and use this variable, see Section 27.7, “Performance Schema Status Monitoring” . 

• performance_schema_max_statement_classes 

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

The maximum number of statement instruments. For information about how to set and use this variable, see Section 27.7, “Performance Schema Status Monitoring” . 

The default value is calculated at server build time based on the number of commands in the client/ server protocol and the number of SQL statement types supported by the server. 

This variable should not be changed, unless to set it to 0 to disable all statement instrumentation and save all memory associated with it. Setting the variable to nonzero values other than the default has no benefit; in particular, values larger than the default cause more memory to be allocated then is needed. 

• performance_schema_max_statement_stack 

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

The maximum depth of nested stored program calls for which the Performance Schema maintains statistics. When this maximum is exceeded, the Performance Schema increments the Performance_schema_nested_statement_lost  status variable for each stored program statement executed. 

