SQL - INNODB vs MyISAM vs Aria

2
votes

I wonder if anyone can tell me about InnoDB vs MyISAM vs Aria (specifically Aria which is a little newer than the others)

  • Which one is faster in reads?
  • Which one is faster in writes?
  • Which one has transactions?
  • Which one is more secure and safe (I mean not having or having less data-loss)?

Thanks

1
mariadbinnodbmyisam
Since aria engine is not available in mysql, removed the mysql tag. - Shadow
Btw, is mariadb documentation enough on this matter? mariadb.com/resources/blog/storage-engine-choice-aria - Shadow
I added mysql because they are related to each other somehow. So anybody searches the questions with tag 'mysql' to answer, will find this question too. Thanks for the documentation. I had seen that but it didn't satisfy. I need a really detailed info about these engines. @Shadow - kodfire
Mariadb is a fork of mysql, therefore lot of questions and answers are cross applicable between the two products. However, this one is not. Regarding the info you are looking for: read / write - if you are not happy with the general statements in the documentation, then I'm sorry, but you need to do your own benchmark. Support transaction: that's easiy to look up in the documentation. So, the crash safety is the only real question there, since some configuration options may affect this. - Shadow
And for that see dba.stackexchange.com/questions/62837/… - Shadow

1 Answers

1
votes

Wrong questions. Instead ask "fast enough for may application", etc.

Don't even include MyISAM in the list; it is going away, does not have transactions, and can suffer data loss in crashes.

Pick InnoDB. Period. Full Stop.

Don't dwell on this question; move on to the next question.