Chapter 27 MySQL Performance Schema Table of Contents 4893 27.1 Performance Schema Quick Start .......................................................................................... 4895 27.2 Performance Schema Build Configuration .............................................................................. 4901 27.3 Performance Schema Startup Configuration ........................................................................... 4902 27.4 Performance Schema Runtime Configuration ......................................................................... 4904 27.4.1 Performance Schema Event Timing ............................................................................ 4905 27.4.2 Performance Schema Event Filtering .......................................................................... 4907 27.4.3 Event Pre-Filtering ...................................................................................................... 4909 27.4.4 Pre-Filtering by Instrument .......................................................................................... 4909 27.4.5 Pre-Filtering by Object ................................................................................................ 4911 27.4.6 Pre-Filtering by Thread ............................................................................................... 4913 27.4.7 Pre-Filtering by Consumer .......................................................................................... 4915 27.4.8 Example Consumer Configurations ............................................................................. 4918 27.4.9 Naming Instruments or Consumers for Filtering Operations .......................................... 4923 27.4.10 Determining What Is Instrumented ............................................................................ 4923 27.5 Performance Schema Queries ............................................................................................... 4924 27.6 Performance Schema Instrument Naming Conventions ........................................................... 4924 27.7 Performance Schema Status Monitoring ................................................................................. 4928 27.8 Performance Schema Atom and Molecule Events ................................................................... 4931 27.9 Performance Schema Tables for Current and Historical Events ............................................... 4932 27.10 Performance Schema Statement Digests and Sampling ........................................................ 4933 27.11 Performance Schema General Table Characteristics ............................................................. 4938 27.12 Performance Schema Table Descriptions ............................................................................. 4939 27.12.1 Performance Schema Table Reference ..................................................................... 4939 27.12.2 Performance Schema Setup Tables .......................................................................... 4944 27.12.3 Performance Schema Instance Tables ...................................................................... 4952 27.12.4 Performance Schema Wait Event Tables ................................................................... 4958 27.12.5 Performance Schema Stage Event Tables ................................................................. 4964 27.12.6 Performance Schema Statement Event Tables .......................................................... 4970 27.12.7 Performance Schema Transaction Tables .................................................................. 4981 27.12.8 Performance Schema Connection Tables .................................................................. 4988 27.12.9 Performance Schema Connection Attribute Tables ..................................................... 4992 27.12.10 Performance Schema User-Defined Variable Tables ................................................. 4996 27.12.11 Performance Schema Replication Tables ................................................................. 4997 27.12.12 Performance Schema NDB Cluster Tables ............................................................... 5019 27.12.13 Performance Schema Lock Tables .......................................................................... 5022 27.12.14 Performance Schema System Variable Tables ......................................................... 5031 27.12.15 Performance Schema Status Variable Tables ........................................................... 5035 27.12.16 Performance Schema Thread Pool Tables ............................................................... 5037 27.12.17 Performance Schema Firewall Tables ...................................................................... 5042 27.12.18 Performance Schema Keyring Tables ...................................................................... 5044 27.12.19 Performance Schema Clone Tables ........................................................................ 5045 27.12.20 Performance Schema Summary Tables ................................................................... 5048 27.12.21 Performance Schema Miscellaneous Tables ............................................................ 5077 27.13 Performance Schema Option and Variable Reference ........................................................... 5096 27.14 Performance Schema Command Options ............................................................................. 5099 27.15 Performance Schema System Variables ............................................................................... 5101 27.16 Performance Schema Status Variables ................................................................................ 5119 27.17 The Performance Schema Memory-Allocation Model ............................................................ 5122