CHANGE USER performance problem
Bug #1419912 reported by
Jacek Zemło
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS |
Expired
|
Undecided
|
Unassigned | ||
Bug Description
I use persistent connections in my php application. On every request mysqli driver issues CHANGE USER command.
Execution of this command should be fast, but varies a lot and sometime takes up to 5 seconds to complete.
If thats help I use percona cloud and slow query log is available there. Agent Uuid for this server fd71dd95-
Percona version:
mysqld Ver 5.6.22-71.0 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release 71.0, Revision 726
Revision history for this message
| Sveta Smirnova (svetasmirnova) wrote | #1 |
| Changed in percona-server: | |
| status: | New → Incomplete |
Revision history for this message
| Launchpad Janitor (janitor) wrote | #2 |
| Changed in percona-server: | |
| status: | Incomplete → Expired |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
To post a comment you must log in.
Thank you for the report.
> Execution of this command should be fast, but varies a lot and sometime takes up to 5 seconds to complete.
Only operation which happens inside CHANGE USER is freeing statements. Is it possible what some of you connections create few statements/prepared statements/