https://dev.mysql.com/innodb-information-schema-system-tables.html
The INDEX_ID is an identifier for the index that is unique across all databases in an instance. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of ...
https://dev.mysql.com/innodb-information-schema-temp-table-info.html
row *************************** TABLE_ID: 194 NAME: #sql7a79_1_0 N_COLS: 4 SPACE: 182 The TABLE_ID is a unique identifier for the temporary table. INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are ...
https://dev.mysql.com/innodb-memcached-dml.html
These operations are guaranteed to only affect one row when issued through the memcached interface, because the key is unique within the table. Benchmarks suggest that the daemon_memcached plugin speeds up DML operations (inserts, updates, and ...
https://dev.mysql.com/innodb-memcached-internals.html
containers Table Column Constraints You must supply a value for db_schema, db_name, key_columns, value_columns and unique_idx_name_on_key. The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from ...
https://dev.mysql.com/innodb-memcached-porting-memcached.html
This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment values). Primary key values are included in secondary indexes, which takes up unnecessary space if the ...
https://dev.mysql.com/innodb-memcached-setup.html
The table must have a key column with a unique index. This section describes how to set up the daemon_memcached plugin on a MySQL server. Because the memcached daemon is tightly integrated with the MySQL server to avoid network traffic and minimize ...
https://dev.mysql.com/innodb-memcached-troubleshoot.html
This section describes issues that you may encounter when using the InnoDB memcached plugin. If you encounter the following error in the MySQL error log, the server might fail to start: failed to set rlimit for open files. One solution is to raise ...
https://dev.mysql.com/innodb-memcached-tuning.html
Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is expected to be somewhat slower than using memcached by itself. When using the InnoDB memcached plugin, ...
https://dev.mysql.com/innodb-metrics-table.html
The INNODB_METRICS table has these columns: NAME A unique name for the counter. The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for InnoDB.
https://dev.mysql.com/innodb-next-key-locking.html
The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, ...
