Comments - Getting Started with MyRocks
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.
Recommended specifications for my.ini file when using RocksDB in a regular laptop are:
[mysqld]
skip-innodb
default_storage_engine=rocksdb
rocksdb_block_cache_size = 1G # Equivalent to: "innodb_buffer_pool_size"
rocksdb_max_row_locks=1048576
rocksdb_bulk_load_size=100000
rocksdb_commit_in_the_middle=1
And for checking Servers "rocksdb" statistics, run the following SQL code:
SHOW ENGINE ROCKSDB STATUS;