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 <wha...@bfs.de> 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 <wha...@bfs.de> 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 > >> > >> > > >