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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-overview.html
When data is stored by the NDB storage engine, the tables (and table data) are stored in the data nodes. Such tables are directly accessible from all other MySQL servers (SQL nodes) in the cluster. NDB Cluster is a technology that enables ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-config.html
All options that can be used with ndb_config are shown in the following table. This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one of a number of sources: an NDB Cluster management node, or its ...