← Back to team overview

maria-developers team 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.

best regards.

Michel Souza

On Tue, May 19, 2009 at 5:26 PM, Giuseppe Maxia <g.maxia@xxxxxxxxx> wrote:

> Hi,
> 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?
> Thanks
> Giuseppe
> --
> The Data Charmer
> http://datacharmer.org/
> _______________________________________________
> 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


Michel Souza