Hi! Thanks for the info. We ARE getting tons of connections/second, so that might be the problem... We hoped that 4.0.16 would solve it, which it didn't, so now we're hoping for 4.0.17...
-- Henrik Matt W skrev: > Hi guys, > > Just wanted to say that I think I remember a recent commit to the source > tree to correct a problem or problems with max_user_connections > counting. I think one of them was a race condition if 2 threads tried to > increase/decrease the counter at once. But it seems like that would > rarely happen for you guys unless you're getting tons of > connections/second. I'm pretty sure there was another issue that was > throwing the count off. > > I guess you'll have to see if it's fixed in the next release (4.0.17). > > Sorry I can't remember more details. > > > Matt > > > > ----- Original Message ----- > From: "Joe Lewis" > Sent: Wednesday, November 12, 2003 11:41 AM > Subject: Re: max_user_connections problem after upgrading > > >> We're experiencing the same issues, but not neccesarily after an >> upgrade. We're using MySQL 4.0.12 and FreeBSD 4.7 Release. We're >> getting max'd connections only on specific users, and the "show >> processlist" is returning only the "show processlist" process. the >> results of netstat show absolutely nothing. >> >> What I think is happening is the connections are not properly getting >> closed. The users are allowed to connect after a "flush > user_resources" >> is run. Is there a bug in the particular version of MySQL (4.0.12) >> where the "user connections" are not getting decremented when a >> connection is "closed"? >> >> Joe >> >> Henrik Skotth wrote: >> >> > I'm mostly using mytop, and that's the way that I see that there are > no >> > (are almost no) connections when the server claims that it is above > the >> > connection limit... So I guess that there's something seriously > wrong >> > then... Any ideas what? >> > >> > -- Henrik >> > >> > >> > [EMAIL PROTECTED] (Pete Harlan) skrev: >> > >> >>What does "show processlist" say when the connections are maxed out? >> >>(You may have to leave a client logged in to reserve a slot so you > can >> >>submit this query.) >> >> >> >>If it shows only a few connections, then there's something seriously >> >>wrong. If it shows a ton of idle connections, it should tell you >> >>which machines they are coming from and which users, and that should >> >>help you track down who's holding connections open. >> >> >> >>--Pete >> >> >> >> >> >>On Wed, Nov 12, 2003 at 01:15:54AM +0100, Henrik Skotth wrote: >> >> >> >>>Hello! >> >>> >> >>>I have tested this now, and that isn't the case. Any other ideas? >> >>> >> >>>-- Henrik >> >>> >> >>> >> >>>Michael McTernan skrev: >> >>> >> >>>>Hi, >> >>>> >> >>>>Have you tried "netstat -a" on the box with the MySQL server? > This >> >>>>command >> >>>>(Linux) will show what is connected to where, and will help you > double >> >>>>check >> >>>>that there really aren't any open connections to the server. >> >>>> >> >>>>Thanks, >> >>>> >> >>>>Mike >> >>>> >> >>>> >> >>>>>-----Original Message----- >> >>>>>From: Henrik Skotth [mailto:[EMAIL PROTECTED] >> >>>>>Sent: 10 November 2003 18:54 >> >>>>>To: [EMAIL PROTECTED] >> >>>>>Subject: Re: max_user_connections problem after upgrading >> >>>>> >> >>>>> >> >>>>>That's new for 4.0? Hadn't noticed it... Anyway, it's set to 0 so >> >>> >> >>>there >> >>> >> >>>>>is >> >>>>>no limit to exceed. >> >>>>>Also, we aren't getting the error messages ALL the time, they > start >> >>> >> >>>to >> >>> >> >>>>>appear after a day or two and gets more and more frequent untill > I >> >>>>>restart >> >>>>>mysql. Any other ideas? >> >>>>> >> >>>>>-- Henrik >> >>>>> >> >>>>>gerald_clark skrev: >> >>>>> >> >>>>>>Are you sure you are net exceeding the setting for >> >>>>>>maximum connections per hour for that user? >> >>>>>> >> >>>>>>Henrik Skotth wrote: >> >>>>>> >> >>>>>> >> >>>>>>>Hi! >> >>>>>>> >> >>>>>>>What I meant was that even if there are currently only two user >> >>>>>>>connections being used, and the limit is 300, we still get the >> >>>>> >> >>>>>"already >> >>>>>more than max_user_connections" error... >> >>>>> >> >>>>>>>-- Henrik >> >>>>>>> >> >>>>>>>gerald_clark skrev: >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>>>Henrik Skotth wrote: >> >>>>>>>> >> >>>>>>>> >> >>>>>>>> >> >>>>>>>> >> >>>>>>>>>Hello all, >> >>>>>>>>> >> >>>>>>>>>We recently upgraded to 4.0, it went >> >>>>>>>>>very well and the performance gains have been great. >> >>>>>>>>>But now the server has started to act strangely. Every few > days, >> >>> >> >>>the >> >>> >> >>>>>>>>> >> >>>>>>>server starts to refuse connections, saying >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>>>>that there is already more than max_user_connections, but > there >> >>> >> >>>is >> >>> >> >>>>>>>>> >> >>>>>>>really only one or two active connections and our >> >>> >> >>>max_user_connections >> >>> >> >>>>>is 300. I have to take down and restart the server to solve the >> >>> >> >>>problem, >> >>> >> >>>>>and it keeps happening over and over again every few days... >> >>>>> >> >>>>>>> >> >>>>>>>>>Am I the only one having this problem? Any suggestions? >> >>>>>>>>> >> >>>>>>>>>Regards, >> >>>>>>>>>-- Henrik Skotth, Hogwarts.nu >> >>>>>>>>> >> >>>>>>>>> >> >>>>>>>>> >> >>>>>>>>> >> >>>>>>>>> >> >>>>>>>> >> >>>>>>>>Are there 298 or 299 inactive connections? >> >>>>>>>>If so, why are they not being closed? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
