Hey,

I have been using BDB and LevelDB and other KV embedded DB as an improvement for SquidGuard.

I have seen the next MDEV:

https://jira.mariadb.org/browse/MDEV-3841

And was wondering what is the most recommended way to store a simple KV list in MaraiDB these days.

Currently MariaDB works fine for me but when I am comparing the performance of BDB to MariaDB even if am iterating
a full DB file 6 times to find out if 6 different Keys are present it seems like a simple embedded DB is faster then MariaDB.

I am not stating a fact since I don’t have the metrics but this is what it seems like.

The DB is mainly for READ so I was thinking about an option to use a master and READ ONLY slaves to speedup the DB.

The DB contains about 80 million rows so it’s not that big since the only thing I need is the KEY to match a category.

Currently I am using a simple InnoDB table and the buffers are maximized to the maximum that the machine can offer.

Thanks,

Eliezer

----

Eliezer Croitoru

NgTech, Tech Support

Mobile: +972-5-28704261

Email: ngtech1ltd@gmail.com

Web: https://ngtech.co.il/

My-Tube: https://tube.ngtech.co.il/