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
Sep 06
Johan De Meersman Re: Help with mysql connect_timeout
Sep 06, 2012; 09:39
Johan De Meersman
Re: Help with mysql connect_timeout
Sep 06
Singer Wang Re: Help with mysql connect_timeout
Sep 06, 2012; 03:59
Singer Wang
Re: Help with mysql connect_timeout
Sep 10
Kamalakar Reddy Y Help with mysql connect_timeout
Sep 10, 2012; 15:58
Kamalakar Reddy Y
Help with mysql connect_timeout
Sep 10
Kamalakar Reddy Y Re: Help with mysql connect_timeout
Sep 10, 2012; 16:07
Kamalakar Reddy Y
Re: Help with mysql connect_timeout
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!