• 首页
  • css3教程
  • html5教程
  • jQuery手册
  • vue手册
  • php手册
  • MySQL手册
  • apache手册
  • redis手册
  • 性能模式选项和变量参考

    Table 26.4 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-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_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_memory_classesYesYesYesGlobalNo
    performance_schema_max_metadata_locksYesYesYesGlobalNo
    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_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
    NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic