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
_______________________________________________
Labs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/labs-l

Reply via email to