Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-hosts-table.html
For a description of how the Performance Schema maintains rows in this table, including the effect of TRUNCATE TABLE, see Section 29.12.8, “Performance Schema Connection Tables”. The hosts table contains a row for each host from which clients ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-keyring-component-status-table.html
The keyring_component_status table provides status information about the properties of the keyring component in use, if one is installed. The table is empty if no keyring component is installed (for example, if the keyring is not being used, or is ...
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-log-status-table.html
The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources for the duration of the copy process. When the log_status table is queried, the server blocks logging and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
The metadata_locks table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME) Index on (OWNER_THREAD_ID, OWNER_EVENT_ID) TRUNCATE TABLE is not permitted for the metadata_locks table. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-mutex-instances-table.html
The mutex_instances table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (NAME) Index on (LOCKED_BY_THREAD_ID) TRUNCATE TABLE is not permitted for the mutex_instances table. The mutex_instances table lists all the mutexes seen ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-objects-summary-global-by-type-table.html
The objects_summary_global_by_type table has these indexes: Primary key on (OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME) TRUNCATE TABLE is permitted for the object summary table. The Performance Schema maintains the objects_summary_global_by_type table ...
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-persisted-variables-table.html
persisted_variables has these indexes: Primary key on (VARIABLE_NAME) TRUNCATE TABLE is not permitted for the persisted_variables table. The persisted_variables table provides an SQL interface to the mysqld-auto.cnf file that stores persisted ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
The prepared_statements_instances table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (STATEMENT_ID) Index on (STATEMENT_NAME) Index on (OWNER_THREAD_ID, OWNER_EVENT_ID) Index on (OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, ... The ...