Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
If backed-up log files are encrypted, also back up the corresponding encryption passwords to a safe place, should you need to decrypt the files later. This section describes how to configure audit logging characteristics, such as the file to which ...
https://dev.mysql.com/doc/refman/8.4/en/backup-strategy-summary.html
If you have such safe media, this technique can also be good for disk load balancing (which results in a performance improvement). In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make ...
https://dev.mysql.com/doc/refman/8.4/en/can-not-connect-to-server.html
It is safe to reduce TIME_WAIT greatly on LAN connections because there is little chance of packets arriving at very long delays, as they could through the Internet with its comparatively large distances and latencies. A MySQL client on Unix can ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-create.html
Provided that the write error is to a test file, the error is not serious and can be safely ignored. If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-encrypted-data.html
The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer of unencrypted tablespace keys over the network. Tablespace keys are decrypted at the donor before transport and re-encrypted at the ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
The predicate must employ the equality operator = for making the comparison; the null-safe <=> operator is not supported in this context. A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query.
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary.html
MySQL Server incorporates a transactional data dictionary that stores information about database objects. In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data ...
https://dev.mysql.com/doc/refman/8.4/en/delete-optimization.html
Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table lock. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
server_id=1 gtid_mode=ON enforce_gtid_consistency=ON These settings configure the server to use the unique identifier number 1, to enable Section 19.1.3, “Replication with Global Transaction Identifiers”, and to allow execution of only ... This ...