Hi, I am facing problem conneting to mysql from client machine.
I have MySQL server running on dummy2 machine and programs running on other client machine. when I check netstat -a , I get following tcp sockets in TIME_WAIT and ther are few in ESTABLISHED Any one has idea about , why the socket connection remains in TIME_WAIT. and how to solve this problem. Regards, Bharat Below is sample of netstat -a Actual connetions : 12425 TIME_WAIT 93 ESTABLISHED tcp 0 0 dummy2.ezee:mysql dummy77.ezee:3262 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy77.ezee:3261 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy77.ezee:3260 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy77.ezee:3259 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy77.ezee:3258 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy77.ezee:3257 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy77.ezee:3256 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy77.ezee:3255 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy77.ezee:3254 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2302 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2298 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2296 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2295 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2290 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy50.ezee:4741 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2283 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2281 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2277 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2274 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2271 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy101.ezee:2270 TIME_WAIT tcp 0 0 dummy2.ezee:mysql dummy50.ezee:4735 TIME_WAIT --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php