https://dev.mysql.com/innodb-linux-native-aio.html
With synchronous I/O, query threads queue I/O requests, and InnoDB background threads retrieve the queued requests one at a time, issuing a synchronous I/O call for each. InnoDB uses the asynchronous I/O subsystem (native AIO) on Linux to perform ...
https://dev.mysql.com/innodb-locking-reads.html
Here, FOR SHARE is not a good solution because if two users read the counter at the same time, at least one of them ends up in deadlock when it attempts to update the counter. If you query data and then insert or update related data within the same ...
https://dev.mysql.com/innodb-memcached-porting-memcached.html
Changes to the innodb_memcache.containers table take effect the next time the innodb_memcache.containers table is queried. This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are ...
https://dev.mysql.com/innodb-memcached-porting-mysql.html
The results are already converted; # no need to repeat conversion functions and WHERE clauses each time. mysql> INSERT INTO innodb_memcache.containers (name,db_schema,db_table,key_columns,value_columns,flags,cas_column, ... Consider these aspects of ...
https://dev.mysql.com/innodb-migration.html
In conjunction with the MySQL binary log, you can perform point-in-time recovery. This section describes techniques for moving or copying some or all InnoDB tables to a different server or instance. For example, you might move an entire MySQL ...
https://dev.mysql.com/innodb-multi-versioning.html
This removal operation is called a purge, and it is quite fast, usually taking the same order of time as the SQL statement that did the deletion. InnoDB is a multi-versioned storage engine: it keeps information about old versions of changed rows, ...
https://dev.mysql.com/innodb-online-ddl-failure-conditions.html
A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and final phases of the DDL operation. The operation takes a long time and concurrent DML modifies the table so much that the size of ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...
https://dev.mysql.com/innodb-online-ddl-operations.html
A newly created secondary index contains only the committed data in the table at the time the CREATE INDEX or ALTER TABLE statement finishes executing. When you add a primary key using the ALGORITHM=COPY clause, MySQL converts NULL values in the ...
https://dev.mysql.com/innodb-online-ddl-single-multi.html
If the specific changes were different each time, you might have to construct a new complex ALTER TABLE for each slightly different scenario. Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ...
https://dev.mysql.com/innodb-page-compression.html
Hole punching size is the NTFS compression unit, which is 16 times the NTFS cluster size. InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION ...
