Loading Data Into MyRocks
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, for example:
ERROR 1105 (HY000): [./.rocksdb/test.t1_PRIMARY_2_0.bulk_load.tmp] bulk load error: Invalid argument: External file requires flush
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.
