max_user_connections issue
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Unassigned | ||
5.1 |
Won't Fix
|
Medium
|
Unassigned | ||
5.5 |
Fix Released
|
Medium
|
Unassigned |
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_
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_
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
Changed in percona-server: | |
status: | New → Triaged |
assignee: | Patrick Crews (patrick-crews) → nobody |
Changed in percona-server: | |
status: | Triaged → Confirmed |
description: | updated |
tags: | added: i23110 |
tags: | added: contribution |
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