Search Results
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: { ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
If the cloning operation is unable to obtain a DDL lock within the time limit specified by the clone_ddl_timeout variable, an error is reported. If a network error occurs during a cloning operation, the operation resumes if the error is resolved ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
Transactions whose consistency level is not EVENTUAL hold execution until a timeout, configured by wait_timeout value is reached, which defaults to 8 hours. A transaction cannot be on-hold forever, and if the time held exceeds wait_timeout it ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-rejoin.html
The group_replication_autorejoin_tries system variable makes a member that has been expelled or reached its unreachable majority timeout try to rejoin the group automatically. With auto-rejoin, when the member's expulsion or unreachable majority ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transaction-inconsistencies.html
After this timeout, the coordinator gives up and aborts the transaction. After this timeout, it aborts the transaction, so it may be left half-completed. The global setting for the system variable rpl_stop_replica_timeout is unrelated to the process ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
--lock-wait-timeout Command-Line Format --lock-wait-timeout=S Type Numeric Default Value 60 Minimum Value 1 Unit second The option is no longer supported. These options limit the resources used by the backup process, in order to minimize backup ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/adminapi-executing-sql.html
The following example shows how to retrieve the values of the variables report_host and report_port from all members except Read Replicas: cluster.execute("SHOW VARIABLES WHERE VARIABLE_NAME IN ('REPORT_HOST', 'REPORT_PORT');", "a", {exclude: "rr"}) ... The execute() function enables you to execute SQL queries and statements across all, or a selection of, the members of a ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-cluster-repair.html
You can use the runningTransactionsTimeout option to specify a timeout between 0 and 3600 seconds for transactions that are running when you use the function, which also stops new incoming transactions. There is no default setting for the timeout, ... Depending on the issues or maintenance requirements for the cluster, the following operations are available for you to work with its member ...