Help with mysql connect_timeout

[Kamalakar Reddy Y]

But connect-timeout has nothing to do with termination of query. It is no.
of secs that mysqld server waits for a connect packet before responding
with Bad handshake, default value is 10 seconds.

Probably you should adjust net_read /write_ timeout.

Re: Help with mysql connect_timeout

[Kamalakar Reddy Y]

But connect-timeout has nothing to do with termination of query. It is no.
of secs that mysqld server waits for a connect packet before responding
with Bad handshake, default value is 10 seconds.

Probably you should adjust net_read /write_ timeout.

Re: Help with mysql connect_timeout

[Johan De Meersman]

- 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

Re: Help with mysql connect_timeout

[Singer Wang]

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

Help with mysql connect_timeout

[indrani gorti]

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