William R. Mussatto skrev: > 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')? >
In my case, yes. And all the processes (except for the "show processlist") are being run by the same user (mysql). -- Henrik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]