[elktea]

as we are all discussing the pros and cons of various DBs, my favourite MySQL feature has to be the pluggable storage engines. Being able to support both InnoDB and RocksDB backed tables in the same database is wonderful. Just today I made use of the MyRocks storage engine's handy TTL [1] feature instead of a tedious delete & optimise scheduled job

[1]https://github.com/facebook/mysql-5.6/wiki/Time-to-Live-%28T...

[mst]

The MySQL storage engine API system is both a massive enabler or really cool stuff and a big restriction on how the optimiser can work.

Fascinating trade-off from which many things both good and bad spring.