Performance Schema System Variables The maximum number of tables for which the Performance Schema maintains lock statistics. If this maximum is exceeded such that table lock statistics are lost, the Performance Schema increments the Performance_schema_table_lock_stat_lost  status variable. The maximum number of thread instruments. For information about how to set and use this variable, see Section 27.7, “Performance Schema Status Monitoring” . The maximum number of instrumented thread objects. The value controls the size of the  threads  table. If this maximum is exceeded such that a thread cannot be instrumented, the Performance Schema increments the  Performance_schema_thread_instances_lost  status variable. For information about how to set and use this variable, see Section 27.7, “Performance Schema Status Monitoring” . The  max_connections  system variable affects how many threads can run in the server. performance_schema_max_thread_instances  affects how many of these running threads can be instrumented. The  variables_by_thread  and  status_by_thread  tables contain system and status variable information only about foreground threads. If not all threads are instrumented by the Performance Schema, this table misses some rows. In this case, the Performance_schema_thread_instances_lost  status variable is greater than zero. 5116 • performance_schema_max_thread_instances • performance_schema_max_thread_classes Command-Line Format --performance-schema-max-thread- classes=# System Variable performance_schema_max_thread_classes Scope Global Dynamic No SET_VAR  Hint Applies No Type Integer Default Value 100 Minimum Value 0 Maximum Value ( ≥  8.0.12) 1024 Maximum Value (8.0.11) 256 Command-Line Format --performance-schema-max-thread- instances=# System Variable performance_schema_max_thread_instances Scope Global Dynamic No SET_VAR  Hint Applies No Type Integer Default Value -1  (signifies autoscaling; do not assign this literal value) Default Value -1  (signifies autosizing; do not assign this literal value)