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 either the MySQL Forums or MySQL Mailing Lists, where you can discuss your issues with other MySQL users.

For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation Library.

Licensing information—MySQL 5.6.  This product may include third-party software, used under license. If you are using a Commercial release of MySQL 5.6, see this document for licensing information, including licensing information relating to third-party software that may be included in this Commercial release. If you are using a Community release of MySQL 5.6, see this document for licensing information, including licensing information relating to third-party software that may be included in this Community release.

Licensing information—MySQL Cluster.  This product may include third-party software, used under license. If you are using a Commercial release of MySQL Cluster NDB 7.3 or NDB 7.4, see this document for licensing information, including licensing information relating to third-party software that may be included in this Commercial release. If you are using a Community release of MySQL Cluster NDB 7.3 or NDB 7.4, see this document for licensing information, including licensing information relating to third-party software that may be included in this Community release.

Document generated on: 2017-09-19 (revision: 54029)

---

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