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]