I regularly have users email me reporting that they've hit the max (usually begging for me to raise or remove the limit)
An example (from this morning) is: SQL Error : 1226 User 'algalord' has exceeded the 'max_questions' resource (current value: 800) I similarly do get reports of connection limits too, so I have assumed the quotas operate properly. My server has two databases owned by root. All other databases are created via one script and permissions are set with the following statement: grant select, insert, update, delete, index, alter, create, drop on $dbname.* to $username@'%' identified by '$password' with max_queries_per_hour 800 max_updates_per_hour 0 max_connections_per_hour 200 (note the three php variables). I verified this particular users entry in mysql.user and it is correct. Users are mutually exclusive. A user has access to only their 1 database. My version is 4.0.13-standard-log. 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 7:09 PM Subject: Re: max_connections being ignored/overridden? > At 18:15 -0400 6/28/03, Gary Huntress wrote: > >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? > > > > > >> 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? > >> > > > -- > 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]
