On Wed, Dec 04, 2002 at 12:21:06PM -0500, Jason Hall wrote: > 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.
Ok. > 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. You shoud fix the bug that's causing connection errors. Are you checking for errors in your code? Watching return values on connecting to MySQL? > 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. Right, but that has nothing to do with connection *errors*. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 14 days, processed 434,386,735 queries (344/sec. avg) --------------------------------------------------------------------- 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
