Hi! I confirm I was also my choice, the migration from TokuDB to InnoDB with row compression is a really good option.
BR, > Le 15 août 2023 à 12:52, Gordan Bobic via discuss <[email protected]> > a écrit : > > 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] _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
