HiveBrain v1.2.0
Get Started
← Back to all entries
principlesqlMinor

using Aria vs InnoDB vs MyISAM

Submitted by: @import:stackexchange-dba··
0
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.