4

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 ?

  • and when i write Aria database i mean Aria storage engine :) – VIPC Apr 9 '14 at 13:26
  • 2
    Even after 20 years of active development InnoDB is not 100% crash safe. Aria isn't widely used in production, so many bugs aren't discovered yet. – akuzminsky Apr 9 '14 at 14:42
  • From the Aria FAQ: Aria 1.0 was basically a crash-safe non-transactional version of MyISAM. Aria 1.5 added more concurrency (multiple inserter) and some optimizations. – Fahad Alduraibi Mar 16 '16 at 16:14
3

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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