maria-discuss team mailing list archive

[Gordan Bobic <gordan.bobic@xxxxxxxxx>]

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@xxxxxxxxx> 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%20Powering%20the%20Real-Time%20Enterprise%20.mp4
>
>
>
> 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@xxxxxxxxx
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp