Insert benchmark: in-memory, high-concurrency, fast server

10 news today, 461 news this week, 3285 news in total. 166 Projects.
This post explains the insert benchmark with an in-memory and high-concurrency workload for MyRocks, InnoDB and TokuDB. The goal is to understand throughput and efficiency for different storage engines and different versions of MySQL. The previous test used a low-concurrency, in-memory workload with 1 query client and 1 table. This test uses 16 concurrent clients and 16 tables.tl;dr - for an in-memory, high-concurrency workload InnoDB 5.7 has the best insert rate. The rate for MyRocks is better than InnoDB 5.6 but we have work to do to close the gap with modern InnoDB. InnoDB 5.6 has the best...
Mysql
Date