Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-disk-management.html
Organizing tables into many small files, a few larger files, or a combination of both. As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space to avoid filling up storage devices. The ACID design ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-doublewrite-buffer.html
As a result, doublewrite files can contain different page types including unencrypted and uncompressed pages, encrypted pages, compressed pages, and pages that are both encrypted and compressed. The doublewrite buffer is a storage area where InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-error-handling.html
Both deadlocks and lock wait timeouts are normal on busy servers and it is necessary for applications to be aware that they may happen and handle them by retrying. InnoDB sometimes rolls back only the statement that failed, other times it rolls back ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-defragmenting.html
Both ALTER TABLE tbl_name ENGINE=INNODB and ALTER TABLE tbl_name FORCE use online DDL. Random insertions into or deletions from a secondary index can cause the index to become fragmented. Fragmentation means that the physical ordering of the index ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
As you can see: Session B (trx id A4, thread 6) and Session C (trx id A5, thread 7) are both waiting for Session A (trx id A3, thread 5). This section describes the use of locking information as exposed by the Performance Schema data_locks and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
When the innodb_redo_log_capacity setting is defined, the innodb_log_file_size and innodb_log_files_in_group settings are ignored; otherwise, if one or both of these deprecated settings are defined then they are used to compute ... The first ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
As a result, both T1 and T2 hold an S lock on r. Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
LOCK=DEFAULT: Permits as much concurrency as possible (concurrent queries, DML, or both). Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl.html
For example: To avoid accidentally making the table unavailable for reads, writes, or both, during an in-place ALTER TABLE operation, specify a clause on the ALTER TABLE statement such as LOCK=NONE (permit reads and writes) or LOCK=SHARED (permit ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-page-compression.html
Page-compressed tablespaces can be copied between Linux and Windows servers if the compression algorithm that was used is available on both servers. InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page ...