Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

If Aria storage engine (previously called Maria) is the "new" MyISAM, which supports transaction and automatic crash recovery:

  • Why still use MyISAM ?
  • Should changing storage engine from MyISAM to Aria be a problem? (lose index or something)
share|improve this question
2  
Hi jcho360, I'm not sure what your question is here. Do you have a specific question about using either Maria or MyISAM? Otherwise this seems just to be an opinion question, which is frowned upon. –  Derek Downey May 11 '12 at 18:36
    
@DTest I thinks that an easier way to ask could be, Maria Vs MyIsam. or why should we use MyIsam if Maria suppose to be better? –  jcho360 May 11 '12 at 18:41
1  
Maria is a complete DBMS, MyISAM is a storage engine for MySQL. I don't see how you could change one for the other –  a_horse_with_no_name May 11 '12 at 19:26
    
@a_horse_with_no_name please take a look to this link: en.wikipedia.org/wiki/Aria_%28storage_engine%29 –  jcho360 May 11 '12 at 19:30
    
@a_horse_with_no_name: jcho360 is right. Maria is the engine, MariaDB is the DBMS (where Maria is avaialble). –  ypercube May 11 '12 at 19:32
show 5 more comments

1 Answer

up vote 3 down vote accepted

It is very interesting this question would come up because a similar question was asked back in January 2011 ( When is the right time to use MariaDB instead of MySQL, and Why? ). Giving thought to that 16-month-old question and how I answered it in April 2011, here are my answers to your immediate questions:

Why still using MyISAM ?

MyISAM still has features that are unique and useful for small datasets and read slaves in HA setups

  • Deadlocking is impossible in low-write, heavy-read environments
  • Converting to Fixed Row Format creates bigger tables but increases query performance in terms of

  • Full Faith and Confidence

    • InnoDB has become the de facto standard of Transactional Storage Engines for MySQL. XtraDB is being accepted and used as well among the Percona Server community. Full faith and confidence seems to rest with InnoDB over XtraDB as present. This could easily change over time as more recognize XtraDB's superior features.
    • The same equally applies to MyISAM vs Aria. Full faith and confidence currently rests with MyISAM. An example of those who do not have Full faith and confidence are Drizzle users (Drizzle have abandoned MyISAM as an Optional Storage Engine and relegated it to temp table use only)

To changes storage engine from MyISAM to Maria should it be a problem? (lose index or something)

If you mysqldump the data and the schema into two separate files, you can always import data into table with either the MyISAM or Aria storage engines. Just keep around the data only mysqldump to be sure.

share|improve this answer
    
thanks a lot, I was reading a book from 2009 and it said, Maria is the future MyIsam (well now Maria = Aria) and still in production. –  jcho360 May 14 '12 at 15:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.