# Storage Engines

{% columns %}
{% column %}
{% content-ref url="storage-engines/storage-engines-storage-engines-overview" %}
[storage-engines-storage-engines-overview](https://mariadb.com/docs/server/server-usage/storage-engines/storage-engines-storage-engines-overview)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
An introduction to MariaDB's pluggable storage engine architecture, highlighting key engines like InnoDB, MyISAM, and Aria for different workloads.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/choosing-the-right-storage-engine" %}
[choosing-the-right-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/choosing-the-right-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
A guide to selecting the appropriate storage engine based on data needs, comparing features of general-purpose, columnar, and specialized engines.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/archive" %}
[archive](https://mariadb.com/docs/server/server-usage/storage-engines/archive)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The Archive storage engine is optimized for high-speed insertion and compression of large amounts of data, suitable for logging and auditing.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/aria" %}
[aria](https://mariadb.com/docs/server/server-usage/storage-engines/aria)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about the Aria storage engine in MariaDB Server. Understand its features, advantages, and use cases, particularly for crash-safe operations and transactional workloads.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/blackhole" %}
[blackhole](https://mariadb.com/docs/server/server-usage/storage-engines/blackhole)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The BLACKHOLE storage engine discards all data written to it but records operations in the binary log, useful for replication filtering and testing.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/connect" %}
[connect](https://mariadb.com/docs/server/server-usage/storage-engines/connect)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The CONNECT storage engine has been deprecated.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/csv" %}
[csv](https://mariadb.com/docs/server/server-usage/storage-engines/csv)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The CSV storage engine stores data in text files using comma-separated values format, allowing easy data exchange with other applications.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/federatedx-storage-engine" %}
[federatedx-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/federatedx-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
FederatedX is a storage engine that allows access to tables on remote MariaDB or MySQL servers as if they were local tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/innodb" %}
[innodb](https://mariadb.com/docs/server/server-usage/storage-engines/innodb)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Discover InnoDB, the default storage engine for MariaDB Server. Learn about its transaction-safe capabilities, foreign key support, and high performance for demanding workloads.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/memory-storage-engine" %}
[memory-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/memory-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The MEMORY storage engine stores tables in RAM for fast access, but data is lost upon server restart.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/merge" %}
[merge](https://mariadb.com/docs/server/server-usage/storage-engines/merge)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The MERGE storage engine allows a collection of identical MyISAM tables to be treated as a single logical table, useful for managing large datasets.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/mroonga" %}
[mroonga](https://mariadb.com/docs/server/server-usage/storage-engines/mroonga)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Mroonga (formerly named Groonga Storage Engine) is a storage engine that provides fast CJK-ready full text searching using column store.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/myisam-storage-engine" %}
[myisam-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/myisam-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore the MyISAM storage engine in MariaDB Server. Understand its characteristics, including suitability for read-heavy workloads, and its role in specific use cases.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/myrocks" %}
[myrocks](https://mariadb.com/docs/server/server-usage/storage-engines/myrocks)
{% endcontent-ref %}
{% endcolumn %}

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

{% columns %}
{% column %}
{% content-ref url="storage-engines/oqgraph-storage-engine" %}
[oqgraph-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/oqgraph-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore the OQGRAPH storage engine in MariaDB Server. Learn how to efficiently manage hierarchical and complex graph data structures, perfect for social networks and bill of materials.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/performance\_schema-storage-engine" %}
[performance\_schema-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/performance_schema-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
While technically a storage engine, PERFORMANCE\_SCHEMA provides a way to inspect internal server execution details at a low level.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/sequence-storage-engine" %}
[sequence-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/sequence-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The Sequence engine generates virtual tables of number sequences on the fly, useful for generating series of integers without storing data.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/s3-storage-engine" %}
[s3-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/s3-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Integrate MariaDB Server with Amazon S3 using the S3 Storage Engine. Learn how to store and retrieve data directly from cloud object storage for scalability and cost efficiency.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/sphinx-storage-engine" %}
[sphinx-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/sphinx-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Integrate MariaDB Server with Sphinx for advanced full-text search. The Sphinx storage engine allows you to query external Sphinx indexes directly from your database.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/spider" %}
[spider](https://mariadb.com/docs/server/server-usage/storage-engines/spider)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore the Spider storage engine in MariaDB Server. Learn how to shard data across multiple MariaDB and MySQL servers, enabling horizontal scaling and distributed database solutions.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/videx-storage-engine" %}
[videx-storage-engine](https://mariadb.com/docs/server/server-usage/storage-engines/videx-storage-engine)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
The VIDEX storage engine is an aggregated, extensible engine suitable for what-if analyses in MariaDB. The name is derived from \[VI]rtual in\[DEX].
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/converting-tables-from-myisam-to-innodb" %}
[converting-tables-from-myisam-to-innodb](https://mariadb.com/docs/server/server-usage/storage-engines/converting-tables-from-myisam-to-innodb)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
This guide outlines the benefits and process of migrating tables from MyISAM to InnoDB, highlighting key differences like transaction support and foreign keys.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/machine-learning-with-mindsdb" %}
[machine-learning-with-mindsdb](https://mariadb.com/docs/server/server-usage/storage-engines/machine-learning-with-mindsdb)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn how to integrate MindsDB with MariaDB to train and query machine learning models directly using standard SQL commands.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="storage-engines/legacy-storage-engines" %}
[legacy-storage-engines](https://mariadb.com/docs/server/server-usage/storage-engines/legacy-storage-engines)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore legacy storage engines in MariaDB Server. This section provides information on older engines, their historical context, and considerations for migration or compatibility.
{% endcolumn %}
{% endcolumns %}


---

# 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.md?ask=<question>
```

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.