Comment 3 for bug 893348
Revision history for this message
| Gor Martsen (gor-x) wrote Re: [Bug 893348] Re: max_user_connections issue | #3 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
bbfa235
(Get the code!)
Hi Patrick
We are working on it too.
I will send you more details when be back home.
Regards,
Gor
Sent from my iPhone
On 2011-12-28, at 9:55 PM, Patrick Crews <email address hidden> wrote:
> Hi. I'll be taking a look at this bug soon and will be in touch if I
> have issues duplicating the problem.
>
> Thanks for the bug report,
> Patrick
>
> ** Changed in: percona-server
> Importance: Undecided => Medium
>
> ** Changed in: percona-server
> Assignee: (unassigned) => Patrick Crews (patrick-crews)
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https:/
>
> Title:
> max_user_
>
> Status in Percona Server with XtraDB:
> New
>
> Bug description:
> Hello
>
> We are using max_user_
> Three weeks ago we upgraded 6 servers to Percona-Server-5.5 from 5.1.
>
> And right after upgrade we noticed a problem with max_user_
> on all upgraded servers.
>
> Users that connects to database very often, started to experience problem:
> User ***** already has more than 'max_user_
> But "SHOW PROCESSLIST" did not list any active connections for this user!
>
> How you know, 5.5 has max_user_
> We put max_user_
>
> Known symptoms:
> - Problem does not come up after mysql restart. It takes some time.
> - "flush privileges" helps to reset counter, but after few hours issue is active again.
>
> It fills like max_user_
> users doesn't reset for some bug reason.
>
> Server hardware:
> 32GB RAM. 4x4 core CPUs, SAS HDDS in RAID1 for /var/lib/mysql.
> OS: centos5 x86_64
>
> I am ready to provide any information that will help to find and
> resolve this issue.
>
> Thank you.
>
> Regards,
> Gor
>
> To manage notifications about this bug go to:
> https:/