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.
There seems to be something strange happening on debian 9 in virtualized enviroments, when using D9 with cfq I/O scheduler - it's easily able to saturate 3 CPU cores with I/O wait even on Samsung 950 PRO when doing nothing with very low IO throughput. Switching to noop or deadline scheduler helps and I/O wait drops to be almost on par with other engines (2-7%).
Best results are seen with Debian10, which defaults to mq-deadline scheduler. Then I/O wait becomes 0% and throughput increases as well. Not sure why cfq is having such issues with only this engine but something to consider when using on older linux distros i guess...
I attach an example of a my.ini file, based on rules of thumb, for a laptop with the following specifications:
https://raw.githubusercontent.com/jtelleria/my.ini/master/RocksDB%20my.ini
And a Percona PDF Presentation, which gives Optimal RocksDB Engine Variables Values under different usage scenarios:
https://github.com/jtelleria/my.ini/raw/master/Percona%20RocksDB%20Optimal%20Options%20SSD.pdf
The package mariadb-plugin-rocksdb is not available in Ubuntu 16.04 LTS. Any solution for this?
The latest release does have packages for Ubuntu 16.04: http://ftp.osuosl.org/pub/mariadb//mariadb-10.3.5/repo/ubuntu/dists/xenial/main/binary-amd64/Packages
There are no binaries for 32-bit platform, this is intentional. If I recall correctly, this was due to some issue with 32-bit RocksDB build.