MyISAM
From Wikipedia, the free encyclopedia
MyISAM | |
Developer: | MySQL AB |
---|---|
OS: | Cross-platform |
Use: | Database engine |
License: | GNU General Public License |
Website: | www.mysql.com |
MyISAM is the default storage engine for the MySQL relational database management system. It is based on the older ISAM code but has many useful extensions. In recent MySQL versions, the InnoDB engine has widely started to replace MyISAM due to its support for transactions, referential integrity constraints, and higher concurrency.
Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. A .frm file stores the table definition. The data file has a .MYD (MYData) extension. The index file has a .MYI (MYIndex) extension.