Is there also a comparison with innodb with compressed tables (Storage size/speed/cpu load/mem usage )? (I assume at least some of the benefit in storage/performance may be due to the compression being on by default)
For MySQL yes on by default, for MariaDB no off by default. In this articles analysis compression was on indeed.
For the analysis comparison question, yes many articles but because InnoDB does sync compression and not async like TidesDB it’s not performant, but there is analysis on our blog, and against RocksDB as well at library and server level.