Search Results
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-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-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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-processlist-table.html
The processlist table has these indexes: Primary key on (ID) TRUNCATE TABLE is not permitted for the processlist table. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. For ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
row *************************** Table: setup_consumers Create Table: CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL, PRIMARY KEY (`NAME`) ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 ... This ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-coordinator-table.html
The replication_applier_status_by_coordinator table has these indexes: Primary key on (CHANNEL_NAME) Index on (THREAD_ID) The following table shows the correspondence between replication_applier_status_by_coordinator columns and SHOW REPLICA STATUS ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-worker-table.html
The replication_applier_status_by_worker table has these indexes: Primary key on (CHANNEL_NAME, WORKER_ID) Index on (THREAD_ID) The following table shows the correspondence between replication_applier_status_by_worker columns and SHOW REPLICA STATUS ... This table provides details of the transactions handled by applier threads on a replica or Group Replication group ...