• MySQL매뉴얼
    • MySQL 5.6 매뉴얼
    • MySQL 5.1 매뉴얼
    • MySQL 5.0 매뉴얼
    • MySQL HA 매뉴얼
  • 기술문서
    • Xtrabackup 구성
    • 메모리 사용량 모니터링
  • 라이선스
  • 온라인문의
  • 회사소개
  • → 목 록 (MySQL5.6 한글메뉴얼) [close]
  • 1. MySQL 5.6 새로운 기능
  • 2. MySQL 설치 및 업그레이드
  • 3. MySQL Tutorial
  • 4. MySQL 프로그램
  • 5. MySQL 서버관리
  • 6. 보안
  • 7. 백업 및 복구
  • 8. 최적화
  • 9. Language Structure(언어구조)
  • 10. Character Sets(Globalization)
  • 11. 데이터형(Data Types)
  • 12. 함수와 연산자
  • 13. SQL 문법
  • 14. InnoDB 스토리지 엔진
  • 15. 기타 스토리지 엔진
  • 16. 고가용성 및 확장성
  • 17. 리플리케이션
  • 18. MySQL Cluster
  • 19. 파티셔닝
  • 20. Stored Programs and Views
  • 21. INFORMATION_SCHEMA
  • 22. PERFORMANCE SCHEMA
  • 1. Performance Schema 빠른 시작
    2. Performance Schema 구성
    3. Performance Schema 쿼리
    4. Performance Schema Instrument Naming Conventions
    5. Performance Schema Status Monitoring
    6. Performance Schema Atom and Molecule Events
    7. Performance Schema Statement Digests
    8. Performance Schema의 일반적인 테이블 특성
    9. Performance Schema 테이블 설명
    10. Performance Schema Option and Variable Reference
    11. Performance Schema Command Options
    12. Performance Schema System Variables
    13. Performance Schema Status Variables
    14. Performance Schema and Plugins
    15. 문제를 진단하기위한 Performance Schema 사용
  • 23. 컨넥터 및 API
  • 24. MySQL 확장
  • 25. MySQL Enterprise Edition
  • 26. MySQL Workbench
  • 27. 제약 및 제한
  • 28. MySQL 5.7 새로운 기능

22.10 Performance Schema Option and Variable Reference

Table 22.3 Performance Schema Variable Reference

NameCmd-LineOption FileSystem VarStatus VarVar ScopeDynamic
performance_schemaYesYesYes
GlobalNo
Performance_schema_accounts_lost


YesGlobalNo
performance_schema_accounts_sizeYesYesYes
GlobalNo
Performance_schema_cond_classes_lost


YesGlobalNo
Performance_schema_cond_instances_lost


YesGlobalNo
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-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_lost


YesGlobalNo
performance_schema_digests_sizeYesYesYes
GlobalNo
performance_schema_events_stages_history_long_sizeYesYesYes
GlobalNo
performance_schema_events_stages_history_sizeYesYesYes
GlobalNo
performance_schema_events_statements_history_long_sizeYesYesYes
GlobalNo
performance_schema_events_statements_history_sizeYesYesYes
GlobalNo
performance_schema_events_waits_history_long_sizeYesYesYes
GlobalNo
performance_schema_events_waits_history_sizeYesYesYes
GlobalNo
Performance_schema_file_classes_lost


YesGlobalNo
Performance_schema_file_handles_lost


YesGlobalNo
Performance_schema_file_instances_lost


YesGlobalNo
Performance_schema_hosts_lost


YesGlobalNo
performance_schema_hosts_sizeYesYesYes
GlobalNo
performance-schema-instrumentYesYes



Performance_schema_locker_lost


YesGlobalNo
performance_schema_max_cond_classesYesYesYes
GlobalNo
performance_schema_max_cond_instancesYesYesYes
GlobalNo
performance_schema_max_digest_lengthYesYesYes
GlobalNo
performance_schema_max_file_classesYesYesYes
GlobalNo
performance_schema_max_file_handlesYesYesYes
GlobalNo
performance_schema_max_file_instancesYesYesYes
GlobalNo
performance_schema_max_mutex_classesYesYesYes
GlobalNo
performance_schema_max_mutex_instancesYesYesYes
GlobalNo
performance_schema_max_rwlock_classesYesYesYes
GlobalNo
performance_schema_max_rwlock_instancesYesYesYes
GlobalNo
performance_schema_max_socket_classesYesYesYes
GlobalNo
performance_schema_max_socket_instancesYesYesYes
GlobalNo
performance_schema_max_stage_classesYesYesYes
GlobalNo
performance_schema_max_statement_classesYesYesYes
GlobalNo
performance_schema_max_table_handlesYesYesYes
GlobalNo
performance_schema_max_table_instancesYesYesYes
GlobalNo
performance_schema_max_thread_classesYesYesYes
GlobalNo
performance_schema_max_thread_instancesYesYesYes
GlobalNo
Performance_schema_mutex_classes_lost


YesGlobalNo
Performance_schema_mutex_instances_lost


YesGlobalNo
Performance_schema_rwlock_classes_lost


YesGlobalNo
Performance_schema_rwlock_instances_lost


YesGlobalNo
Performance_schema_session_connect_attrs_lost


YesGlobalNo
performance_schema_session_connect_attrs_sizeYesYesYes
GlobalNo
performance_schema_setup_actors_sizeYesYesYes
GlobalNo
performance_schema_setup_objects_sizeYesYesYes
GlobalNo
Performance_schema_socket_classes_lost


YesGlobalNo
Performance_schema_socket_instances_lost


YesGlobalNo
Performance_schema_stage_classes_lost


YesGlobalNo
Performance_schema_statement_classes_lost


YesGlobalNo
Performance_schema_table_handles_lost


YesGlobalNo
Performance_schema_table_instances_lost


YesGlobalNo
Performance_schema_thread_classes_lost


YesGlobalNo
Performance_schema_thread_instances_lost


YesGlobalNo
Performance_schema_users_lost


YesGlobalNo
performance_schema_users_sizeYesYesYes
GlobalNo


서울시 강남구 영동대로 602 6층
TEL: 02-6061-0006  /  E: csr@mysqlkorea.com
주식회사 이노클러스터  등록번호 : 727-86-02261
Copyright © innocluster Co. ltd. all rights reserved