innodb_lock_wait_timeout

2012-10-11 Thread Markus Falb
timeouts are normal on busy servers and it is necessary for applications to be aware that they may happen and handle them by retrying. snap... But why is retrying better than raising the value? So what is better, adjusting the timeout or retrying application side and why? -- Kind Regards, Markus

Re: innodb_lock_wait_timeout

2012-10-12 Thread Markus Falb
On 11.10.2012 14:43, Johan De Meersman wrote: > > - Original Message - >> From: "Markus Falb" >> >> But why is retrying better than raising the value? >> >> So what is better, adjusting the timeout or retrying application side >> an

innodb_lock_wait_timeout and replication

2012-10-12 Thread Markus Falb
failed? If it is in the binlog it will be replicated to a slave and on the slave it will succeed (maybe). Does this mean that a Lock wait timeout exceeded potentially drive the slave out of sync? -- Kind Regards, Markus Falb signature.asc Description: OpenPGP digital signature