Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-cmp-table.html
B-tree pages are uncompressed whenever compression fails or at first access when the uncompressed page does not exist in the buffer pool. The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
INSTANT_COLS The number of columns that existed before the first instant column was added using ALTER TABLE ... For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_TABLES ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-temp-table-info-table.html
The INNODB_TEMP_TABLE_INFO table is created when first queried, exists only in memory, and is not persisted to disk. The INNODB_TEMP_TABLE_INFO table provides information about user-created InnoDB temporary tables that are active in an InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-and-mysql-replication.html
To make a new replica without taking down the source or an existing replica, use the MySQL Enterprise Backup product. It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
innodb_autoinc_lock_mode = 0 (“traditional” lock mode) The traditional lock mode provides the same behavior that existed before the innodb_autoinc_lock_mode variable was introduced. InnoDB provides a configurable locking mechanism that can ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
Changing the setting affects the buffering of new operations; the merging of existing buffered entries is not affected. The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
To import the dump file into a new database, and have the tables re-created as they exist in the original database, ensure the server has the proper setting for the innodb_file_per_table configuration parameter. This section describes syntax ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning-monitoring.html
Increasing the size of the buffer pool might also help performance, so that more uncompressed pages can stay in memory, reducing the need to uncompress pages that exist in memory only in compressed form. Overall application performance, CPU and I/O ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
A full-text index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX. Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
Consistent reads ignore any locks set on the records that exist in the read view. A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. It does not matter ...