If your buffer pool is big enough to store the entire data set, then there is no need to use any kind of in-memory database engine, the buffer pool will end up caching everything (once it is warmed up). For faster writes if you don't particularly care about ACID compliance, you can disable InnoDB transaction log flushing by setting innodb_flush_log_at_trx_commit=0. You will lose transaction if there is a dirty shutdown, but it will largely bypass any disk write I/O bottleneck. Over and above that, the usual performance tuning applies - make sure your queries are well written and well indexed. In most cases that makes far more difference than keeping all of your data in memory. On Sun, May 22, 2022 at 3:01 PM Eliezer Croitoru <ngtech1ltd@gmail.com> wrote:
I have seen the next blog post which had a video at 2014:
https://blogs.oracle.com/pcoe/post/the-future-of-the-database-begins
The demo video was removed from YouTube for some reason but I had a copy of it at:
https://cloud1.ngtech.co.il/static/oracle/Oracle%20Database%20In-Memory%20Po...
I am not a MariaDB or MySQL or DB in general expert and was wondering if there is something these days in MariaDB that can be used in comparison to what Oracle DB demo shows?
I have used LevelDB as a backend in a customized DB and it worked very very fast and it is great. With batches it works even faster but in general it works faster then standard MariaDB setups I have implemented.
So what are the options?
I have millions of values and I would like to be able to insert and select as fast as possible on a single DB Server.
Currently I am using a Caching tier with a specific TTL to lower the stress off the DB, but, is I possible to make the DB Faster like maybe with some writeback (leaving aside fault tolerance for speed).
Thanks,
Eliezer
----
Eliezer Croitoru
NgTech, Tech Support
Mobile: +972-5-28704261
Email: ngtech1ltd@gmail.com
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp