List:General Discussion« Previous MessageNext Message »
From:Singer Wang Date:September 6 2012 7:59am
Subject:Re: Help with mysql connect_timeout
View as plain text  
Also check for any firewall or NAT
On Sep 5, 2012 5:17 PM, "indrani gorti" <indrani.gorti@stripped> 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
>

Thread
Help with mysql connect_timeoutindrani gorti5 Sep
  • Re: Help with mysql connect_timeoutJohan De Meersman6 Sep
  • Re: Help with mysql connect_timeoutSinger Wang6 Sep