MyISAM is default engine that Offers great performance for read heavy applications.
Create MyISAM Table:
CREATE TABLE table_name (id INT) ENGINE = MYISAM;
- MyISAM supports Full-text search indexes.
- We can use MyISAM, if the table is more static with lots of select and less update and delete.
- MyISAM does not support foreign keys hence we call MySQL with MyISAM is DBMS
- BLOB and TEXT columns can be indexed.
- NULL values are permitted in indexed columns.