PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and TIMED values. If a persistent table and a temporary table have the same name, matching against setup_objects rows occurs the same ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html
If a query result must have specific row ordering characteristics, include an ORDER BY clause. Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-runtime-configuration.html
If you have the UPDATE privilege, you can change Performance Schema operation by modifying setup tables to affect how monitoring occurs. This strategy can also be useful if you have multiple monitoring configurations, each tailored to produce a ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-tables.html
events_stages_history: The most recent stage events that have ended per thread. events_stages_history_long: The most recent stage events that have ended globally (across all threads). The Performance Schema instruments stages, which are steps ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-summary-tables.html
Tables that summarize events in similar ways often have similar sets of summary columns and differ only in the grouping columns used to determine how events are aggregated. That might be useful, for example, after you have made a runtime ... Summary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-system-variables.html
Performance Schema system variables have the following meanings: performance_schema Command-Line Format --performance-schema[={OFF|ON}] System Variable performance_schema Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value ON ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-descriptions.html
These tables have the same structure as the current events tables, but contain more rows. These tables contain information aggregated over groups of events, including those that have been discarded from the history tables. Tables in the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-summary-tables.html
This value is calculated only for timed events because nontimed events have a wait time of NULL. The Performance Schema maintains tables for collecting current and recent wait events, and aggregates that information in summary tables. Section ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-wait-tables.html
events_waits_history: The most recent wait events that have ended per thread. events_waits_history_long: The most recent wait events that have ended globally (across all threads). The Performance Schema instruments waits, which are events that take ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
Most Performance Schema tables have indexes, which gives the optimizer access to execution plans other than full table scans. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has ...