{"id":15,"date":"2009-01-04T09:55:50","date_gmt":"2009-01-04T09:55:50","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=15"},"modified":"2014-06-24T18:55:51","modified_gmt":"2014-06-24T18:55:51","slug":"difference-myisam-and-innodb-storage-engines-mysql","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/difference-myisam-and-innodb-storage-engines-mysql","title":{"rendered":"Difference MyISAM and InnoDB Storage Engines Mysql"},"content":{"rendered":"\n\n\n\n\n\n\n\n\n\n\n\n
\n

MyISAM<\/strong><\/p>\n<\/td>\n

\n

InnoDB<\/strong><\/p>\n<\/td>\n<\/tr>\n

Default since version 3.23<\/td>\n\n

Relatively newer<\/p>\n<\/td>\n<\/tr>\n

Files storage:<\/p>\n

FRM: table definition,<\/p>\n

MYD: Actual Data<\/p>\n

MYI: Index File<\/td>\n

\n

FRM: table definition<\/p>\n

.ibd file (concept of table space) or single huge .ibdataX<\/p>\n<\/td>\n<\/tr>\n

No transation, Foreign key<\/td>\n\n

ACID Transactions, Foreign key, Rollback<\/p>\n<\/td>\n<\/tr>\n

Low disk and memory utilisation<\/td>\n\n

Relatively high storage requirements (Almost 3 times disk space)<\/p>\n<\/td>\n<\/tr>\n

Non clustered indexing<\/td>\n\n

Clustered indexing for Primary key<\/p>\n<\/td>\n<\/tr>\n

Table level locking<\/td>\n\n

Row level locking<\/p>\n<\/td>\n<\/tr>\n

Fulltext Indexes, Merge tables, Compressed tables.<\/td>\n\n

Not available<\/p>\n<\/td>\n<\/tr>\n

GIS, RTREE indexes<\/td>\n\n

Not available<\/p>\n<\/td>\n<\/tr>\n

Not avalable<\/td>\n\n

HASH lookups<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"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…\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,377],"tags":[261,427,107],"class_list":["post-15","post","type-post","status-publish","format-standard","category-mysql","category-mysql-articles","tag-difference-myisam-and-innodb","tag-mysql","tag-storage-engine"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t