PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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.0/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.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-table.html
The replication_applier_status table has these indexes: Primary key on (CHANNEL_NAME) TRUNCATE TABLE is not permitted for the replication_applier_status table. This table shows the current general transaction execution status on the replica. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-asynchronous-connection-failover-table.html
The replication_asynchronous_connection_failover table has these indexes: Primary key on (CHANNEL_NAME, HOST, PORT, NETWORK_NAMESPACE, MANAGED_NAME) TRUNCATE TABLE is not permitted for the replication_asynchronous_connection_failover table. This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-connection-status-table.html
The replication_connection_status table has these indexes: Primary key on (CHANNEL_NAME) Index on (THREAD_ID) The following table shows the correspondence between replication_connection_status columns and SHOW REPLICA STATUS columns. This table ...