Search Results
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
Based on the type of statements it issues (for example, reads versus writes), a client selects an appropriate server and connects to it. The client-side logic for detecting version token errors and selecting a new server can be implemented different ... Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-9-2-0.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Added two new connection options: read_timeout (time limit to receive a response from the server) and write_timeout (time limit to send data to the server). (Bug #115788, Bug ...Both options default to None, which sets the timeout to ...(WL #16381) The single and multiple statement execution mechanic was unified, when before a multi ...
https://dev.mysql.com/doc/refman/8.4/en/stop-replica.html
You can control how long STOP REPLICA waits before timing out by setting the system variable rpl_stop_replica_timeout. This can be used to avoid deadlocks between STOP REPLICA and other SQL statements using different client connections to the ...] ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync-monitoring.html
Some examples are: Rpl_semi_sync_source_clients The number of semisynchronous replicas that are connected to the source server. It is 0 if the plugin is not enabled or the source has fallen back to asynchronous replication due to commit ... The ...
https://dev.mysql.com/doc/refman/8.4/en/replication-semisync.html
Semisynchronous replication between a source and its replicas operates as follows: A replica indicates whether it is semisynchronous-capable when it connects to the source. If semisynchronous replication is enabled on the source side and there is at ... In addition to the built-in asynchronous replication, MySQL 8.4 supports an interface to semisynchronous replication that is implemented by ...
https://dev.mysql.com/doc/refman/8.4/en/stop-group-replication.html
To be completely safe, ensure that your applications can no longer connect to the instance before issuing this statement to avoid any chance of stale reads. The group_replication_components_stop_timeout system variable specifies the time for which ...This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-4.html
Handling of DBTC and API state alignment errors has been improved by this set of fixes, as well as scan protocol timeout handling in DBSPJ; now, when such misalignments in state are detected, the involved API nodes are disconnected rather than the ...(Bug #37331118) NDB Replication: When a MySQL server performing binary logging connects to an NDB Cluster, it checks for existing binary logs; if it finds any, it writes an Incident event to a log file of its own so that any downstream replicas can detect the potential for lost ...
https://dev.mysql.com/doc/internals/en/debug-sync-further-reading.html
See also worklog entry WL#4259 - Debug Sync Facility Reference manual 5.1 2.3.2 Typical configure Options (--enable-debug-sync) 5.1.2 Command Options (--debug-sync-timeout) 5.1.4 System Variables (debug_sync) Test framework manual 4.14 Thread ...
https://dev.mysql.com/doc/internals/en/semi-sync-replication.html
The clients COMMIT (or in auto-commit mode the current statement) waits until _one_ slave acknowledged that it received (not neccesarilly executed) the transaction or a timeout is reached. In MySQL 5.5 replication can optionally be made ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
To avoid timeouts, the semaphore wait threshold (600 seconds) is extended by 2 hours (7200 seconds) for CHECK TABLE operations. To avoid the possibility of a semaphore wait timeout entirely, run CHECK TABLE QUICK instead of CHECK TABLE. option: { ...