buf_pool_resize can lock less in checking whether AHI is on or off
Bug #1525215 reported by
Laurynas Biveinis
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Invalid
|
Undecided
|
Unassigned | |||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Fix Released
|
Low
|
Laurynas Biveinis |
Bug Description
Copy of https:/
[21 Oct 7:07] Laurynas Biveinis
Description:
void
buf_pool_resize()
{
...
btr_search_
if (btr_search_
btr_search_
btr_search_
} else {
btr_search_
}
...
So, it S-latches all the partitions to read btr_search_enabled. But btr_search_
How to repeat:
Code analysis
Suggested fix:
S-latch only the first or the last or any random partition.
tags: | added: innodb performance upstream |
To post a comment you must log in.
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-3340