# MyRocks - [About MyRocks for MariaDB](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/about-myrocks-for-mariadb.md): 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](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/building-myrocks-in-mariadb.md): 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](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/differences-between-myrocks-variants.md): Differences between variants of the MyRocks storage engine. - [Getting Started with MyRocks](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/getting-started-with-myrocks.md): A guide to installing and configuring MyRocks, including enabling the plugin, setting up basic tables, and understanding key configuration parameters. - [Loading Data Into MyRocks](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/loading-data-into-myrocks.md): Best practices and methods for efficiently loading large datasets into MyRocks tables, including using bulk loading features to improve performance. - [MyRocks Bloom Filters](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-bloom-filters.md): 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](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-check-table.md): 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](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-data-compression.md): 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](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-group-commit-with-binary-log.md): 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](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-index-only-scans.md): MyRocks storage engine scans that only use indexes. - [MyRocks and Replication](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-replication.md): 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](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-and-start-transaction-with-consistent-snapshot.md): MyRocks storage engine transactions with consistent snapshot. - [MyRocks Column Families](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-column-families.md): 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](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-performance-troubleshooting.md): 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](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/optimizer-statistics-in-myrocks.md): MyRocks storage engine statistics for the query optimizer. - [MyRocks Transactional Isolation](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-transactional-isolation.md): MyRocks storage engine transactional isolatioin. - [MyRocks Status Variables](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-status-variables.md): A list of MyRocks-specific status variables providing metrics on cache hits, compaction statistics, block cache usage, and other internal operations. - [MyRocks System Variables](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks/myrocks-system-variables.md): A comprehensive reference for MyRocks system variables, allowing fine-tuning of performance, memory usage, compaction, and other internal behaviors. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://mariadb.com/docs/server/server-usage/storage-engines/myrocks.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.