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] > >> > >> > > > > > > > > > > -- > > 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] > > > > > > > -- > 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]
