From: indrani gorti Date: September 5 2012 9:16pm Subject: Help with mysql connect_timeout List-Archive: http://lists.mysql.com/mysql/228121 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=e89a8ff1c144e7661404c8fae4ad --e89a8ff1c144e7661404c8fae4ad Content-Type: text/plain; charset=ISO-8859-1 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 --e89a8ff1c144e7661404c8fae4ad--