MySQL MyISAM Storage Engine

MyISAM is default engine that Offers great performance for read heavy applications.

Create MyISAM Table:

CREATE TABLE table_name (id INT) ENGINE = MYISAM; 

MyISAM Characteristics:

  1. MyISAM supports Full-text search indexes.
  2. We can use MyISAM, if the table is more static with lots of select and less update and delete.
  3. MyISAM does not support foreign keys hence we call MySQL with MyISAM is DBMS
  4. BLOB and TEXT columns can be indexed.
  5. NULL values are permitted in indexed columns.
Tags