From: Ananda Kumar Date: July 23 2012 2:10pm Subject: Re: restrict Connect Time List-Archive: http://lists.mysql.com/mysql/227871 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=047d7b2ed4ad2f566304c57fcf33 --047d7b2ed4ad2f566304c57fcf33 Content-Type: text/plain; charset=ISO-8859-1 you can check the slow query log, this will give you all the sql's which are taking more time to execute On Mon, Jul 23, 2012 at 7:38 PM, walter harms wrote: > > > Am 23.07.2012 15:47, schrieb Ananda Kumar: > > you can set this is in application server. > > You can also set this parameter in my.cnf > > wait_timeout=120 in seconds. > > But the above parameter is only for inactive session > > > > > acutualy i want to catch scripts running wild. > > re, > wh > > > > > On Mon, Jul 23, 2012 at 6:18 PM, walter harms wrote: > > > >> Hi list, > >> is there a switch where i can restrict the connect/execution time for a > >> query ? > >> > >> re, > >> wh > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: http://lists.mysql.com/mysql > >> > >> > > > --047d7b2ed4ad2f566304c57fcf33--