Page 1 of 1

mysql query timeout behavior

Posted: Thu Oct 12, 2006 7:28 am
by amir
I have an application that was converted from SQL Server. In that application we had code that handlled query timeouts. I have searched the PHP manuals, MySQL manual, as well as google and cannot find anything about query timeouts.

Is there such a thing as a query timeout, or does a query such as a SELECT just run "forever?"

I am also interested in how this timeout can be changed, such as a line in my.cnf.