Replication Retries and Timeouts-opracowanie

Replication Retries and Timeouts
The global system variable slave_transaction_retries [2033] affects replication as
follows: If the slave SQL thread fails to execute a transaction because of an InnoDB deadlock
or because it exceeded the InnoDB innodb_lock_wait_timeout [1765] value, or the NDB
TransactionDeadlockDetectionTimeout or TransactionInactiveTimeout value, the slave
automatically retries the transaction slave_transaction_retries [2033] times before stopping
with an error. The default value is 10. The total retry count can be seen in the output of SHOW STATUS;
see Section 5.1.6, “Server Status Variables”.
... zobacz całą notatkę