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]
