Also check for any firewall or NAT On Sep 5, 2012 5:17 PM, "indrani gorti" <indrani.go...@gmail.com> wrote:
> Hi all, > I am a newbie to work with the settings in mysql although I have used in > very small applications before > I am currently experimenting with very large tables and a few complicated > queries. I am using mysql 5.5. My tables are of size of abt 1 million > tuples. The queries upon these tables take more than 10 minutes and hence > the connection timeout. > I learnt that there are various timeouts . I tried using > SHOW VARIABLES LIKE '%TIMEOUT%'; and found that the connect-timeout is 10 > ( about 600.495 secs) > > 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. > > Can anyone please let me know whats wrong? > Thanks in advance for the help. > > Regards, > Indrani Gorti >