Given zero optimization in the original post, innodb_flush_log_at_trx_commit =
2 is almost the right fix, orders of magnitude faster on hard disk.
Add simple batching to this, and it is possible to add another order of
magnitude, or 2.
Write into several tables instead of 1, and that will improv
On 10/9/2019 3:15 AM, rhys.campb...@swisscom.com wrote:
>
> Might be worth having a look at TokuDB
> https://mariadb.com/kb/en/library/tokudb/
>
>
>
With TokuDB deprecated upstream and scheduled to be removed in a future
MariaDB version, I would not recommend it to anyone at this point.
Brian
__
I doubt that TokuDB will help with 100MB of data. It's been designed with
big datasets in mind and generally underperforms with small data.
The question is more how fast you can read and write to the table. At this
point even an in-memory database could be considered and maybe MariaDB
isn't even th
Might be worth having a look at TokuDB https://mariadb.com/kb/en/library/tokudb/
From: Maria-discuss
On
Behalf Of JCA
Sent: 07 October 2019 21:03
To: Kenneth Penza
Cc: Mailing-List mariadb
Subject: Re: [Maria-discuss] Performance tuning sought for MariaDB
On Mon, Oct 7, 2019 at 12:12 PM Ke
4 matches
Mail list logo
