Hi, sharing a bit of experience of working with rocksdb for 5y+ now in a mixed InnoDB / RocksDB setup. Drawback of rocksdb are lacking foreign keys and a complex configuration with many parameters (defaults in MariaDB seem quite reasonable though), also there are limitations regarding well-performing charsets and DDL changes can be more complicated than on Innodb due to the max row lock limit rocksdb applies. Advantages are much faster inserts and data loading and much better compression by using zstd. We are working with a page size of 64k for rocksdb and it works well. *- Is it (will it be?) possible to have something like single-file-per-table (or single dir per table?)* not possible *- 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?)* yes, it is a potential danger *- Will partitioning the table have performance benefits like with other engines? Can I do instant TRUNCATE PARTITION for easy data retention?* not much experience with partitioned tables but they are supported Good luck! Am Di., 15. Aug. 2023 um 13:29 Uhr schrieb jocelyn fournier via discuss < discuss@lists.mariadb.org>:
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 < discuss@lists.mariadb.org> 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, < discuss@lists.mariadb.org> 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 -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org _______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
_______________________________________________ discuss mailing list -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org