Search Results
https://dev.mysql.com/doc/refman/8.4/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-communication-protocol.html
Group Replication in MySQL 8.4 uses the concept of a group communication protocol whose version can be managed explicitly, and set to accommodate the oldest MySQL Server version that you want the group to support. This enables groups to be formed ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-member-actions.html
The following functions can be used to enable and disable actions for members of a group to take in specified situations, and to reset the configuration to the default setting for all member actions. They can only be used by administrators with the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if any.
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks.html
A deadlock is a situation in which multiple transactions are unable to proceed because each transaction holds a lock that is needed by another one. Because all transactions involved are waiting for the same resource to become available, none of ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-temp-table-info.html
INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB instance. It does not provide information about internal InnoDB temporary tables used by the optimizer. mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-spin_lock_polling.html
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 check if it can acquire a mutex or rw-lock for a period of time before it sleeps. If the mutex or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-tablespace-autoextend-size.html
By default, when a file-per-table or general tablespace requires additional space, the tablespace is extended incrementally according to the following rules: If the tablespace is less than an extent in size, it is extended one page at a time. If ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-temporary-tablespace.html
InnoDB uses session temporary tablespaces and a global temporary tablespace. Session Temporary Tablespaces Session temporary tablespaces store user-created temporary tables and internal temporary tables created by the optimizer when InnoDB is ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to indexes other than primary keys (either explicit or implicit). ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER ...