Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
Setting a limit on this value reduces the size of the index, thus speeding up queries, by omitting long keywords or arbitrary collections of letters that are not real words and are not likely to be search terms. For ANALYZE TABLE operations that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
Configuring the Number of Sampled Pages The MySQL query optimizer uses estimated statistics about key distributions to choose the indexes for an execution plan, based on the relative selectivity of the index. Optimizer statistics are not persisted ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple sessions. This type of locking is internal because it is performed entirely by the server and ...
https://dev.mysql.com/doc/refman/8.4/en/json-table-functions.html
Each match for the path preceding the COLUMNS keyword maps to an individual row in the result table. This section contains information about JSON functions that convert JSON data to tabular data. JSON_TABLE(expr, path COLUMNS (column_list) [AS] ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions here. To use a keyring plugin instead, begin with Section 8.4.4.3, “Keyring Plugin Installation”. If you ...To be usable by the server, the component library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system ...
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/ldap-pluggable-authentication.html
To change a value for the running MySQL instance without having it carry over to subsequent restarts, use the GLOBAL keyword rather than PERSIST. KDC: The key distribution center, comprising the AS and TGS: AS: The authentication server; provides ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
An SSL certificate and key files are generated in the data directory. The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by Oracle. There are two sources for obtaining them, for the Community ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-sles-repo.html
MySQL Server Initialization: When the server is started for the first time, the server is initialized, and the following happens (if the data directory of the server is empty when the initialization process begins): The SSL certificate and key files ... The MySQL SLES repository provides RPM packages for installing and managing the MySQL server, client, and other components on SUSE Enterprise Linux ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of RAM. You can improve MySQL performance by ...