https://dev.mysql.com/innodb-change-buffer.html
Change buffer merging may take several hours when there are many affected rows and numerous secondary indexes to update. 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/innodb-columns-table.html
For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these columns: TABLE_ID An identifier representing the table associated with the column; the same ...
https://dev.mysql.com/innodb-deadlock-detection.html
On high concurrency systems, deadlock detection can cause a slowdown when numerous threads wait for the same lock. When deadlock detection is enabled (the default), InnoDB automatically detects transaction deadlocks and rolls back a transaction or ...
https://dev.mysql.com/innodb-file-per-table-tablespaces.html
mysqld must keep an open file handle for each file-per-table tablespace, which may impact performance if you have numerous tables in file-per-table tablespaces. A file-per-table tablespace contains data and indexes for a single InnoDB table, and is ...
https://dev.mysql.com/innodb-foreign-table.html
The INNODB_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). For related usage information and examples, see Section 15.15.3, ...
https://dev.mysql.com/innodb-indexes-table.html
TYPE A numeric value derived from bit-level information that identifies the index type. For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_INDEXES table has these ...
https://dev.mysql.com/innodb-information-schema-system-tables.html
TYPE is a numerical value representing bit flags that provide additional information about the foreign key column. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get ...
https://dev.mysql.com/innodb-memcached-benefits.html
For example, you can store the string value 2|4|6|8 in the memcached cache, and have InnoDB split the value based on a separator character, then store the result in four numeric columns. The combination of InnoDB tables and memcached offers ...
https://dev.mysql.com/innodb-memcached-developing.html
The data stored through the daemon_memcached plugin goes into VARCHAR, TEXT, or BLOB columns, and must be converted to do numeric operations. Typically, writing an application for the InnoDB memcached plugin involves some degree of rewriting or ...
https://dev.mysql.com/innodb-memcached-internals.html
flags The InnoDB table columns that are used as flags (a user-defined numeric value that is stored and retrieved along with the main value) for memcached. The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly ...
