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.
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.
Also check for any firewall or NAT
On Sep 5, 2012 5:17 PM, "indrani gorti" 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 usin
- Original Message -
> From: "indrani gorti"
>
> 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 t
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 ta
