Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-detection.html
Otherwise, InnoDB cannot detect deadlocks where a table lock set by a MySQL LOCK TABLES statement or a lock set by a storage engine other than InnoDB is involved. When deadlock detection is enabled (the default), InnoDB automatically detects ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-transactions.html
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 request. That blocking lock request is for a row or table lock held by another ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema.html
You can view a list of InnoDB INFORMATION_SCHEMA tables by issuing a SHOW TABLES statement on the INFORMATION_SCHEMA database: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB%'; For table definitions, see Section 28.4, “INFORMATION_SCHEMA ... This section provides information and usage examples for InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-optimizer-statistics.html
You can use the STATS_PERSISTENT, STATS_AUTO_RECALC, and STATS_SAMPLE_PAGES clauses with CREATE TABLE and ALTER TABLE statements to configure optimizer statistics for individual tables. You can query optimizer statistics data in the ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-spin_lock_polling.html
They can be specified in a MySQL option file or modified at runtime using a SET GLOBAL statement. InnoDB mutexes and rw-locks are typically reserved for short intervals. On a multi-core system, it can be more efficient for a thread to continuously ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
$> cd BASEDIR/data/#innodb_temp $> ls temp_10.ibt temp_2.ibt temp_4.ibt temp_6.ibt temp_8.ibt temp_1.ibt temp_3.ibt temp_5.ibt temp_7.ibt temp_9.ibt In statement based replication (SBR) mode, temporary tables created on a replica reside in a single ... InnoDB uses session temporary tablespaces and a global temporary ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting-datadict.html
To address these messages, issue DROP TABLE statement to remove data about the missing table from the data dictionary. Information about table definitions is stored in the InnoDB data dictionary. If you move data files around, dictionary data can ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-remote-connections.html
The following procedure shows how to configure MySQL to permit IPv6 connections by remote clients. It is similar to the preceding procedure for local clients, but the server and client hosts are distinct and each has its own nonlocal IPv6 address.
https://dev.mysql.com/doc/refman/8.4/en/ipv6-support.html
IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and REVOKE. Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over IPv6. For example, ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-encrypted-file-component.html
Keyring operations performed by those functions are accessible in SQL statements as described in Section 8.4.4.12, “General-Purpose Keyring Key-Management Functions”. Note component_keyring_encrypted_file is an extension included in MySQL ...