Difference MyISAM and InnoDB Storage Engines Mysql
MyISAM InnoDB Default since version 3.23 Relatively newer Files storage: FRM: table definition, MYD: Actual Data MYI: Index File FRM: table definition .ibd file (concept of table space) or single huge .ibdataX No transation, Foreign key ACID Transactions, Foreign key, Rollback Low disk and memory utilisation Relatively high storage requirements (Almost 3 times disk space) Non clustered indexing Clustered indexing for Primary key Table level locking Row level locking Fulltext Indexes, Merge tables, Compressed tables. Not available GIS, RTREE indexes Not available Not avalable HASH lookups