Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-history-long-table.html
The events_transactions_history_long table contains the N most recent transaction events that have ended globally, across all threads. Transaction events are not added to the table until they have ended. When the table becomes full, the oldest row ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-history-table.html
The events_transactions_history table contains the N most recent transaction events that have ended per thread. Transaction events are not added to the table until they have ended. When the table contains the maximum number of rows for a given ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-history-long-table.html
The events_waits_history_long table contains N the most recent wait events that have ended globally, across all threads. Wait events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-history-table.html
The events_waits_history table contains the N most recent wait events that have ended per thread. Wait events are not added to the table until they have ended. When the table contains the maximum number of rows for a given thread, the oldest thread ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-summary-tables.html
Some columns are more general and have values that are the same as the sum of the values of more fine-grained columns. The file I/O summary tables have these indexes: file_summary_by_event_name: Primary key on (EVENT_NAME) file_summary_by_instance: ... The Performance Schema maintains file I/O summary tables that aggregate information about I/O ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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 ...