Chapter 21 MySQL Performance Schema

Table of Contents

21.1 Performance Schema Quick Start
21.2 Performance Schema Configuration
21.2.1 Performance Schema Build Configuration
21.2.2 Performance Schema Startup Configuration
21.2.3 Performance Schema Runtime Configuration
21.3 Performance Schema Queries
21.4 Performance Schema Instrument Naming Conventions
21.5 Performance Schema Status Monitoring
21.6 Performance Schema Atom and Molecule Events
21.7 Performance Schema Statement Digests
21.8 Performance Schema General Table Characteristics
21.9 Performance Schema Table Descriptions
21.9.1 Performance Schema Table Index
21.9.2 Performance Schema Setup Tables
21.9.3 Performance Schema Instance Tables
21.9.4 Performance Schema Wait Event Tables
21.9.5 Performance Schema Stage Event Tables
21.9.6 Performance Schema Statement Event Tables
21.9.7 Performance Schema Connection Tables
21.9.8 Performance Schema Connection Attribute Tables
21.9.9 Performance Schema Summary Tables
21.9.10 Performance Schema Miscellaneous Tables
21.10 Performance Schema Option and Variable Reference
21.11 Performance Schema Command Options
21.12 Performance Schema System Variables
21.13 Performance Schema Status Variables
21.14 Performance Schema and Plugins
21.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: