{"id":24467,"date":"2022-02-02T14:36:38","date_gmt":"2022-02-02T14:36:38","guid":{"rendered":"https:\/\/1-grid.com\/knowledge\/mysql-database-engines-myisam-vs-innodb\/"},"modified":"2023-04-19T07:51:58","modified_gmt":"2023-04-19T07:51:58","slug":"mysql-database-engines-myisam-vs-innodb","status":"publish","type":"ht_kb","link":"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/","title":{"rendered":"MySQL database engines \u2013 MyISAM vs Innodb"},"content":{"rendered":"<p><span style=\"color: #000000;\"><span lang=\"EN-US\" data-contrast=\"none\">If you are into web development then you no doubt work with databases a lot. \u202fMost of us create databases in\u00a0<\/span><span lang=\"EN-US\" data-contrast=\"none\">cPanel<\/span><span lang=\"EN-US\" data-contrast=\"none\">\u00a0without even thinking about what we need to use it for. As a result, we hardly give any thought to which database engine (or storage engine) to use for our database. \u202fA database engine is an underlying software that the DBMS uses to create, update, read or delete data from the MySQL database. The MySQL database management system (DBMS<\/span><span lang=\"EN-US\" data-contrast=\"none\">) \u202fhas<\/span><span lang=\"EN-US\" data-contrast=\"none\">\u00a014 different database engines that act as handlers for different table types.<\/span>\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\"><span lang=\"EN-US\" data-contrast=\"none\">MySQL storage engines include both those that handle transaction-safe tables and those that handle non-transaction-safe tables. \u202fWe are going to focus on the two most popular ones for our purposes:<\/span>\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\"><span lang=\"EN-US\" data-contrast=\"none\"><strong>MyISAM<\/strong><\/span><strong>\u00a0<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><span lang=\"EN-US\" data-contrast=\"none\">MyISAM<\/span><span lang=\"EN-US\" data-contrast=\"none\">\u202fmanages non-transactional tables. It provides high-speed storage and retrieval, as well as full-text searching capabilities.\u00a0<\/span><span lang=\"EN-US\" data-contrast=\"none\">MyISAM<\/span><span lang=\"EN-US\" data-contrast=\"none\">\u00a0is supported in all MySQL configurations and is the default storage engine unless you have configured MySQL to use a different one by default. Uses table-level locking, so only one write per table can be done at a time.<\/span>\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\"><span lang=\"EN-US\" data-contrast=\"none\">Features:<\/span>\u00a0<\/span><\/p>\n<ul>\n<li data-aria-level=\"1\" data-aria-posinset=\"1\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"1\"><span lang=\"EN-US\" style=\"color: #000000;\">MYISAM supports Table-level Locking<\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"2\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"1\"><span style=\"color: #000000;\"><span lang=\"EN-US\">MyISAM<\/span><span lang=\"EN-US\">\u00a0designed for need of speed<\/span><\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"1\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"1\"><span style=\"color: #000000;\"><span lang=\"EN-US\">MyISAM<\/span><span lang=\"EN-US\">\u00a0does not support foreign keys hence we call MySQL with MYISAM is DBMS<\/span><\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"2\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"1\"><span style=\"color: #000000;\"><span lang=\"EN-US\">MyISAM<\/span><span lang=\"EN-US\">\u00a0stores its tables, data and indexes in\u00a0<\/span><span lang=\"EN-US\">diskspace<\/span><span lang=\"EN-US\">\u00a0using separate three different files. (<\/span><span lang=\"EN-US\">tablename.FRM<\/span><span lang=\"EN-US\">,\u00a0<\/span><span lang=\"EN-US\">tablename.MYD<\/span><span lang=\"EN-US\">,\u00a0<\/span><span lang=\"EN-US\">tablename.MYI<\/span><span lang=\"EN-US\">)<\/span><\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"3\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"1\"><span lang=\"EN-US\" style=\"color: #000000;\">MYISAM does not supports transaction. You cannot commit and rollback with MYISAM. Once you issue a command it\u2019s done.<\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"4\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"1\"><span lang=\"EN-US\" style=\"color: #000000;\">MYISAM supports full-text search<\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"5\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"1\"><span style=\"color: #000000;\"><span lang=\"EN-US\">You can use\u00a0<\/span><span lang=\"EN-US\">MyISAM<\/span><span lang=\"EN-US\">, if the table is more static with lots of select and less update and delete.<\/span><\/span><\/li>\n<\/ul>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<p><span lang=\"EN-US\" style=\"color: #000000;\" data-contrast=\"none\"><strong>INNODB<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\"><span lang=\"EN-US\" data-contrast=\"none\">The\u202f<\/span><span lang=\"EN-US\" data-contrast=\"none\">InnoDB<\/span><span lang=\"EN-US\" data-contrast=\"none\">\u202fstorage engines provide transaction-safe tables. To maintain data integrity,\u00a0<\/span><span lang=\"EN-US\" data-contrast=\"none\">InnoDB<\/span><span lang=\"EN-US\" data-contrast=\"none\">\u00a0also supports FOREIGN KEY referential-integrity constraints. Supports row-level locking, which means that multiple writes can be supported per table at the same time. \u202fThis is also referred to as a transactional database engine.<\/span>\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<p><span lang=\"EN-US\" data-contrast=\"none\"><span style=\"color: #000000;\">Features<\/span>:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<ul>\n<li data-aria-level=\"1\" data-aria-posinset=\"1\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"2\"><span style=\"color: #000000;\"><span lang=\"EN-US\">InnoDB<\/span><span lang=\"EN-US\">\u00a0supports Row-level Locking<\/span><\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"2\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"2\"><span style=\"color: #000000;\"><span lang=\"EN-US\">InnoDB<\/span><span lang=\"EN-US\">\u00a0designed for maximum performance when processing high volume of data<\/span><\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"3\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"2\"><span style=\"color: #000000;\"><span lang=\"EN-US\">InnoDB<\/span><span lang=\"EN-US\">\u00a0support foreign keys hence we call MySQL with\u00a0<\/span><span lang=\"EN-US\">InnoDB<\/span><span lang=\"EN-US\">\u00a0is RDBMS<\/span><\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"4\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"2\"><span style=\"color: #000000;\"><span lang=\"EN-US\">InnoDB<\/span><span lang=\"EN-US\">\u00a0stores its tables and indexes in a tablespace<\/span><\/span><\/li>\n<li data-aria-level=\"1\" data-aria-posinset=\"5\" data-font=\"Symbol\" data-leveltext=\"\uf0b7\" data-listid=\"2\"><span style=\"color: #000000;\"><span lang=\"EN-US\">InnoDB<\/span><span lang=\"EN-US\">\u00a0supports transaction. You can commit and rollback with\u00a0<\/span><span lang=\"EN-US\">InnoDB<\/span><\/span><\/li>\n<\/ul>\n<p><span lang=\"EN-US\" data-contrast=\"none\">\u202f<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<table border=\"1\" data-tablelook=\"1184\" data-tablestyle=\"MsoNormalTable\">\n<tbody>\n<tr>\n<td><\/td>\n<td><span lang=\"EN-US\">My ISAM<\/span><\/td>\n<td><span lang=\"EN-US\">InnoDB<\/span><\/td>\n<\/tr>\n<tr>\n<td><span lang=\"EN-US\">Required full-text Search<\/span><\/td>\n<td><span lang=\"EN-US\">Yes<\/span><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span lang=\"EN-US\">Require Transactions<\/span><\/td>\n<td><\/td>\n<td><span lang=\"EN-US\">Yes<\/span><\/td>\n<\/tr>\n<tr>\n<td><span lang=\"EN-US\">Frequent \u2018Select\u2019 queries<\/span><\/td>\n<td><span lang=\"EN-US\">Yes<\/span><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span lang=\"EN-US\">Frequent \u2018Insert, Update, Delete\u2019 queries?<\/span><\/td>\n<td><\/td>\n<td><span lang=\"EN-US\">Yes<\/span><\/td>\n<\/tr>\n<tr>\n<td><span lang=\"EN-US\">Row Locking (multiprocessing on single table)<\/span><\/td>\n<td><\/td>\n<td><span lang=\"EN-US\">Yes<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>If you are into web development then you no doubt work with databases a lot. \u202fMost of us create databases in\u00a0cPanel\u00a0without even thinking about what we need to use it for. As a result, we hardly give any thought to which database engine (or storage engine) to use for our&#8230;<\/p>\n","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[1174],"ht-kb-tag":[270,361,520,661,662,1106],"class_list":["post-24467","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-hosting","ht_kb_tag-database","ht_kb_tag-engine","ht_kb_tag-innodb","ht_kb_tag-myisam","ht_kb_tag-mysql","ht_kb_tag-web-hosting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL database engines \u2013 MyISAM vs Innodb -<\/title>\n<meta name=\"description\" content=\"If you are into web development then you no doubt work with databases a lot. MySQL database engines \u2013 MyISAM vs Innodb\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL database engines \u2013 MyISAM vs Innodb -\" \/>\n<meta property=\"og:description\" content=\"If you are into web development then you no doubt work with databases a lot. MySQL database engines \u2013 MyISAM vs Innodb\" \/>\n<meta property=\"og:url\" content=\"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/\" \/>\n<meta property=\"og:site_name\" content=\"1-grid Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/1grid.co.za\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-19T07:51:58+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@1grid_hosting\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/\",\"name\":\"MySQL database engines \u2013 MyISAM vs Innodb -\",\"isPartOf\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\"},\"datePublished\":\"2022-02-02T14:36:38+00:00\",\"dateModified\":\"2023-04-19T07:51:58+00:00\",\"description\":\"If you are into web development then you no doubt work with databases a lot. MySQL database engines \u2013 MyISAM vs Innodb\",\"breadcrumb\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/1grid.co.za\/knowledge\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL database engines \u2013 MyISAM vs Innodb\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"contentUrl\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"width\":100,\"height\":100,\"caption\":\"1-Grid Domain Hosting Knowledge Base\"},\"image\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/1grid.co.za\/\",\"https:\/\/twitter.com\/1grid_hosting\",\"https:\/\/www.instagram.com\/1grid_hosting\/\",\"https:\/\/za.linkedin.com\/company\/1-grid\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL database engines \u2013 MyISAM vs Innodb -","description":"If you are into web development then you no doubt work with databases a lot. MySQL database engines \u2013 MyISAM vs Innodb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/","og_locale":"en_US","og_type":"article","og_title":"MySQL database engines \u2013 MyISAM vs Innodb -","og_description":"If you are into web development then you no doubt work with databases a lot. MySQL database engines \u2013 MyISAM vs Innodb","og_url":"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/","og_site_name":"1-grid Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/1grid.co.za\/","article_modified_time":"2023-04-19T07:51:58+00:00","twitter_card":"summary_large_image","twitter_site":"@1grid_hosting","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/","url":"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/","name":"MySQL database engines \u2013 MyISAM vs Innodb -","isPartOf":{"@id":"https:\/\/1grid.co.za\/knowledge\/#website"},"datePublished":"2022-02-02T14:36:38+00:00","dateModified":"2023-04-19T07:51:58+00:00","description":"If you are into web development then you no doubt work with databases a lot. MySQL database engines \u2013 MyISAM vs Innodb","breadcrumb":{"@id":"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/1grid.co.za\/knowledge\/mysql-database-engines-myisam-vs-innodb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/1grid.co.za\/knowledge\/"},{"@type":"ListItem","position":2,"name":"MySQL database engines \u2013 MyISAM vs Innodb"}]},{"@type":"WebSite","@id":"https:\/\/1grid.co.za\/knowledge\/#website","url":"https:\/\/1grid.co.za\/knowledge\/","name":"1-Grid Domain Hosting Knowledge Base","description":"","publisher":{"@id":"https:\/\/1grid.co.za\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/1grid.co.za\/knowledge\/#organization","name":"1-Grid Domain Hosting Knowledge Base","url":"https:\/\/1grid.co.za\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","contentUrl":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","width":100,"height":100,"caption":"1-Grid Domain Hosting Knowledge Base"},"image":{"@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/1grid.co.za\/","https:\/\/twitter.com\/1grid_hosting","https:\/\/www.instagram.com\/1grid_hosting\/","https:\/\/za.linkedin.com\/company\/1-grid"]}]}},"_links":{"self":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24467","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/comments?post=24467"}],"version-history":[{"count":2,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24467\/revisions"}],"predecessor-version":[{"id":31112,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24467\/revisions\/31112"}],"wp:attachment":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/media?parent=24467"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-category?post=24467"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-tag?post=24467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}