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