PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/index-preloading.html
Preloading enables you to put the table index blocks into a key cache buffer in the most efficient way: by reading the index blocks from disk sequentially. If there are enough blocks in a key cache to hold blocks of an entire index, or at least the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached.html
The InnoDB memcached plugin (daemon_memcached) provides an integrated memcached daemon that automatically stores and retrieves data from InnoDB tables, turning the MySQL server into a fast “key-value store”. You can also access the same InnoDB ... Important The InnoDB memcached plugin was removed in MySQL 8.3.0, and was deprecated in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/refman/8.0/en/installation-layouts.html
Section 2.3.1, “MySQL Installation Layout on Microsoft Windows” Section 2.8.3, “MySQL Layout for Source Installation” Table 2.3, “MySQL Installation Layout for Generic Unix/Linux Binary Package” Table 2.12, “MySQL Installation Layout ... The installation layout differs for different installation types (for example, native packages, binary tarballs, and source tarballs), which can lead to confusion when managing different systems or using different installation ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-metadata.html
To see whether a keyring plugin is loaded, check the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 7.6.2, “Obtaining Server Plugin Information”). If the component loaded but failed to initialize, the value is ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-plugin-installation.html
For example, the InnoDB storage engine uses the keyring for tablespace encryption, so a keyring component or plugin must be loaded and available prior to InnoDB initialization. Verify plugin installation by examining the Information Schema PLUGINS ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring plugin, begin with the instructions ...
https://dev.mysql.com/doc/refman/8.0/en/locking-functions.html
Uniquely named locks acquired with GET_LOCK() appear in the Performance Schema metadata_locks table. In the case that multiple locks are acquired for the same name, only the first lock for the name registers a row in the metadata_locks table. Since ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-send-buffers.html
You can use the ndbinfo.transporters table to monitor send buffer memory usage, and to detect slowdown and overload conditions that can adversely affect performance. The NDB kernel employs a unified send buffer whose memory is allocated dynamically ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-management.html
The values of these variables can be read in the mysql client from the output of a SHOW STATUS statement, or by querying either the Performance Schema session_status or global_status table. By comparing the values of the status variables before and ... Managing an NDB Cluster involves a number of tasks, the first of which is to configure and start NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-usage.html
The following table lists supported application features according to the storage engine to which each feature is typically better suited. When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more ...