The global system variable
slave_transaction_retries
affects replication as follows: If the replication 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
transaction is automatically retried
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.