PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
The CLUST_INDEX_SIZE and OTHER_INDEX_SIZE fields report the number of pages on disk that store clustered and secondary indexes for the table, respectively. You can extract metadata about schema objects managed by InnoDB using InnoDB ...
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-intro.html
You can map multiple columns into the “value” part of the key-value store, with column values delimited by a user-specified separator character. The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
The daemon_memcached plugin supports multiple get operations (fetching multiple key-value pairs in a single memcached query) and range queries. Multiple get Operations The ability to fetch multiple key-value pairs in a single memcached query ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multiple-buffer-pools.html
Each page that is stored in or read from the buffer pool is assigned to one of the buffer pools randomly, using a hashing function. For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-physical-structure.html
Index records are stored in the leaf pages of their B-tree or R-tree data structure. With the exception of spatial indexes, InnoDB indexes are B-tree data structures. Spatial indexes use R-trees, which are specialized data structures for indexing ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. How to Enable To prepare an instance for read-only operation, make sure all the necessary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
Instead, statistics are stored in memory, and are lost when the server is shut down. Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or altered with STATS_PERSISTENT=0. Statistics ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-model.html
The lock information in InnoDB is stored space-efficiently so that lock escalation is not needed. The InnoDB transaction model aims to combine the best properties of a multi-versioning database with traditional two-phase locking. InnoDB performs ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
The value stored in the INT and YEAR columns is 1999 because the string-to-number conversion looks only at as much of the initial part of the string as may be considered a valid integer or year. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] ...