Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-keyring-keys-table.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. Key metadata includes key IDs, key owners, and backend key IDs. The keyring_keys table does not expose ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-keyring-tables.html
The following sections describe the Performance Schema tables associated with the MySQL keyring (see Section 8.4.4, “The MySQL Keyring”). They provide information about keyring operation: keyring_component_status: Information about the keyring ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-model.html
Memory used depends on the load actually seen, not the load estimated or explicitly configured for. As the Performance Schema collects data, memory is allocated in the corresponding buffer. The buffer size is unbounded, and may grow with the load.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-objects-summary-global-by-type-table.html
The Performance Schema maintains the objects_summary_global_by_type table for aggregating object wait events. Example object wait event summary information: mysql> SELECT * FROM performance_schema.objects_summary_global_by_type\G ... row ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-obtaining-parent-events.html
Rows of this table have a THREAD_ID column indicating the thread ID of the session that owns the lock, and an EVENT_ID column indicating the Performance Schema event that caused the lock. The relation is based on a nested set data model, so the join ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-performance-timers-table.html
For an explanation of how event timing occurs, see Section 29.4.1, “Performance Schema Event Timing”. For a cycle timer, the frequency is generally related to the CPU speed. For example, on a system with a 2.4GHz processor, the CYCLE may be ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-coordinator-table.html
For a multithreaded replica, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the coordinator thread. For a multithreaded replica, the replication_applier_status_by_worker table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-worker-table.html
This table provides details of the transactions handled by applier threads on a replica or Group Replication group member. For a single-threaded replica, data is shown for the replica's single applier thread. For a multithreaded replica, data is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-asynchronous-connection-failover-managed-table.html
This table holds configuration information used by the replica's asynchronous connection failover mechanism to handle managed groups, including Group Replication topologies. When you add a group member to the source list and define it as part of a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-configuration-version-table.html
This table displays the version of the member actions configuration for replication group members. Whenever a member action is enabled or disabled using the group_replication_enable_member_action() and group_replication_disable_member_action() ...