Joe Lewis said: > 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? Is the user running "show processlist" allowed to see all processes (e.g. 'root')? William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
