Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/keyring-component-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. Keyring components loaded using that statement may be available too late ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/mle-component-stored-programs.html
Other information about MLE stored programs can be found in the Information Schema ROUTINES table. Information about MLE JavaScript libraries is available in the two Information Schema tables LIBRARIES and ROUTINE_LIBRARIES. For more information and ... Several system status variables provide information about usage of MLE stored ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...