> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks.md).

# MyRocks

{% columns %}
{% column %}
{% content-ref url="/pages/n7L8kuhPBdKpqZzhaEFi" %}
[About MyRocks for MariaDB](/docs/server/server-usage/storage-engines/myrocks/about-myrocks-for-mariadb.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
MyRocks is a storage engine based on RocksDB, optimized for high-write workloads and flash storage, offering superior compression and reduced write amplification.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/bcKq5cyj96gnuv9PQXMh" %}
[Building MyRocks in MariaDB](/docs/server/server-usage/storage-engines/myrocks/building-myrocks-in-mariadb.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn how to build the MyRocks storage engine from source within the MariaDB Server build process, including necessary dependencies and configuration options.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/IncdObtMFjevahGHGF8S" %}
[Differences Between MyRocks Variants](/docs/server/server-usage/storage-engines/myrocks/differences-between-myrocks-variants.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Differences between variants of the MyRocks storage engine.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/NIVKHI31zYObJu1UKmzM" %}
[Getting Started with MyRocks](/docs/server/server-usage/storage-engines/myrocks/getting-started-with-myrocks.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A guide to installing and configuring MyRocks, including enabling the plugin, setting up basic tables, and understanding key configuration parameters.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/NzltXVlzJubJxO9aKln5" %}
[Loading Data Into MyRocks](/docs/server/server-usage/storage-engines/myrocks/loading-data-into-myrocks.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Best practices and methods for efficiently loading large datasets into MyRocks tables, including using bulk loading features to improve performance.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ehD02OgBjYsHEfsW9FCu" %}
[MyRocks Bloom Filters](/docs/server/server-usage/storage-engines/myrocks/myrocks-and-bloom-filters.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/Omn9ntP0xe5L7Qff5HMV" %}
[MyRocks CHECK TABLE](/docs/server/server-usage/storage-engines/myrocks/myrocks-and-check-table.md)
{% endcontent-ref %}
{% endcolumn %}

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

{% columns %}
{% column %}
{% content-ref url="/pages/M8QF7dO2pC95JUFnXNkF" %}
[MyRocks Data Compression](/docs/server/server-usage/storage-engines/myrocks/myrocks-and-data-compression.md)
{% endcontent-ref %}
{% endcolumn %}

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

{% columns %}
{% column %}
{% content-ref url="/pages/aC2oLrhM6He0IzAqcIDF" %}
[MyRocks Group Commit with Binary log](/docs/server/server-usage/storage-engines/myrocks/myrocks-and-group-commit-with-binary-log.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Understand how MyRocks implements group commit to coordinate with the binary log, ensuring data consistency and crash safety for replicated transactions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/8y2W0VYw01ZQDGWbMI2B" %}
[MyRocks Index-Only Scans](/docs/server/server-usage/storage-engines/myrocks/myrocks-and-index-only-scans.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
MyRocks storage engine scans that only use indexes.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/whutih906vhvNDvTqGVk" %}
[MyRocks and Replication](/docs/server/server-usage/storage-engines/myrocks/myrocks-and-replication.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This page details how MyRocks integrates with MariaDB replication, specifically addressing limitations with statement-based replication and lack of Gap Lock support.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/y0MP2Sjt0JgMsDR9kI2u" %}
[MyRocks START TRANSACTION WITH CONSISTENT SNAPSHOT](/docs/server/server-usage/storage-engines/myrocks/myrocks-and-start-transaction-with-consistent-snapshot.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
MyRocks storage engine transactions with consistent snapshot.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/kptx2yUkLJ7Akm2Rlecj" %}
[MyRocks Column Families](/docs/server/server-usage/storage-engines/myrocks/myrocks-column-families.md)
{% endcontent-ref %}
{% endcolumn %}

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

{% columns %}
{% column %}
{% content-ref url="/pages/w83Cr3nsQpfmi4zw18hN" %}
[MyRocks Performance Troubleshooting](/docs/server/server-usage/storage-engines/myrocks/myrocks-performance-troubleshooting.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A guide to diagnosing and resolving performance issues in MyRocks using status variables, `SHOW ENGINE ROCKSDB STATUS`, and RocksDB performance context.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/yT13j5VpkW993L3uxuSm" %}
[Optimizer Statistics in MyRocks](/docs/server/server-usage/storage-engines/myrocks/optimizer-statistics-in-myrocks.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
MyRocks storage engine statistics for the query optimizer.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/fpCJPpA55UualxDF0JZt" %}
[MyRocks Transactional Isolation](/docs/server/server-usage/storage-engines/myrocks/myrocks-transactional-isolation.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
MyRocks storage engine transactional isolatioin.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/ZxYm3gck0wfdFw8jkX1o" %}
[MyRocks Status Variables](/docs/server/server-usage/storage-engines/myrocks/myrocks-status-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A list of MyRocks-specific status variables providing metrics on cache hits, compaction statistics, block cache usage, and other internal operations.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/QTROykwi3XcgszFaELp5" %}
[MyRocks System Variables](/docs/server/server-usage/storage-engines/myrocks/myrocks-system-variables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A comprehensive reference for MyRocks system variables, allowing fine-tuning of performance, memory usage, compaction, and other internal behaviors.
{% endcolumn %}
{% endcolumns %}