PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html
Disabling Deadlock Detection 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 ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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. InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
loose-daemon_memcached_option='-vvv' If columns specified to hold memcached values are the wrong data type, such as a numeric type instead of a string type, attempts to store key-value pairs fail with no specific error code or message. This section ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-txn.html
The numeric values specified for this option correspond to isolation levels such as REPEATABLE READ. Unlike traditional memcached, the daemon_memcached plugin allows you to control durability of data values produced through calls to add, set, incr, ...
https://dev.mysql.com/doc/refman/8.0/en/install-component.html
Note While specifying a variable value using the SET clause is similar to that of the command line—it is available immediately at variable registration—there is a distinct difference in how the SET clause handles invalid numerical values for ...