Good question Yogesh, I can say the best solution is Create a deadlock and test it, you will come to know more about it.
On Wed, Jun 15, 2011 at 3:38 PM, Yogesh Kore <yogeshk...@gmail.com> wrote: > Hi, > > Small doubt for wait_timeout. > > If my wait_timeout is set for 180 seconds and if any deadlock occures and > both query are waiting to execute. What wil happen in that case? > 1. Do the connection will wait till deadlock is removed or > 2. Connection will close after 180 seconds as both queries are ideal and > waiting for each other. > > Thanks, > Yogesh > -- Thanks Suresh Kuna MySQL DBA