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 8.0 Reference Manual
Preface and Legal Notices
General Information
Installing MySQL
Upgrading MySQL
Downgrading 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
MySQL Data Dictionary
The InnoDB Storage Engine
Alternative Storage Engines
Replication
Group Replication
MySQL Shell
Using MySQL as a Document Store
InnoDB Cluster
InnoDB ReplicaSet
MySQL NDB Cluster 8.0
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 and Sampling
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_threads 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_asynchronous_connection_failover Table
The replication_asynchronous_connection_failover_managed 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_applier_global_filters Table
The replication_applier_filters Table
The replication_group_members Table
The replication_group_member_stats Table
The replication_group_member_actions Table
The replication_group_configuration_version Table
The replication_group_communication_information Table
The binary_log_transaction_compression_stats Table
Performance Schema NDB Cluster Tables
The ndb_sync_pending_objects Table
The ndb_sync_excluded_objects Table
Performance Schema Lock Tables
The data_locks Table
The data_lock_waits Table
The metadata_locks Table
The table_handles Table
Performance Schema System Variable Tables
Performance Schema persisted_variables Table
Performance Schema variables_info Table
Performance Schema Status Variable Tables
Performance Schema Thread Pool Tables
The tp_thread_group_state Table
The tp_thread_group_stats Table
The tp_thread_state Table
Performance Schema Firewall Tables
The firewall_groups Table
The firewall_group_allowlist Table
The firewall_membership Table
Performance Schema Keyring Tables
The keyring_component_status Table
The keyring_keys table
Performance Schema Clone Tables
The clone_status Table
The clone_progress Table
Performance Schema Summary Tables
Wait Event Summary Tables
Stage Summary Tables
Statement Summary Tables
Statement Histogram 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
Error Summary Tables
Status Variable Summary Tables
Performance Schema Miscellaneous Tables
The component_scheduler_tasks Table
The error_log Table
The host_cache Table
The innodb_redo_log_files Table
The log_status Table
The performance_timers Table
The processlist Table
The threads Table
The tls_channel_status Table
The user_defined_functions 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
Obtaining Parent Event Information
Restrictions on Performance Schema
MySQL sys Schema
Connectors and APIs
MySQL Enterprise Edition
MySQL Workbench
MySQL on OCI Marketplace
MySQL 8.0 Frequently Asked Questions
Error Messages and Common Problems
Indexes
MySQL Glossary
Related Documentation
MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Download this Manual
PDF (US Ltr)
- 43.1Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.0Kb
Man Pages (Zip)
- 401.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
Security in MySQL
Starting and Stopping MySQL
MySQL and Linux/Unix
MySQL and Windows
MySQL and macOS
MySQL and Solaris
Building MySQL from Source
MySQL Restrictions and Limitations
MySQL Partitioning
MySQL Tutorial
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL NDB Cluster 8.0
version 8.0
9.0
8.4 current
5.7
8.0 Japanese
MySQL 8.0 Reference Manual
/
MySQL Performance Schema
/ Performance Schema Option and Variable Reference
29.13 Performance Schema Option and Variable Reference
Table 29.18 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-cpu
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 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Download this Manual
PDF (US Ltr)
- 43.1Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.0Kb
Man Pages (Zip)
- 401.3Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
Security in MySQL
Starting and Stopping MySQL
MySQL and Linux/Unix
MySQL and Windows
MySQL and macOS
MySQL and Solaris
Building MySQL from Source
MySQL Restrictions and Limitations
MySQL Partitioning
MySQL Tutorial
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL NDB Cluster 8.0