MySQL Replication / ... / Replication Notes and Tips / Replication Features and Issues / Replication Retries and Timeouts
The global system variableslave_transaction_retries affects replication as follows: If the replication SQL thread fails to execute a transaction because of anInnoDB deadlock or because it exceeded theInnoDBinnodb_lock_wait_timeout value, or theNDBTransactionDeadlockDetectionTimeout orTransactionInactiveTimeout value, the replica automatically retries the transactionslave_transaction_retries times before stopping with an error. The default value is 10. The total retry count can be seen in the output ofSHOW STATUS; seeServer Status Variables.