Search Results
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-current-table.html
The events_waits_current table has these indexes: Primary key on (THREAD_ID, EVENT_ID) TRUNCATE TABLE is permitted for the events_waits_current table. The table stores one row per thread showing the current status of the thread's most recent ...
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-examples.html
Then truncate the history and summary tables to remove previously collected events. The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-instances-table.html
The file_instances table has these indexes: Primary key on (FILE_NAME) Index on (EVENT_NAME) TRUNCATE TABLE is not permitted for the file_instances table. The file_instances table lists all the files seen by the Performance Schema when executing ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-summary-tables.html
The file I/O summary tables have these indexes: file_summary_by_event_name: Primary key on (EVENT_NAME) file_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (FILE_NAME) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for file ... 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-firewall-group-allowlist-table.html
The firewall_group_allowlist table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_group_allowlist system table that provides persistent storage of firewall data; see ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-groups-table.html
The firewall_groups table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists names and operational modes of registered firewall group profiles. It is used in conjunction with the mysql.firewall_groups system table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-membership-table.html
The firewall_membership table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_membership system table that provides persistent storage of firewall data; see MySQL ...