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/faqs-triggers.html
This is because, if both the source and the replica applied the changes from the source and, in addition, the trigger causing these changes were applied on the replica, the changes would in effect be applied twice on the replica, leading to ...Where ...
https://dev.mysql.com/doc/refman/8.0/en/federated-usagenotes.html
In addition, since returned rows must be stored in memory, such a query can also lead to the local server swapping, or even hanging. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server ...
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
Because floating-point values are approximate and not stored as exact values, attempts to treat them as exact in comparisons may lead to problems. The FLOAT and DOUBLE types represent approximate numeric data values. MySQL uses four bytes for ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-online-group.html
A group which is executing a configuration change cannot accept any other group configuration change, because concurrent configuration operations could lead to member divergence. You can configure an online group while Group Replication is running ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
However, if the network drops packets, leading to re-transmissions and higher end-to-end latency, throughput and latency are both negatively affected. What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
This is because foreign key constraints that result in cascading operations executed by a multi-primary mode group can result in undetected conflicts and lead to inconsistent data across the members of the group. Limit on Group Size Limits on ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-multi-primary-mode.html
In multi-primary mode, slower members can also build up an excessive backlog of transactions to certify and apply, leading to a greater risk of conflicts and certification failure. In multi-primary mode (group_replication_single_primary_mode=OFF) ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
Starting two servers or restarting one server with this option set while the group is running may lead to an artificial split brain situation, where two independent groups with the same name are bootstrapped. group_replication_paxos_single_leader ...
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
The dollar sign can still be used as the leading character of such an identifier when it is quoted according to the rules given later in this section. Certain objects within MySQL, including database, table, index, column, alias, view, stored ...
https://dev.mysql.com/doc/refman/8.0/en/import-table.html
If the string is a pattern, any leading directory path and the .sdi file name suffix must be given literally. The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata files.