This post is mainly inspired by findings from the previous
testing of MySQL 8.0 on TPCC workload(s) and observations
from IO-bound Sysbench OLTP on Optane -vs- SSD. But
also by several "urban myths" I'm often hearing when discussing
with users about their IO-bound OLTP performance problems :
Myth #1 : "if I'll double the number of my storage drives -- I'll get x2 times better TPS !"
- this was mostly true during "HDD era", and again..
- (ex.: a single thread app doing single random IO reads from a single HDD will not go faster by doing the same from 2x HDD -- similar like single thread workload will not run faster on 8CPU cores -vs- 2CPU cores, etc.)
- all depends …