What I think is happening is the connections are not properly getting closed. The users are allowed to connect after a "flush user_resources" is run. Is there a bug in the particular version of MySQL (4.0.12) where the "user connections" are not getting decremented when a connection is "closed"?
Joe
Henrik Skotth wrote:
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]
