MySQL 5.7 Reference Manual
MySQL 5.7 Release Notes
Abstract
This is the MySQL Performance Schema extract from the MySQL 5.7 Reference Manual.
For legal information, see the Legal Notices.
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
Document generated on: 2024-10-04 (revision: 79903)
Table of Contents
- Preface and Legal Notices
- 1 MySQL Performance Schema
- 2 Performance Schema Quick Start
- 3 Performance Schema Build Configuration
- 4 Performance Schema Startup Configuration
- 5 Performance Schema Runtime Configuration
- 5.1 Performance Schema Event Timing
- 5.2 Performance Schema Event Filtering
- 5.3 Event Pre-Filtering
- 5.4 Pre-Filtering by Instrument
- 5.5 Pre-Filtering by Object
- 5.6 Pre-Filtering by Thread
- 5.7 Pre-Filtering by Consumer
- 5.8 Example Consumer Configurations
- 5.9 Naming Instruments or Consumers for Filtering Operations
- 5.10 Determining What Is Instrumented
- 6 Performance Schema Queries
- 7 Performance Schema Instrument Naming Conventions
- 8 Performance Schema Status Monitoring
- 9 Performance Schema General Table Characteristics
- 10 Performance Schema Table Descriptions
- 10.1 Performance Schema Table Reference
- 10.2 Performance Schema Setup Tables
- 10.3 Performance Schema Instance Tables
- 10.4 Performance Schema Wait Event Tables
- 10.5 Performance Schema Stage Event Tables
- 10.6 Performance Schema Statement Event Tables
- 10.7 Performance Schema Transaction Tables
- 10.8 Performance Schema Connection Tables
- 10.9 Performance Schema Connection Attribute Tables
- 10.10 Performance Schema User-Defined Variable Tables
- 10.11 Performance Schema Replication Tables
- 10.11.1 The replication_connection_configuration Table
- 10.11.2 The replication_connection_status Table
- 10.11.3 The replication_applier_configuration Table
- 10.11.4 The replication_applier_status Table
- 10.11.5 The replication_applier_status_by_coordinator Table
- 10.11.6 The replication_applier_status_by_worker Table
- 10.11.7 The replication_group_members Table
- 10.11.8 The replication_group_member_stats Table
- 10.12 Performance Schema Lock Tables
- 10.13 Performance Schema System Variable Tables
- 10.14 Performance Schema Status Variable Tables
- 10.15 Performance Schema Summary Tables
- 10.15.1 Wait Event Summary Tables
- 10.15.2 Stage Summary Tables
- 10.15.3 Statement Summary Tables
- 10.15.4 Transaction Summary Tables
- 10.15.5 Object Wait Summary Table
- 10.15.6 File I/O Summary Tables
- 10.15.7 Table I/O and Lock Wait Summary Tables
- 10.15.8 Socket Summary Tables
- 10.15.9 Memory Summary Tables
- 10.15.10 Status Variable Summary Tables
- 10.16 Performance Schema Miscellaneous Tables
- 11 Performance Schema and Plugins
- 12 Performance Schema System Variables
- 13 Performance Schema Status Variables
- 14 Using the Performance Schema to Diagnose Problems