13 Nov
2020
13 Nov
'20
4:39 p.m.
If you are using the InnoDB storage engine, the explanation could be MDEV-12288. A fix is underway in MDEV-515, for speeding up inserts into empty tables or partitions. The recent MariaDB 10.5.8 release includes significant improvements to write performance (MDEV-23399 and MDEV-23855). If you do not mind some variance in the throughput and latency, you might want to configure the database so that InnoDB will only perform 'emergency flushing', and basically only perform sequential writes to ib_logfile0 most of the time. With best regards, Marko -- Marko Mäkelä, Lead Developer InnoDB MariaDB Corporation