MyISAM

MyISAM is a storage engine designed for MySQL relational databases.

It is designed for fast read operations, full-text indexing and low resource consumption. It does not support transactions or foreign key constraints, making it suitable for read-intensive applications, but less ideal for those requiring high data integrity and ACID compliance.

MyISAM uses table-level locking. In other words, any write operation in MyISAM locks the entire table.