MyISAM
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 |
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
© 2021 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/