----- Original Message ----- > From: "indrani gorti" <indrani.go...@gmail.com> > > Later I changed it to SET GLOBAL connect_timeout=60; > However, I still find that the query loses the connection to mysql > server after about 10 mins( 600.495 secs) > I see that the connect_time is 60 though.
If I recall correctly, all timeouts are set in seconds, not minutes. However, as long as a query is running, MySQL should not timeout your connection. It seems more likely that your application gives up. Assuming this is a website, check your max script runtime settings. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql