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]