> 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/loading-data-into-myrocks.md).

# Loading Data Into MyRocks

Being a write-optimized storage engine, MyRocks has special ways to load data much faster than normal INSERTs would.

See:

* the section about "Migrating from InnoDB to MyRocks in production" has some clues.
* [Data-Loading](https://github.com/facebook/mysql-5.6/wiki/Data-Loading) covers the topic in greater detail.

{% hint style="info" %}
When loading data with [rocksdb\_bulk\_load=1](/docs/server/server-usage/storage-engines/myrocks/myrocks-system-variables.md#rocksdb_bulk_load) and the data conflicts with the data already in the database, one may get non-trivial errors, for example:
{% endhint %}

```sql
ERROR 1105 (HY000): [./.rocksdb/test.t1_PRIMARY_2_0.bulk_load.tmp] bulk load error: 
  Invalid argument: External file requires flush
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}