Documentation Home
MySQL 9.2 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 259.7Kb
Man Pages (Zip) - 366.9Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.2 Reference Manual  / MySQL Performance Schema  /  Performance Schema Option and Variable Reference

29.13 Performance Schema Option and Variable Reference

Table 29.16 Performance Schema Variable Reference

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
performance_schemaYesYesYesGlobalNo
Performance_schema_accounts_lostYesGlobalNo
performance_schema_accounts_sizeYesYesYesGlobalNo
Performance_schema_cond_classes_lostYesGlobalNo
Performance_schema_cond_instances_lostYesGlobalNo
performance-schema-consumer-events-stages-currentYesYes
performance-schema-consumer-events-stages-historyYesYes
performance-schema-consumer-events-stages-history-longYesYes
performance-schema-consumer-events-statements-cpuYesYes
performance-schema-consumer-events-statements-currentYesYes
performance-schema-consumer-events-statements-historyYesYes
performance-schema-consumer-events-statements-history-longYesYes
performance-schema-consumer-events-transactions-currentYesYes
performance-schema-consumer-events-transactions-historyYesYes
performance-schema-consumer-events-transactions-history-longYesYes
performance-schema-consumer-events-waits-currentYesYes
performance-schema-consumer-events-waits-historyYesYes
performance-schema-consumer-events-waits-history-longYesYes
performance-schema-consumer-global-instrumentationYesYes
performance-schema-consumer-statements-digestYesYes
performance-schema-consumer-thread-instrumentationYesYes
Performance_schema_digest_lostYesGlobalNo
performance_schema_digests_sizeYesYesYesGlobalNo
performance_schema_events_stages_history_long_sizeYesYesYesGlobalNo
performance_schema_events_stages_history_sizeYesYesYesGlobalNo
performance_schema_events_statements_history_long_sizeYesYesYesGlobalNo
performance_schema_events_statements_history_sizeYesYesYesGlobalNo
performance_schema_events_transactions_history_long_sizeYesYesYesGlobalNo
performance_schema_events_transactions_history_sizeYesYesYesGlobalNo
performance_schema_events_waits_history_long_sizeYesYesYesGlobalNo
performance_schema_events_waits_history_sizeYesYesYesGlobalNo
Performance_schema_file_classes_lostYesGlobalNo
Performance_schema_file_handles_lostYesGlobalNo
Performance_schema_file_instances_lostYesGlobalNo
Performance_schema_hosts_lostYesGlobalNo
performance_schema_hosts_sizeYesYesYesGlobalNo
performance-schema-instrumentYesYes
Performance_schema_locker_lostYesGlobalNo
performance-schema-loggerYesYes
performance_schema_max_cond_classesYesYesYesGlobalNo
performance_schema_max_cond_instancesYesYesYesGlobalNo
performance_schema_max_digest_lengthYesYesYesGlobalNo
performance_schema_max_file_classesYesYesYesGlobalNo
performance_schema_max_file_handlesYesYesYesGlobalNo
performance_schema_max_file_instancesYesYesYesGlobalNo
performance_schema_max_logger_classesYesYesGlobalNo
performance_schema_max_memory_classesYesYesYesGlobalNo
performance_schema_max_metadata_locksYesYesYesGlobalNo
performance_schema_max_meter_classesYesYesYesGlobalNo
performance_schema_max_metric_classesYesYesYesGlobalNo
performance_schema_max_mutex_classesYesYesYesGlobalNo
performance_schema_max_mutex_instancesYesYesYesGlobalNo
performance_schema_max_prepared_statements_instancesYesYesYesGlobalNo
performance_schema_max_program_instancesYesYesYesGlobalNo
performance_schema_max_rwlock_classesYesYesYesGlobalNo
performance_schema_max_rwlock_instancesYesYesYesGlobalNo
performance_schema_max_socket_classesYesYesYesGlobalNo
performance_schema_max_socket_instancesYesYesYesGlobalNo
performance_schema_max_stage_classesYesYesYesGlobalNo
performance_schema_max_statement_classesYesYesYesGlobalNo
performance_schema_max_statement_stackYesYesYesGlobalNo
performance_schema_max_table_handlesYesYesYesGlobalNo
performance_schema_max_table_instancesYesYesYesGlobalNo
performance_schema_max_thread_classesYesYesYesGlobalNo
performance_schema_max_thread_instancesYesYesYesGlobalNo
Performance_schema_memory_classes_lostYesGlobalNo
Performance_schema_metadata_lock_lostYesGlobalNo
Performance_schema_meter_lostYesGlobalNo
Performance_schema_metric_lostYesGlobalNo
Performance_schema_mutex_classes_lostYesGlobalNo
Performance_schema_mutex_instances_lostYesGlobalNo
Performance_schema_nested_statement_lostYesGlobalNo
Performance_schema_prepared_statements_lostYesGlobalNo
Performance_schema_program_lostYesGlobalNo
Performance_schema_rwlock_classes_lostYesGlobalNo
Performance_schema_rwlock_instances_lostYesGlobalNo
Performance_schema_session_connect_attrs_lostYesGlobalNo
performance_schema_session_connect_attrs_sizeYesYesYesGlobalNo
performance_schema_setup_actors_sizeYesYesYesGlobalNo
performance_schema_setup_objects_sizeYesYesYesGlobalNo
Performance_schema_socket_classes_lostYesGlobalNo
Performance_schema_socket_instances_lostYesGlobalNo
Performance_schema_stage_classes_lostYesGlobalNo
Performance_schema_statement_classes_lostYesGlobalNo
Performance_schema_table_handles_lostYesGlobalNo
Performance_schema_table_instances_lostYesGlobalNo
Performance_schema_thread_classes_lostYesGlobalNo
Performance_schema_thread_instances_lostYesGlobalNo
Performance_schema_users_lostYesGlobalNo
performance_schema_users_sizeYesYesYesGlobalNo