maria-developers team mailing list archive
Mailing list archive
Re: how to speed up Maria record loading?
Hello Giuseppe, its pretty normal, cause maria engine have a log in the Data
file who make insert, update and replace statements slower than Myisam, its
secure th data enabling restore to any point in time to your database table.
check the filsize in the data directory and you will understand better
the FRM files both myisam and maria have the same size but
the maria data file is bigger than the myisam one and also
the myisam index file is bigger than the maria index file.
if you need increase this relationchip tri to use myisam to insert fast and
maria do insert reliable and fully recoverable (including deleted rows)
i supose it can help you.
On Tue, May 19, 2009 at 5:26 PM, Giuseppe Maxia <g.maxia@xxxxxxxxx> wrote:
> I am doing some tests with Maria. Out of the box, without any tuning,
> the load of records (with multiple record INSERT statements) is 5
> times slower than MyISAM, 4 times slower than InnoDB.
> What can I do to make the loading faster?
> The Data Charmer
> Mailing list: https://launchpad.net/~maria-developers
> Post to : maria-developers@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-developers
> More help : https://help.launchpad.net/ListHelp