The global system variable
slave_transaction_retries
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
value,
or the NDBCLUSTER
TransactionDeadlockDetectionTimeout
or
TransactionInactiveTimeout
value, the slave
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
Section 5.1.7, “Server Status Variables”.
User Comments
Add your own comment.