PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-monitor-types.html
There are two types of InnoDB monitor: The standard InnoDB Monitor displays the following types of information: Work done by the main background thread Semaphore waits Data about the most recent foreign key and deadlock errors Lock waits for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/en/json-table-functions.html
Each match for the path preceding the COLUMNS keyword maps to an individual row in the result table. MySQL, per the SQL standard, makes an exception for table functions; these are considered lateral derived tables, even in versions of MySQL that do ... This section contains information about JSON functions that convert JSON data to tabular ...
https://dev.mysql.com/doc/refman/8.0/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.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/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.0/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.0/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 ...