Yes, I am referring to MAX_CONNECTIONS_PER_HOUR, poorly worded on my part sorry.
Users are granted access to only one database (barring errors in my scripts) and I did verify that his entry in mysql.user is 200 for max_connections. And the connections in the logfile are for the same user each time.
.....and they continue.....about 10 per second :(
Okay, well, this is weird then.
You say other accounts get rejected when they hit the limit. Do you have other such accounts that are set up exactly the same way as the problematic user?
What version of MySQL are you using?
Regards, Gary "SuperID" Huntress ======================================================= FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org
----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Gary Huntress" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, June 28, 2003 5:45 PM Subject: Re: max_connections being ignored/overridden?
thinkAt 17:26 -0400 6/28/03, Gary Huntress wrote: >I have some simple user quotas set to help balance my server load. I> in the GRANT statement?>I've implemented them properly because people do whine to me when they >reach the query limit. > >I have max_connections set to 200, but right now I'm watching connections >for 1 user scroll by at an alarming rate. 7800 in less than 5 minutes. > >What could I have done wrong for this user such that his max_connections >value of 200 is being ignored?
Maybe he's connecting as an account other than what you think, and that account has no limit?
By the way, max_connections is a server variable, not a user variable. I assume you're really talking about MAX_CONNECTIONS_PER_HOUR, as used
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
