Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic performance_schema_max_program_instances Yes Yes Yes Global No performance_schema_max_rwlock_classes Yes Yes Yes Global No performance_schema_max_rwlock_instances Yes Yes Yes Global No performance_schema_max_socket_classes Yes Yes Yes Global No performance_schema_max_socket_instances Yes Yes Yes Global No performance_schema_max_sql_text_length Yes Yes Yes Global No performance_schema_max_stage_classes Yes Yes Yes Global No performance_schema_max_statement_classes Yes Yes Yes Global No performance_schema_max_statement_stack Yes Yes Yes Global No performance_schema_max_table_handles Yes Yes Yes Global No performance_schema_max_table_instances Yes Yes Yes Global No performance_schema_max_table_lock_stat Yes Yes Yes Global No performance_schema_max_thread_classes Yes Yes Yes Global No performance_schema_max_thread_instances Yes Yes Yes Global No Performance_schema_memory_classes_lost Yes Global No Performance_schema_metadata_lock_lost Yes Global No Performance_schema_mutex_classes_lost Yes Global No Performance_schema_mutex_instances_lost Yes Global No Performance_schema_nested_statement_lost Yes Global No Performance_schema_prepared_statements_lost Yes Global No Performance_schema_program_lost Yes Global No Performance_schema_rwlock_classes_lost Yes Global No Performance_schema_rwlock_instances_lost Yes Global No Performance_schema_session_connect_attrs_longest_seen Yes Global No Performance_schema_session_connect_attrs_lost Yes Global No performance_schema_session_connect_attrs_size Yes Yes Yes Global No performance_schema_setup_actors_size Yes Yes Yes Global No performance_schema_setup_objects_size Yes Yes Yes Global No performance_schema_show_processlist Yes Yes Yes Global Yes Performance_schema_socket_classes_lost Yes Global No Performance_schema_socket_instances_lost Yes Global No Performance_schema_stage_classes_lost Yes Global No Performance_schema_statement_classes_lost Yes Global No Performance_schema_table_handles_lost Yes Global No Performance_schema_table_instances_lost Yes Global No Performance_schema_table_lock_stat_lost Yes Global No Performance_schema_thread_classes_lost Yes Global No Performance_schema_thread_instances_lost Yes Global No 680