Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 5.7 Reference Manual
Preface and Legal Notices
General Information
Installing and Upgrading MySQL
Tutorial
MySQL Programs
MySQL Server Administration
Security
Backup and Recovery
Optimization
Language Structure
Character Sets, Collations, Unicode
Data Types
Functions and Operators
SQL Statements
The InnoDB Storage Engine
Alternative Storage Engines
Replication
Group Replication
MySQL Shell
Using MySQL as a Document Store
InnoDB Cluster
MySQL NDB Cluster 7.5 and NDB Cluster 7.6
Partitioning
Stored Objects
INFORMATION_SCHEMA Tables
MySQL Performance Schema
Performance Schema Quick Start
Performance Schema Build Configuration
Performance Schema Startup Configuration
Performance Schema Runtime Configuration
Performance Schema Event Timing
Performance Schema Event Filtering
Event Pre-Filtering
Pre-Filtering by Instrument
Pre-Filtering by Object
Pre-Filtering by Thread
Pre-Filtering by Consumer
Example Consumer Configurations
Naming Instruments or Consumers for Filtering Operations
Determining What Is Instrumented
Performance Schema Queries
Performance Schema Instrument Naming Conventions
Performance Schema Status Monitoring
Performance Schema Atom and Molecule Events
Performance Schema Tables for Current and Historical Events
Performance Schema Statement Digests
Performance Schema General Table Characteristics
Performance Schema Table Descriptions
Performance Schema Table Reference
Performance Schema Setup Tables
The setup_actors Table
The setup_consumers Table
The setup_instruments Table
The setup_objects Table
The setup_timers Table
Performance Schema Instance Tables
The cond_instances Table
The file_instances Table
The mutex_instances Table
The rwlock_instances Table
The socket_instances Table
Performance Schema Wait Event Tables
The events_waits_current Table
The events_waits_history Table
The events_waits_history_long Table
Performance Schema Stage Event Tables
The events_stages_current Table
The events_stages_history Table
The events_stages_history_long Table
Performance Schema Statement Event Tables
The events_statements_current Table
The events_statements_history Table
The events_statements_history_long Table
The prepared_statements_instances Table
Performance Schema Transaction Tables
The events_transactions_current Table
The events_transactions_history Table
The events_transactions_history_long Table
Performance Schema Connection Tables
The accounts Table
The hosts Table
The users Table
Performance Schema Connection Attribute Tables
The session_account_connect_attrs Table
The session_connect_attrs Table
Performance Schema User-Defined Variable Tables
Performance Schema Replication Tables
The replication_connection_configuration Table
The replication_connection_status Table
The replication_applier_configuration Table
The replication_applier_status Table
The replication_applier_status_by_coordinator Table
The replication_applier_status_by_worker Table
The replication_group_member_stats Table
The replication_group_members Table
Performance Schema Lock Tables
The metadata_locks Table
The table_handles Table
Performance Schema System Variable Tables
Performance Schema Status Variable Tables
Performance Schema Summary Tables
Wait Event Summary Tables
Stage Summary Tables
Statement Summary Tables
Transaction Summary Tables
Object Wait Summary Table
File I/O Summary Tables
Table I/O and Lock Wait Summary Tables
Socket Summary Tables
Memory Summary Tables
Status Variable Summary Tables
Performance Schema Miscellaneous Tables
The host_cache Table
The performance_timers Table
The processlist Table
The threads Table
Performance Schema Option and Variable Reference
Performance Schema Command Options
Performance Schema System Variables
Performance Schema Status Variables
The Performance Schema Memory-Allocation Model
Performance Schema and Plugins
Using the Performance Schema to Diagnose Problems
Query Profiling Using Performance Schema
Migrating to Performance Schema System and Status Variable Tables
Restrictions on Performance Schema
MySQL sys Schema
Connectors and APIs
MySQL Enterprise Edition
MySQL Workbench
MySQL 5.7 Frequently Asked Questions
Error Messages and Common Problems
Indexes
MySQL Glossary
Related Documentation
MySQL 5.7 Release Notes
Download this Manual
PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL NDB Cluster 7.5
version 5.7
9.1
9.0
8.4 current
8.0
8.0 Japanese
MySQL 5.7 Reference Manual
/
MySQL Performance Schema
/ Performance Schema Option and Variable Reference
25.13 Performance Schema Option and Variable Reference
Table 25.13 Performance Schema Variable Reference
Name
Cmd-Line
Option File
System Var
Status Var
Var Scope
Dynamic
performance_schema
Yes
Yes
Yes
Global
No
Performance_schema_accounts_lost
Yes
Global
No
performance_schema_accounts_size
Yes
Yes
Yes
Global
No
Performance_schema_cond_classes_lost
Yes
Global
No
Performance_schema_cond_instances_lost
Yes
Global
No
performance-schema-consumer-events-stages-current
Yes
Yes
performance-schema-consumer-events-stages-history
Yes
Yes
performance-schema-consumer-events-stages-history-long
Yes
Yes
performance-schema-consumer-events-statements-current
Yes
Yes
performance-schema-consumer-events-statements-history
Yes
Yes
performance-schema-consumer-events-statements-history-long
Yes
Yes
performance-schema-consumer-events-transactions-current
Yes
Yes
performance-schema-consumer-events-transactions-history
Yes
Yes
performance-schema-consumer-events-transactions-history-long
Yes
Yes
performance-schema-consumer-events-waits-current
Yes
Yes
performance-schema-consumer-events-waits-history
Yes
Yes
performance-schema-consumer-events-waits-history-long
Yes
Yes
performance-schema-consumer-global-instrumentation
Yes
Yes
performance-schema-consumer-statements-digest
Yes
Yes
performance-schema-consumer-thread-instrumentation
Yes
Yes
Performance_schema_digest_lost
Yes
Global
No
performance_schema_digests_size
Yes
Yes
Yes
Global
No
performance_schema_events_stages_history_long_size
Yes
Yes
Yes
Global
No
performance_schema_events_stages_history_size
Yes
Yes
Yes
Global
No
performance_schema_events_statements_history_long_size
Yes
Yes
Yes
Global
No
performance_schema_events_statements_history_size
Yes
Yes
Yes
Global
No
performance_schema_events_transactions_history_long_size
Yes
Yes
Yes
Global
No
performance_schema_events_transactions_history_size
Yes
Yes
Yes
Global
No
performance_schema_events_waits_history_long_size
Yes
Yes
Yes
Global
No
performance_schema_events_waits_history_size
Yes
Yes
Yes
Global
No
Performance_schema_file_classes_lost
Yes
Global
No
Performance_schema_file_handles_lost
Yes
Global
No
Performance_schema_file_instances_lost
Yes
Global
No
Performance_schema_hosts_lost
Yes
Global
No
performance_schema_hosts_size
Yes
Yes
Yes
Global
No
performance-schema-instrument
Yes
Yes
Performance_schema_locker_lost
Yes
Global
No
performance_schema_max_cond_classes
Yes
Yes
Yes
Global
No
performance_schema_max_cond_instances
Yes
Yes
Yes
Global
No
performance_schema_max_digest_length
Yes
Yes
Yes
Global
No
performance_schema_max_file_classes
Yes
Yes
Yes
Global
No
performance_schema_max_file_handles
Yes
Yes
Yes
Global
No
performance_schema_max_file_instances
Yes
Yes
Yes
Global
No
performance_schema_max_memory_classes
Yes
Yes
Yes
Global
No
performance_schema_max_metadata_locks
Yes
Yes
Yes
Global
No
performance_schema_max_mutex_classes
Yes
Yes
Yes
Global
No
performance_schema_max_mutex_instances
Yes
Yes
Yes
Global
No
performance_schema_max_prepared_statements_instances
Yes
Yes
Yes
Global
No
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_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_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_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_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_thread_classes_lost
Yes
Global
No
Performance_schema_thread_instances_lost
Yes
Global
No
Performance_schema_users_lost
Yes
Global
No
performance_schema_users_size
Yes
Yes
Yes
Global
No
PREV
HOME
UP
NEXT
Related Documentation
MySQL 5.7 Release Notes
Download this Manual
PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
MySQL NDB Cluster 7.5