maria-discuss team mailing list archive

[NgTech LTD <ngtech1ltd@xxxxxxxxx>]

Thanks!
I assumed so and was wondering how exactly Oracle claimed that the
in-memory DB makes the speed fast compared between in memory to on disk and
without indexes.
What the demo shows is that a DB in memory can be fast and so fast that you
wouldn't need indexes if and only if I understood right.

Can you abd others please try to verify my assumption and clear out my
doubts?

Thanks,
Eliezer

בתאריך יום א׳, 22 במאי 2022, 15:07, מאת 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
>