PDF (US Ltr)
- 1.4Mb
PDF (A4)
- 1.4Mb
The global system variable
slave_transaction_retries
affects replication as follows: If the replication SQL thread
fails to execute a transaction because of an
InnoDB deadlock or because it exceeded the
InnoDB
innodb_lock_wait_timeout value,
or the NDB
TransactionDeadlockDetectionTimeout or
TransactionInactiveTimeout value, the replica
automatically retries the transaction
slave_transaction_retries 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
Server Status Variables.