Documentation Home
MySQL Performance Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb
HTML Download (TGZ) - 101.8Kb
HTML Download (Zip) - 120.1Kb


MySQL Performance Schema

Abstract

This is the MySQL Performance Schema extract from the MySQL 5.6 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: 2020-03-27 (revision: 65508)


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 Index
10.2 Performance Schema Setup Tables
10.2.1 The setup_actors Table
10.2.2 The setup_consumers Table
10.2.3 The setup_instruments Table
10.2.4 The setup_objects Table
10.2.5 The setup_timers Table
10.3 Performance Schema Instance Tables
10.3.1 The cond_instances Table
10.3.2 The file_instances Table
10.3.3 The mutex_instances Table
10.3.4 The rwlock_instances Table
10.3.5 The socket_instances Table
10.4 Performance Schema Wait Event Tables
10.4.1 The events_waits_current Table
10.4.2 The events_waits_history Table
10.4.3 The events_waits_history_long Table
10.5 Performance Schema Stage Event Tables
10.5.1 The events_stages_current Table
10.5.2 The events_stages_history Table
10.5.3 The events_stages_history_long Table
10.6 Performance Schema Statement Event Tables
10.6.1 The events_statements_current Table
10.6.2 The events_statements_history Table
10.6.3 The events_statements_history_long Table
10.7 Performance Schema Connection Tables
10.7.1 The accounts Table
10.7.2 The hosts Table
10.7.3 The users Table
10.8 Performance Schema Connection Attribute Tables
10.8.1 The session_account_connect_attrs Table
10.8.2 The session_connect_attrs Table
10.9 Performance Schema Summary Tables
10.9.1 Wait Event Summary Tables
10.9.2 Stage Summary Tables
10.9.3 Statement Summary Tables
10.9.4 Object Wait Summary Table
10.9.5 File I/O Summary Tables
10.9.6 Table I/O and Lock Wait Summary Tables
10.9.7 Socket Summary Tables
10.10 Performance Schema Miscellaneous Tables
10.10.1 The host_cache Table
10.10.2 The performance_timers Table
10.10.3 The threads Table
11 Performance Schema and Plugins
12 Performance Schema System Variables
13 Performance Schema Status Variables
14 Using the Performance Schema to Diagnose Problems
14.1 Query Profiling Using Performance Schema