principlesqlMinor
using Aria vs InnoDB vs MyISAM
Viewed 0 times
innodbariausingmyisam
Problem
I was wondering (if anyone knows) if Aria database is crash safe . I had some tables with MyISAM which were getting corrupted very often and switch them to InnoDB . However innodb is a bit slower and uses more space. Does anyone know if Aria is good alternative to MyISAM and does not corrupt the table ?
Solution
We have millions of tables deployed running ARIA in production. It is definitely a better choice over MyISAM as far as crashing and recovering from a crashed table. If you have high concurrent write neither are a option as they both only support table level locks. For tables with more write intensive operations stick with InnoDB, and with heavy write tables checkout TokuDB.
Context
StackExchange Database Administrators Q#62837, answer score: 5
Revisions (0)
No revisions yet.