Performance Schema System Variables • performance_schema_max_file_instances • performance_schema_max_index_stat • performance_schema_max_memory_classes 5109 The maximum number of memory instruments. For information about how to set and use this variable, see Section 27.7, “Performance Schema Status Monitoring” . The maximum number of indexes for which the Performance Schema maintains statistics. If this maximum is exceeded such that index statistics are lost, the Performance Schema increments the Performance_schema_index_stat_lost  status variable. The default value is autosized using the value of  performance_schema_max_table_instances . The maximum number of instrumented file objects. For information about how to set and use this variable, see Section 27.7, “Performance Schema Status Monitoring” . Command-Line Format --performance-schema-max-file- instances=# System Variable performance_schema_max_file_instances Scope Global Dynamic No SET_VAR  Hint Applies No Type Integer Default Value -1  (signifies autoscaling; do not assign this literal value) Command-Line Format --performance-schema-max-index-stat=# System Variable performance_schema_max_index_stat Scope Global Dynamic No SET_VAR  Hint Applies No Type Integer Default Value -1  (signifies autosizing; do not assign this literal value) Command-Line Format --performance-schema-max-memory- classes=# System Variable performance_schema_max_memory_classes Scope Global Dynamic No SET_VAR  Hint Applies No Type Integer Default Value 450