[Labs-l] MariaDB, MyISAM, and ARIA

[Sean Pringle]

We noticed a number of MyISAM tables during the MariaDB 10 migration. No
doubt some are intentional for FULLTEXT indexes, and maybe some are legacy
or just unintentional.

The ARIA engine is an update to MyISAM that maintains the basics -- low
overhead table-level locking, fast reads, fulltext indexes -- but adds a
log for crash recovery and a buffer pool for caching both indexes and data,
more like InnoDB.

So, folks still using MyISAM please consider:

ALTER TABLE <name> ENGINE=ARIA;

https://mariadb.com/kb/en/mariadb/mariadb-documentation/mariadb-storage-engines/aria/aria-storage-engine/

BR
Sean

-- 
DBA @ WMF
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.wikimedia.org/pipermail/labs-l/attachments/20140725/378ee504/attachment.html>