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...