Loading Data Into MyRocks
You are viewing an old version of this article. View
the current version here.
Being a write-optimized storage engine, MyRocks has special ways to load data much faster than normal INSERTs would.
See
- http://myrocks.io/docs/getting-started/; the section about "Migrating from InnoDB to MyRocks in production" has some clues.
- https://github.com/facebook/mysql-5.6/wiki/Data-Loading covers the topic in greater detail.
Note
When one loads data with @rocksdb_bulk_load=1 and the data conflicts with the data already in the database, one may get non-trivial errors like so:
ERROR 1105 (HY000): [./.rocksdb/test.t1_PRIMARY_2_0.bulk_load.tmp] bulk load error: Invalid argument: External file requires flush
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
