Spurious innodb_io_capacity-sized flush list flushes on a loaded server
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Laurynas Biveinis | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Fix Released
|
Medium
|
Laurynas Biveinis |
Bug Description
The furious flushing, implemented by skipping page cleaner thread sleeps, in combination with short-duration LRU and flush list flushes, means that server activity might be not updated by the next page cleaner thread iteration.
This has an effect of spuriously issuing innodb_
The fix is to maintain server activity accounting based on 1 second granularity. That is, an active server may only be considered inactive if no server activity bump in the last 1 second, as opposed to last cleaner thread iteration. An inactive server may be considered active immediately after the server activity bump.
Related branches
- George Ormond Lorch III (community): Approve (g2)
-
Diff: 37 lines (+11/-2)1 file modifiedPercona-Server/storage/innobase/buf/buf0flu.cc (+11/-2)
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-1437