MyISAM was the default storage engine from MySQL 3.23 until it was replaced by InnoDB in MariaDB and MySQL 5.5. It's a light, non-transactional engine with great performance, is easy to copy between systems and has a small data footprint.
You're encouraged to rather use the Aria storage engine for new applications, which has even better performance and the goal of being crash-safe.
Until MariaDB 10.4, system tables used the MyISAM storage engine.
Title | Description |
---|---|
MyISAM Overview | Light, non-transactional storage engine |
MyISAM System Variables | MyISAM system variables. |
MyISAM Storage Formats | The MyISAM storage engine supports three different table storage formats |
MyISAM Clients and Utilities | Clients and utilities for working with MyISAM tables |
MyISAM Index Storage Space | Regular MyISAM tables make use of B-tree indexes |
MyISAM Log | Records all changes to MyISAM tables |
Concurrent Inserts | Under some circumstances, MyISAM allows INSERTs and SELECTs to be executed concurrently |
Segmented Key Cache | Collection of structures for regular MyISAM key caches |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/myisam-storage-engine/