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-memcached-internals.html
InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded InnoDB. InnoDB API functions are passed to the InnoDB memcached engine as callback ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
daemon_memcached_w_batch_size: Defines the batch commit size for write operations (set, replace, append, prepend, incr, decr, and so on). This section describes how to set up the daemon_memcached plugin on a MySQL server. Because the memcached ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multiple-buffer-pools.html
In MySQL 8.0 and later, the buffer pool mutex was replaced by several list and hash protecting mutexes, to reduce contention. For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve ...
https://dev.mysql.com/doc/refman/8.0/en/insert-delayed.html
The DELAYED option for the INSERT statement is a MySQL extension to standard SQL. The server recognizes but ignores the DELAYED keyword, handles the insert as a nondelayed insert, and generates an ER_WARN_LEGACY_SYNTAX_CONVERTED warning: INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/install-component.html
[SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} [component_prefix.]system_var_name } This statement installs one or more components, which become active ...
https://dev.mysql.com/doc/refman/8.0/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. To enable the launchd service, you can either: ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
Metadata locking is not a replacement for the table definition cache, and its mutexes and locks differ from the LOCK_open mutex. MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. Metadata ...
https://dev.mysql.com/doc/refman/8.0/en/midpoint-insertion.html
It then becomes the first candidate for eviction, because blocks for replacement always are taken from the beginning of the warm sublist. By default, the key cache management system uses a simple LRU strategy for choosing key cache blocks to be ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
Consequently, whenever an index block needs to be pulled in from disk, the contents of the cache block chosen for replacement need not be flushed first. Note As of MySQL 8.0, the compound-part structured-variable syntax discussed here for referring ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-close.html
However, REPAIR TABLE should be avoided because when one server replaces the data file with a new one, this is not known to the other servers. Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table ...