[Maria-developers] how to speed up Maria record loading?
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/
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) table. i supose it can help you. best regards. Michel Souza On Tue, May 19, 2009 at 5:26 PM, Giuseppe Maxia <g.maxia@gmail.com> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Atenciosamente Michel Souza
On Tue, May 19, 2009 at 1:26 PM, Giuseppe Maxia <g.maxia@gmail.com> 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.
I tested Maria with sysbench and it was many times slower than other engines. -- Mark Callaghan mdcallag@gmail.com
Hi!
"MARK" == MARK CALLAGHAN <mdcallag@gmail.com> writes:
MARK> On Tue, May 19, 2009 at 1:26 PM, Giuseppe Maxia <g.maxia@gmail.com> 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.
MARK> I tested Maria with sysbench and it was many times slower than other engines. Yes, if you are using transactions=1 and short records or a lot of updates/deletes it's slower than other engines because we are still using table locking, we don't have group commit and we need a better implementation of the key cache (less locking). When running sql-bench (single threaded) we are faster than InnoDB on many of the tests, so at least some things are done right. As you probably know, Maria 1.5 is about correctness, not speed. I belive that it's critical to first get things to work correctly before you starting to optimize. We are working on fixing many of the issues in Maria 2.0; Sanja pushed group commit some time ago in MariaDB 5.2 and this should improve stuff a bit, but we know there is a long way to go before we are in par with InnoDB. We will get a better picture as soon as we have the transactional part in as then we can get rid of the table locking problem. Regards, Monty
On Sun, Jun 7, 2009 at 1:42 AM, Michael Widenius<monty@askmonty.org> wrote:
Hi!
"MARK" == MARK CALLAGHAN <mdcallag@gmail.com> writes:
MARK> On Tue, May 19, 2009 at 1:26 PM, Giuseppe Maxia <g.maxia@gmail.com> 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.
MARK> I tested Maria with sysbench and it was many times slower than other engines.
Yes, if you are using transactions=1 and short records or a lot of updates/deletes it's slower than other engines because we are still using table locking, we don't have group commit and we need a better implementation of the key cache (less locking).
When running sql-bench (single threaded) we are faster than InnoDB on many of the tests, so at least some things are done right.
As you probably know, Maria 1.5 is about correctness, not speed. I belive that it's critical to first get things to work correctly before you starting to optimize.
We are working on fixing many of the issues in Maria 2.0; Sanja pushed group commit some time ago in MariaDB 5.2 and this should improve stuff a bit, but we know there is a long way to go before we are in par with InnoDB. We will get a better picture as soon as we have the transactional part in as then we can get rid of the table locking problem.
Regards, Monty
Are there any useful (to maria developers) performance tests we can run? If we limit all tests to 1 user (no concurrency) are the results useful? -- Mark Callaghan mdcallag@gmail.com
participants (4)
-
Giuseppe Maxia -
MARK CALLAGHAN -
Michael Widenius -
Michel Souza