Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
To ensure that your tables are up to date for upgrades from earlier versions of MySQL, perform the MySQL upgrade procedure, making sure to use the option that forces an update (see Chapter 3, Upgrading MySQL). If you prefer to run the update ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
Example: mysql> SELECT audit_log_encryption_password_set(password); +---------------------------------------------+ | audit_log_encryption_password_set(password) | +---------------------------------------------+ | 1 | ...Unless those objects are ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
If that state is not sufficiently current, a full recovery can be followed by recovery of incremental backups made since the full backup, to bring the server to a more up-to-date state. This section describes the characteristics of different types ...
https://dev.mysql.com/doc/refman/8.4/en/bug-reports.html
We try to keep the manual up to date by updating it frequently with solutions to newly found problems. Normally mysqld should never corrupt a table if nothing killed it in the middle of an update. Before posting a bug report about a problem, please ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
It also updates the contents of the replication metadata repositories (see Section 19.2.4, “Relay Log and Replication Metadata Repositories”). For replication channels with this setting, in-memory file positions are still tracked, and file ...] ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during execution. The comparisons ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
CREATE USER permits these resource_option values: MAX_QUERIES_PER_HOUR count, MAX_UPDATES_PER_HOUR count, MAX_CONNECTIONS_PER_HOUR count For all accounts named by the statement, these options restrict how many queries, updates, and connections to ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/creating-ssl-rsa-files-using-mysql.html
MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The ...
https://dev.mysql.com/doc/refman/8.4/en/data-change-optimization.html
This section explains how to speed up data change statements: INSERT, UPDATE, and DELETE. Data analysis and reporting applications typically run data change operations that affect many rows at once, where the main considerations is the I/O to write ...Traditional OLTP applications and modern web applications typically do many small data change operations, where concurrency is ...