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/connection-access.html
+----------------+----------+- The first row matches a connection by any user from h1.example.net, whereas the second row matches a connection by jeffrey from any host. When you attempt to connect to a MySQL server, the server accepts or rejects ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
connection_control_min_connection_delay: The minimum delay in milliseconds for connection failures above the threshold. connection_control_max_connection_delay: The maximum delay in milliseconds for connection failures above the threshold. The ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are compressed. These options can be given on ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
Because the difference in performance between “good” and “bad” plans can be orders of magnitude (that is, seconds versus hours or even days), most query optimizers, including that of MySQL, perform a more or less exhaustive search for an ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
For more information, see Section 15.1.20.9, “Secondary Indexes and Generated Columns”. A multi-valued index is a secondary index defined on a column that stores an array of values. Because multi-valued indexes are virtual indexes on virtual ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
Beginning with MySQL 8.0.30, MySQL supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
gen_blocklist(str, from_dictionary_name, to_dictionary_name) Replaces a term present in one dictionary with a term from a second dictionary and returns the replacement term. mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number ...