[HeresJohnny]

The upcoming releases of MariaDB will feature a stable version of a new storage engine, MyRocks (RocksDB). MyRocks is superior to InnoDB in every way: Better compression, fewer writes and flash-storage optimized.
I would like to request that MyRocks be an optional choice for generating a new MySQL database through Kodi.
More details can be found here: https://mariadb.com/kb/en/library/myrocks/

A few changes to db creation would be necessary so MyRocks works at optimum performance.

1. Change the storage engine to MyRocks (duh)
2. Collation
MyRocks uses case sensitive keys. Therefore the default collation needs to be "utf-8_bin"

[Saner]

Out of interest in general what's the memory usage like Vs InnoDB?

[smitchell6879]

Myrocks my save space but from what I am reading it could cause slower read speeds, also it has to run on only a 64 bit system.

Also with such high compression would require more memory to run.

Will it actually be worth it? Kodi DB may have a several thousand rows for a large database and I have seen read and write increases from sqlite3 to MySQL but from my understanding myrocks has been main compared with usage of millions of rows in a table.... And still the time read times are in the seconds for both.

Or maybe what o read was a bad source?