The Ultimate Guide to High Availability with MariaDB

With the rocksdb plugin, does the SQL UPDATE leverage rocksdb's merge operator?

Currently I have my data in two normalised tables sharing a clustered primary key for joins.

I would like to merge these two tables into one to save disc space (by de-duplicating the hash keys) as well as avoid the join overhead when reading.

However, I would need to perform billions of UPDATE operations to fill in NULL placeholder values (as a once off per row).

My concern is that maybe MariaDB is going to perform a get + modify + put rather than leveraging rocksdb's merge operator.

Can someone tell me what happens under the hood? Does it use the merge operator for this kind of thing?

If the answer is no that is equally valuable information for me.

Kind Regards, AustEcon

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.