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