What is the benefit of using the MyRocks storage engine on RDS for MariaDB?

Question

[Latest RDS for MariaDB 10.6](https://aws.amazon.com/about-aws/whats-new/2022/02/amazon-rds-mariadb-supports-mariadb-10-6/) has support for storage engine MyRocks. What kind of workloads have you found that are best suited for it?

Answer

Certain OLTP workloads appear to benefit from MyRocks as the storage engine.

Bulk inserts are slower on MyRocks than on InnoDB, but the Sysbench oltp_read_write.lua script shows better performance with MyRocks.

(third-party link, not validated by AWS)

https://minervadb.com/index.php/2018/06/06/a-friendly-comparison-of-innodb-and-myrocks-performance/

What is the benefit of using the MyRocks storage engine on RDS for MariaDB?

Contenido relevante