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 :( 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? > At 17:26 -0400 6/28/03, Gary Huntress wrote: > >I have some simple user quotas set to help balance my server load. I think > >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 > in the GRANT statement? > > > > > > > > >Regards, > >Gary "SuperID" Huntress > >======================================================= > >FreeSQL.org offering free database hosting to developers > >Visit http://www.freesql.org > > > -- > 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]
