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