MySQL 8.0 Reference Manual 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 27.18 Performance Schema and Plugins ............................................................................... 5123 27.19 Using the Performance Schema to Diagnose Problems ................................................. 5123 27.19.1 Query Profiling Using Performance Schema ...................................................... 5125 27.19.2 Obtaining Parent Event Information ................................................................... 5127 27.20 Restrictions on Performance Schema ........................................................................... 5128 28 MySQL sys Schema ................................................................................................................ 5131 28.1 Prerequisites for Using the sys Schema ......................................................................... 5131 28.2 Using the sys Schema .................................................................................................. 5132 28.3 sys Schema Progress Reporting .................................................................................... 5133 28.4 sys Schema Object Reference ....................................................................................... 5134 xxv