Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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.7/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.7/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 ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/innodb-clusterset-dissolve.html
You can also use this option if a timeout is reached waiting for all transactions to be applied on a secondary member. ClusterSet.dissolve() accepts a timeout option, which specifies the number of seconds to wait for pending transactions to be ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/manage-sandbox-instances.html
The operation fails with a timeout, and the error log contains: 2020-03-26T11:43:12.969131Z 5 [System] [MY-013381] [Server] Server upgrade from '80019' to '80020' started. Although the operation seems to fail with a timeout, the sandbox has started ... Once a sandbox instance is running, it is possible to change its status at any time using the following ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/replicaset-dissolving.html
You can also use this option if a timeout is reached waiting for all transactions to be applied on a secondary member. replicaSet.dissolve() accepts a timeout option, which specifies the number of seconds to wait for pending transactions to be ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
The MySQL Server may be closing idle connections that exceed the wait_timeout or interactive_timeout threshold. Ensure that any configurable firewall or router timeout settings allow for the maximum expected connection idle time. This section ...