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/validate-password-options-variables.html
validate_password.dictionary_file can be set at runtime and assigning a value causes the named file to be read without a server restart. Password Validation Plugin Options Note In MySQL 8.0, the validate_password plugin was reimplemented as the ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
It also includes clauses that specify the trigger action time, the triggering event, and what to do when the trigger activates: The keyword BEFORE indicates the trigger action time. The statement following FOR EACH ROW defines the trigger body; that ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-component.html
Note The Oracle Cloud Infrastructure Vault keyring component is included in MySQL Enterprise Edition, a commercial product. No key information is permanently stored in MySQL server local storage. All keys are stored in Oracle Cloud Infrastructure ...component_keyring_oci is part of the component infrastructure that communicates with Oracle Cloud Infrastructure Vault for back end ...
https://dev.mysql.com/doc/refman/8.0/en/log-file-maintenance.html
When using MySQL with logging enabled, you may want to back up and remove old log files from time to time and tell MySQL to start logging to new files. As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different ...However, you must clean up these files regularly to ensure that the logs do not take up too much disk ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-communication-protocol.html
From MySQL 8.0.16, Group Replication has the concept of a communication protocol for the group. The Group Replication communication protocol version can be managed explicitly, and set to accommodate the oldest MySQL Server version that you want the ...When a new member joins a replication group, it checks the communication protocol version that is announced by the existing members of the ...
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. Note There are easier alternatives to generating the files required for SSL than the procedure described here: Let ...The first example shows a simplified procedure such as you might use from the command ...
https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If you combine LIMIT ... If ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...In ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. This can be more efficient than using mysqldump and importing the file on ...