MyRocks and InnoDB: a summary

This has links to all performance reports from my recent series. I wanted to publish all of this by year end because I am taking a break from running and documenting MyRocks and MongoRocks performance.

Small server

Results from Intel NUC servers I have at home.

Insert benchmark:

• in-memory: MyRocks vs InnoDB
• io-bound: MyRocks vs InnoDB
• MyISAM from MySQL 5.0 to 8.0
• in-memory InnoDB from MySQL 5.0 to 8.0
• io-bound InnoDB from MySQL 5.0 to 8.0

Sysbench:

• in-memory, MyISAM from MySQL 5.0 to 8.0
• in-memory, InnoDB from MySQL 5.0 to 8.0
• in-memory, InnoDB vs MyRocks
• in-memory, MyRocks over time
• io-bound, InnoDB from MySQL 5.0 to 8.0
• io-bound, MyRocks over time
• io-bound, InnoDB vs MyRocks

Linkbench:

• in-memory
• io-bound

Fast server

Results from faster servers I use at work.

Insert benchmark:

• in-memory, low-concurrency
• in-memory, high-concurrency
• in-memory, high-concurrency, more contention
• io-bound
• io-bound, more contention

Sysbench:

• in-memory
• in-memory, more contention
• io-bound
• io-bound, more contention

Linkbench:

• in-memory
• io-bound

tpcc-mysql:

• in-memory
• io-bound