Chapter 22 MySQL Performance Schema

Table of Contents

22.1 Performance Schema Quick Start
22.2 Performance Schema Configuration
22.2.1 Performance Schema Build Configuration
22.2.2 Performance Schema Startup Configuration
22.2.3 Performance Schema Runtime Configuration
22.3 Performance Schema Queries
22.4 Performance Schema Instrument Naming Conventions
22.5 Performance Schema Status Monitoring
22.6 Performance Schema Atom and Molecule Events
22.7 Performance Schema Statement Digests
22.8 Performance Schema General Table Characteristics
22.9 Performance Schema Table Descriptions
22.9.1 Performance Schema Table Index
22.9.2 Performance Schema Setup Tables
22.9.3 Performance Schema Instance Tables
22.9.4 Performance Schema Wait Event Tables
22.9.5 Performance Schema Stage Event Tables
22.9.6 Performance Schema Statement Event Tables
22.9.7 Performance Schema Connection Tables
22.9.8 Performance Schema Connection Attribute Tables
22.9.9 Performance Schema Summary Tables
22.9.10 Performance Schema Miscellaneous Tables
22.10 Performance Schema Option and Variable Reference
22.11 Performance Schema Command Options
22.12 Performance Schema System Variables
22.13 Performance Schema Status Variables
22.14 Performance Schema and Plugins
22.15 Using the Performance Schema to Diagnose Problems

The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has these characteristics:

The Performance Schema is intended to provide access to useful information about server execution while having minimal impact on server performance. The implementation follows these design goals: