https://dev.mysql.com/innodb-data-encryption.html
The default_table_encryption variable can be set for an individual client connection or globally using SET syntax. InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, ...
https://dev.mysql.com/innodb-error-handling.html
During implicit rollbacks, as well as during the execution of an explicit ROLLBACK SQL statement, SHOW PROCESSLIST displays Rolling back in the State column for the relevant connection. InnoDB sometimes rolls back only the statement that failed, ...
https://dev.mysql.com/innodb-locking-reads.html
In MySQL, the specific task of generating a unique identifier actually can be accomplished using only a single access to the table: UPDATE child_codes SET counter_field = LAST_INSERT_ID(counter_field + 1); SELECT LAST_INSERT_ID(); The SELECT ... If ...
https://dev.mysql.com/innodb-memcached-intro.html
For example, you can change the port that memcached listens on, reduce the maximum number of simultaneous connections, change the maximum memory size for a key-value pair, or enable debugging messages for the error log. The InnoDB memcached plugin ...
https://dev.mysql.com/innodb-memcached-security.html
SASL stands for “Simple Authentication and Security Layer”, a standard for adding authentication support to connection-based protocols. Caution Consult this section before deploying the daemon_memcached plugin on a production server, or even on ...
https://dev.mysql.com/innodb-multiple-buffer-pools.html
Each buffer pool manages its own free lists, flush lists, LRUs, and all other data structures connected to a buffer pool. For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve ...
https://dev.mysql.com/innodb-online-ddl-limitations.html
When running an in-place online DDL operation, the thread that runs the ALTER TABLE statement applies an online log of DML operations that were run concurrently on the same table from other connection threads. The following limitations apply to ...
https://dev.mysql.com/innodb-performance-thread_concurrency.html
For general performance information about MySQL thread handling, see Section 5.1.12.1, “Connection Interfaces”. InnoDB uses operating system threads to process requests from user transactions. (Transactions may issue many requests to InnoDB ...
https://dev.mysql.com/innodb-preload-buffer-pool.html
Because uncompressing pages is a CPU-intensive process, it is more efficient for concurrency to perform the operation in a connection thread rather than in the single thread that performs the buffer pool restore operation. To reduce the warmup ...
https://dev.mysql.com/innodb-redo-log.html
Modifications that did not finish updating the data files before an unexpected shutdown are replayed automatically during initialization, and before the connections are accepted. The redo log is a disk-based data structure used during crash ...
