Tuesday, January 29, 2008

Maria is here

Maria is here. Despite the disclaimers, the performance is not too bad. I have but one suggestion, the engine comment should be changed. The following query was actually much faster on Maria than on other storage engines:
  • select count(*) from foo where d > 0

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+
| MARIA | YES | Traditional transactional MySQL tables | YES | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+

5 comments:

  1. emphasis on traditional and transactional :)

    ReplyDelete
  2. Hey Mark,interesting! was not aware of this project. Any benchmark available yet?

    ReplyDelete
  3. Monty has warned that their primary concern is correctness, so I don't think there will be many benchmarks run against it. But performance is very good for an early release. See
    http://monty-says.blogspot.com/2008/01/maria-engine-is-released.html

    ReplyDelete
  4. Ok, I'm going to change the engine's description in SHOW ENGINES to be "Crash-safe tables with MyISAM heritage".

    ReplyDelete
  5. ah right! the transactional 'MyISAM' engine... glad it has a name :)

    ReplyDelete

 
Creative Commons License
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.