Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
The purge operation can write disk blocks for a series of index values more efficiently than if each value were written to disk immediately. The change buffer is a special data structure that caches changes to secondary index pages when those pages ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
The data-at-rest encryption feature supports the Advanced Encryption Standard (AES) block-based encryption algorithm. It uses Electronic Codebook (ECB) block encryption mode for tablespace key encryption and Cipher Block Chaining (CBC) block ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-per-table-tablespaces.html
The scan is performed with a broad internal lock, which may delay other operations. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. File-per-table tablespace ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
The INNODB_BUFFER_PAGE_LRU table has the same columns as the INNODB_BUFFER_PAGE table, except that the INNODB_BUFFER_PAGE_LRU table has an LRU_POSITION column instead of a BLOCK_ID column. The definition for this page is the same as for ... The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-single-multi.html
Operations all using the same specific LOCK clause, that you want to either succeed or fail as a group. Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-space-requirements.html
A large innodb_online_alter_log_max_size setting permits more DML during an online DDL operation, but it also extends the period of time at the end of the DDL operation when the table is locked to apply logged DML. Disk space requirements for ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-schema.html
Instance tables relevant to InnoDB include: The mutex_instances table The rwlock_instances table The cond_instances table The file_instances table Note Mutexes and RW-locks related to the InnoDB buffer pool are not included in this coverage; the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
Until the rollback operation is completed, new connections may encounter locking conflicts with recovered transactions. To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
This affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE). With the CONCURRENT modifier and a MyISAM table that satisfies the condition for concurrent inserts (that is, it contains no free blocks in the ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
For the case of a key longer than 250 bytes, a larger key block size than the default of 1024 bytes is used. This is done by automatically combining adjacent deleted blocks and by extending blocks if the next block is deleted. MyISAM supports ...