You may find that InnoDB with row compression and 64KB pages compares relatively favourably, if that is an option for you.
On Tue, 15 Aug 2023, 11:44 pslawek83 via discuss, <[email protected]> wrote: > 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 > _______________________________________________ > discuss mailing list -- [email protected] > To unsubscribe send an email to [email protected] >
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
