Open
Bug 1598639
Opened 5 years ago
Updated 5 years ago
Investigate: innodb_io_capacity vs PIOPS
Categories
(Tree Management :: Treeherder: Infrastructure, task, P3)
Tree Management
Treeherder: Infrastructure
Tracking
(Not tracked)
NEW
People
(Reporter: ekyle, Unassigned)
References
(Blocks 1 open bug)
Details
In an effort to solve RDS slowness IOPS was switched to PIOPS 7000, this may be much higher than we need.
Plus, innodb_io_capacity
, innodb_io_capacity_max
also increased.
It would be nice to know how these numbers relate; they probably do not measure the same thing.
- Set
innodb_io_capacity_max
toinnodb_io_capacity
; reduceinnodb_io_capacity
to the point we see IO being constrained. As a side effect, our transactions should be getting longer - Adjust PIOPS downward until we see its constraining effect on IO.
This should provide us with a rough ratio, R
, we can use to set PIOPS in production: Set PIOPS >= R * innodb_io_capacity_max
so we have spare capacity for other processes on the machine (like the ability to login).
Updated•5 years ago
|
Priority: -- → P3
You need to log in
before you can comment on or make changes to this bug.
Description
•