PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%'; +---------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_TEMP%) | +---------------------------------------------+ | INNODB_TEMP_TABLE_INFO | ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-transactions.html
For more information about the preceding tables, see Section 24.4.28, “The INFORMATION_SCHEMA INNODB_TRX Table”, Section 24.4.14, “The INFORMATION_SCHEMA INNODB_LOCKS Table”, and Section 24.4.15, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS ...INNODB_LOCKS: Each transaction in InnoDB that is waiting for another transaction to release a lock (INNODB_TRX.TRX_STATE is LOCK WAIT) is blocked by exactly one blocking lock ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-understanding-innodb-locking.html
(The INFORMATION_SCHEMA INNODB_TRX table indicates transaction state values.) The INNODB_LOCKS table holds one or more rows for each LOCK WAIT transaction, indicating any lock requests that prevent its progress. When a transaction updates a row in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema.html
This section provides information and usage examples for InnoDB INFORMATION_SCHEMA tables. InnoDB INFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of the InnoDB storage engine. You can view a list ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-information-schema-tables.html
Two INFORMATION_SCHEMA tables provide information that is of particular use when managing an NDB Cluster . The FILES table provides information about NDB Cluster Disk Data files. The ndb_transid_mysql_connection_map table provides a mapping between ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-configuration-table.html
This table shows the configuration parameters that affect transactions applied by the replica. Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. The ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
The following statement shows whether or not that transaction has been committed: SELECT GTID_SUBSET(LAST_SEEN_TRANSACTION, @@GLOBAL.GTID_EXECUTED) FROM performance_schema.replication_applier_status_by_worker; If the statement returns zero, the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-table.html
This table shows the current general transaction execution status on the replica. The table provides information about general aspects of transaction applier status that are not specific to any thread involved. Thread-specific status information is ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-configuration-table.html
This table shows the configuration parameters used by the replica for connecting to the source. Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. It contains ...