Adjust perfschema autosizing for Percona Server mutexes
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Low
|
Laurynas Biveinis | ||
| 5.1 |
Invalid
|
Undecided
|
Unassigned | ||
| 5.5 |
Invalid
|
Undecided
|
Unassigned | ||
| 5.6 |
Fix Released
|
Low
|
Laurynas Biveinis | ||
Bug Description
Currently sizing_growth testcase is recorded as
status
FAILED: heuristics need to be updated
which is caused by Percona Server hitting four instead of three mutexes in MySQL for opening a connection. The three MySQL mutexes being wait/synch/
The comments in the testcase suggest trivially updating PFS autosizing heuristics in pfs_autosize.cc to account for four mutexes, so that the autosized performance_
I guess this has a negligible impact, but it's an easy fix and fixing it is probably a good idea as the current sizing_
Related branches
- Vlad Lesin (community): Approve (g2)
-
Diff: 177 lines (+22/-21)7 files modifiedPercona-Server/mysql-test/suite/perfschema/r/sizing_default.result (+4/-4)
Percona-Server/mysql-test/suite/perfschema/r/sizing_growth.result (+2/-2)
Percona-Server/mysql-test/suite/perfschema/r/sizing_high.result (+4/-4)
Percona-Server/mysql-test/suite/perfschema/r/sizing_low.result (+4/-4)
Percona-Server/mysql-test/suite/perfschema/r/sizing_med.result (+4/-4)
Percona-Server/mysql-test/suite/perfschema/t/sizing_growth.test (+3/-2)
Percona-Server/storage/perfschema/pfs_autosize.cc (+1/-1)
| tags: | added: merge-regression performance |
| tags: | added: low-hanging-fruit |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #1 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/