Re: MySQL Error 1205
How long do the transactions [normally] take to run?
Under a second? This should be a fairly rare occurrence, unless you're on a really flaky network.
Longer than a second? What on Earth are your Transactions doing?
Is there any user "involvement" in the transaction? Can they "do stuff" in the application between the "Begin" and the "Commit" being issued? They shouldn't.
"Begin, do stuff, Commit". Keep it simple. Keep it short.
Regards, Phill W.
Subject
Written By
Posted
Re: MySQL Error 1205
August 07, 2014 05:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.