From: Yogesh Kore
Date: June 15 2011 10:08am
Subject: Query on wait_timeout
List-Archive: http://lists.mysql.com/mysql/225259
Message-Id: <BANLkTimZ5T8rQWCGuHiM+=nc4Vu0KktBEA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=20cf3054a8911e94bd04a5bd54a7

--20cf3054a8911e94bd04a5bd54a7
Content-Type: text/plain; charset=ISO-8859-1

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

--20cf3054a8911e94bd04a5bd54a7--