I have a problem here. I cannot connect to a particular server remotely at certain times. I get the error remote connection is blocked because of many connection errors. I can login locally on the box.
To resolve this problem i would run FLUSH HOST and i can connect remotely. But say about every 10 hours i get the same error and i have to run FLUSH HOST. So to further investigate i ran SHOW VARIABLES on the mysql server and the variable max_connections is set to 100 and i ran SHOW STATUS and max_used_connections is 17. So Therefore, the server should allow more connections because it only states that 17 connections is used. I also ran mysqladmin processlist to see how many processes are running and it's only one. Is there a bug. I am using MySQL 3.22.32 Any ideas? _____________________________ Jason Hall Senior Integration Analyst ATT Canada | AES | Managed Hosting & Security Operations Office: 905-896-6250 Mobile: 416-884-4255 --------------------------------------------------------------------- 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