Previously I evaluated MyRocks and InnoDB for an IO-bound
workload using a server with fast storage. Here I evaluate them
for an IO-bound workload using a server with a disk array.
MyRocks sustains higher load and query rates than InnoDB on a disk array because it does less random IO on writes which saves more random IO for reads. This was the original motivation for the LSM algorithm. MyRocks does better on SSD because it writes less data to …