4 ms·
I got sad when I read that TokuDB in Percona & MariaDB was being dropped :( Replaced TokuDB with MyRocks but it's totally different => now finally managed to h
by zepearl 5y ago
I got sad when I read that TokuDB in Percona & MariaDB was being dropped :(
Replaced TokuDB with MyRocks but it's totally different => now finally managed to have good ~constant performance insert&deletes (had to test & tune a lot), but "updates" remain a problem (they write a lot as I understand that any update always has to rewrite the entire row).
Using InnoDb instead of MyRocks is NOK for me (problems with deletes and related hole punching + bad that tables can never shrink when stuff gets deleted), I don't see other alternatives... .
I'm now experimenting with other DBs (right now with CockroachDB but it doesn't seem to be very stable, might then try as well Postgres but I'm scared by the lack of SQL-hints to cover worst case scenarios).
- tpetry 5y agoYou can enforce how to execute parts of your PostgreSQL with pg_hintplan. And it has more options than mysql‘s approach ;)
- zepearl 5y agoThanks a lot!!! I really mean it! This might change everything for me. I'm already using MariaDB+MyRocks and Clickhouse for some special/dedicated tasks, but I was really missing a good DB for normal/typical OLTP tasks. So far I used (as mentioned above) MariaDb+TokuDB (but the optimizer of MariaDB can be a bit crazy from time to time), had multiple times during the past months thoughts about PostgreSQL but the lack of hints always made me take a step back from it => this addon seems to be exactly what I wished for. Looks like that my weekend will be all about PG - the last time that I set it up its version number had a single digit => cannot remember anything anymore... . Again, thanks for the hint :P