MyRocks

Learn about the MyRocks storage engine in MariaDB Server. Discover its advantages for flash storage, high write throughput, and compression efficiency in modern database deployments.

MyRocks is a community contribution to MariaDB Server. It is based on RocksDB and on Facebook's MyRocks, which are developed and maintained upstream, outside MariaDB.

About MyRocks for MariaDB

MyRocks is a storage engine based on RocksDB, optimized for high-write workloads and flash storage, offering superior compression and reduced write amplification.

Building MyRocks in MariaDB

Learn how to build the MyRocks storage engine from source within the MariaDB Server build process, including necessary dependencies and configuration options.

Differences Between MyRocks Variants

Differences between variants of the MyRocks storage engine.

Getting Started with MyRocks

A guide to installing and configuring MyRocks, including enabling the plugin, setting up basic tables, and understanding key configuration parameters.

Loading Data Into MyRocks

Best practices and methods for efficiently loading large datasets into MyRocks tables, including using bulk loading features to improve performance.

MyRocks Bloom Filters

Learn how to configure and use Bloom filters in MyRocks to speed up point lookups by probabilistically determining if a key exists in a data file.

MyRocks CHECK TABLE

Details on using the CHECK TABLE statement with MyRocks to verify the integrity of tables and indexes, and how it differs from other engines.

MyRocks Data Compression

Explore the data compression options available in MyRocks, including different algorithms (Zstd, LZ4, etc.) and how to configure them per column family.

MyRocks Group Commit with Binary log

Understand how MyRocks implements group commit to coordinate with the binary log, ensuring data consistency and crash safety for replicated transactions.

MyRocks Index-Only Scans

MyRocks storage engine scans that only use indexes.

MyRocks and Replication

This page details how MyRocks integrates with MariaDB replication, specifically addressing limitations with statement-based replication and lack of Gap Lock support.

MyRocks START TRANSACTION WITH CONSISTENT SNAPSHOT

MyRocks storage engine transactions with consistent snapshot.

MyRocks Column Families

Learn about MyRocks column families, a mechanism for grouping data similar to tablespaces, to optimize compression and Bloom filter settings per family.

MyRocks Performance Troubleshooting

A guide to diagnosing and resolving performance issues in MyRocks using status variables, SHOW ENGINE ROCKSDB STATUS, and RocksDB performance context.

Optimizer Statistics in MyRocks

MyRocks storage engine statistics for the query optimizer.

MyRocks Transactional Isolation

MyRocks storage engine transactional isolatioin.

MyRocks Status Variables

A list of MyRocks-specific status variables providing metrics on cache hits, compaction statistics, block cache usage, and other internal operations.

MyRocks System Variables

A comprehensive reference for MyRocks system variables, allowing fine-tuning of performance, memory usage, compaction, and other internal behaviors.

_{This page is licensed: CC BY-SA / Gnu FDL}