Hi Guys, i'm looking for tokudb replacement and i'm again thinking about rocksdb. Is it mature enough to be used as an engine for statistical tables (several billions rows, around 2TB in size?).
- Is it (will it be?) possible to have something like single-file-per-table (or single dir per table?)
- Is it shared per all tables, so all tables are still using single set of files (can single crashed table/row lead to all tables being unusable?)
- Will partitioning the table have performance benefits like with other engines? Can I do instant TRUNCATE PARTITION for easy data retention?
Thanks