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/switchable-optimizations.html
Specifying any given opt_name more than once in the value is not permitted and causes an error. Any errors in the value cause the assignment to fail with an error, leaving the value of optimizer_switch unchanged. For batched_key_access to have any ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
If a standard source-to-replica replication channel is running on the existing primary member in addition to the Group Replication channels, you must stop that replication channel before you can change the primary member. Any uncommitted ... This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-new-primary.html
If a standard source to replica replication channel is running on the existing primary member in addition to the Group Replication channels, you must stop that replication channel before you can change the primary member. Any uncommitted ... The ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). The primary use case is modification of statements restored from dump files, so the typical ...
https://dev.mysql.com/doc/refman/8.0/en/setting-environment-variables.html
To set a variable permanently, you can set it in a startup file or by using the interface provided by your system for this purpose. To have the settings take effect each time you log in, use the interface provided by your system or place the ...
https://dev.mysql.com/doc/refman/8.0/en/show-binary-logs.html
SHOW BINARY LOGS SHOW MASTER LOGS Lists the binary log files on the server. Encrypted binary log files have a 512-byte file header that stores information required for encryption and decryption of the file. This is included in the file size ...This ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math.html
For example, you can treat a value that is too large for a column as an error rather than having the value truncated to lie within the range of the column's data type. Precision math is based on these two features: SQL modes that control how strict ...For example, MySQL treats a number such as .0001 as an exact value rather than as an approximation, and summing it 10,000 times produces a result of exactly 1, not a value that is merely “close” to ...
25.7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-auto-sync.html
It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster Replication”). The following Perl script reset-replica.pl serves as an example of how you can do this.
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
Windows does not permit open files to be deleted, so you first must flush all MERGE tables (with FLUSH TABLES) or drop the MERGE table before dropping the table. If you encounter an error message similar to ERROR 1017 (HY000): Can't find file: ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-timeout.html
The data also shows the number of retries for the last transaction and the transaction currently in progress, and enables you to identify the transient errors that caused the transactions to be retried. Transactions are automatically retried when ...