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]
