rocksDB vs InnoDB vsTokuDB-优快云博客

文章对TokuDB、RocksDB和InnoDB在特定环境下进行性能测试，测试环境包括Intel Xeon Gold 6140 CPU、NVME SSD及特定版本的MySQL。给出了OLTP插入、只读事务、读写事务性能的图形展示，最终结论是RocksDB更适合基于SSD的存储基础设施。

原文地址

https://minervadb.com/index.php/2018/08/06/comparing-tokudb-rocksdb-and-innodb-performance-on-intelr-xeonr-gold-6140-cpu/

该文测试的环境如下

CPU details (Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz with 72 CPUs)

Storage devices used for benchmarking (we used NVME SSD)

MySQL (we have used Percona Server 5.7.22-22 with InnoDB/XtraDB, TokuDB and RocksDB) configuration / system variables

测试结果下面提供简单的各环节结果及最终结论，各个库的配置参数等详情在原文中也有。

Graphical representation of OLTP INSERT performance in TokuDB, RocksDB and InnoDB:

Graphical representation of OLTP READ-ONLY transactions performance in TokuDB, RocksDB and InnoDB:

Graphical representation of OLTP READ-WRITE transactions performance in TokuDB, RocksDB and InnoDB:

The results of benchmarking concluded RocksDB the most ideal candidate for SSD based storage infrastructure compared to InnoDB and TokuDB, The most compelling reasons for using RocksDB on SSD are performance, storage efficiency/compression and much smaller write amplification compared to InnoDB or TokuDB.