Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/installation-layouts.html
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.13, “MySQL Installation Layout for Linux RPM Packages ... 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.4/en/keyring-hashicorp-plugin.html
Extract the content of the archive to produce the executable vault command, which is used to perform HashiCorp Vault operations. The keyring_hashicorp plugin supports the configuration parameters shown in the following table. As indicated by the ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/en/locking-service.html
Locking Service Monitoring The locking service is implemented using the MySQL Server metadata locks framework, so you monitor locking service locks acquired or waited for by examining the Performance Schema metadata_locks table. MySQL distributions ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/mysql-cluster-limitations-disk-data.html
Disk data objects are subject to the following maximums and minimums: Maximum number of tablespaces: 232 (4294967296) Maximum number of data files per tablespace: 216 (65536) The minimum and maximum possible sizes of extents for tablespace data ...
https://dev.mysql.com/doc/refman/8.4/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 ...