{"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":"<table border=\"0\" cellpadding=\"0\" width=\"100%\">\n<tbody>\n<tr>\n<td width=\"76\">\n<p align=\"center\"><strong>MyISAM<\/strong><\/p>\n<\/td>\n<td width=\"186\">\n<p align=\"right\"><strong>InnoDB<\/strong><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>Default since version 3.23<\/td>\n<td>\n<p align=\"right\">Relatively newer<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>Files storage:<\/p>\n<p>FRM: table definition,<\/p>\n<p>MYD: Actual Data<\/p>\n<p>MYI: Index File<\/td>\n<td>\n<p align=\"right\">FRM: table definition<\/p>\n<p align=\"right\">.ibd file (concept of table space) or   single huge .ibdataX<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>No transation, Foreign key<\/td>\n<td>\n<p align=\"right\">ACID Transactions,   Foreign key, Rollback<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>Low disk and memory utilisation<\/td>\n<td>\n<p align=\"right\">Relatively high   storage requirements (Almost 3 times disk space)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>Non clustered indexing<\/td>\n<td>\n<p align=\"right\">Clustered indexing   for Primary key<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>Table level locking<\/td>\n<td>\n<p align=\"right\">Row level locking<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>Fulltext Indexes, Merge tables, Compressed tables.<\/td>\n<td>\n<p align=\"right\">Not available<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>GIS, RTREE indexes<\/td>\n<td>\n<p align=\"right\">Not available<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>Not avalable<\/td>\n<td>\n<p align=\"right\">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&hellip;\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":{"0":"post-15","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","7":"category-mysql-articles","8":"tag-difference-myisam-and-innodb","9":"tag-mysql","10":"tag-storage-engine"},"aioseo_notices":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/15","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":1,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/15\/revisions"}],"predecessor-version":[{"id":1612,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/15\/revisions\/1612"}],"wp:attachment":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/media?parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/categories?post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/tags?post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}