Re: max_connections being ignored/overridden?
Gary Huntress [EMAIL PROTECTED] 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? Does SHOW GRANTS show you 200 as MAX_CONNECTIONS_PER_HOUR value for this user? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max_connections being ignored/overridden?
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? Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
Re: max_connections being ignored/overridden?
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]
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]
Re: max_connections being ignored/overridden?
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]