Chapter 20. MySQL Performance Schema

Table of Contents

20.1. Performance Schema Quick Start
20.2. Performance Schema Configuration
20.2.1. Performance Schema Build Configuration
20.2.2. Performance Schema Startup Configuration
20.2.3. Performance Schema Runtime Configuration
20.3. Performance Schema Queries
20.4. Performance Schema Instrument Naming Conventions
20.5. Performance Schema Status Monitoring
20.6. Performance Schema Atom and Molecule Events
20.7. Performance Schema Statement Digests
20.8. Performance Schema General Table Characteristics
20.9. Performance Schema Table Descriptions
20.9.1. Performance Schema Setup Tables
20.9.2. Performance Schema Instance Tables
20.9.3. Performance Schema Wait Event Tables
20.9.4. Performance Schema Stage Event Tables
20.9.5. Performance Schema Statement Event Tables
20.9.6. Performance Schema Connection Tables
20.9.7. Performance Schema Connection Attribute Tables
20.9.8. Performance Schema Summary Tables
20.9.9. Performance Schema Miscellaneous Tables
20.10. Performance Schema Option and Variable Reference
20.11. Performance Schema Command Options
20.12. Performance Schema System Variables
20.13. Performance Schema Status Variables
20.14. Performance Schema and Plugins
20.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:




Spec-Zone.ru - all specs in one place