This compares RocksDB and InnoDB storage engines using sysbench
and extends the results I shared yesterday. I continue to get
great performance from MyRocks and this is a bonus as my motivation for
using it is better storage efficiency.
tl;dr - MyRocks is usually equal to or faster than InnoDB on these tests
The test server for InnoDB and RocksDB has 2 sockets, 24 cores (48 HW threads), 256G of …