PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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.
https://dev.mysql.com/doc/refman/9.7/en/innodb-deadlock-example.html
If client A attempts to update a row in Birds at the same time, this will lead to a deadlock: mysql> UPDATE Birds SET value=40 WHERE name='Buzzard'; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction InnoDB rolls ... The following example illustrates how an error can occur when a lock request causes a ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-disabling-tablespace-path-validation.html
Manually moved tablespace files will not be detected! Warning Starting the server with tablespace path validation disabled after moving tablespace files can lead to undefined behavior. At startup, InnoDB scans directories defined by the ...