{"id":686,"date":"2021-07-07T06:23:29","date_gmt":"2021-07-07T11:23:29","guid":{"rendered":"https:\/\/www.knownhost.com\/kb\/?p=686"},"modified":"2021-11-16T07:02:56","modified_gmt":"2021-11-16T13:02:56","slug":"what-is-the-difference-between-myisam-and-innodb","status":"publish","type":"post","link":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/","title":{"rendered":"What is the difference between MyISAM and InnoDB?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #212121;color:#212121\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #212121;color:#212121\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#general_comparison\" >General Comparison<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#when_to_use_myisam_instead_of_innodb\" >When to use MyISAM instead of InnoDB<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#when_to_use_innodb_instead_of_myisam\" >When to use InnoDB instead of MyISAM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#when_to_use_neither_myisam_nor_innodb\" >When to use neither MyISAM nor InnoDB<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#how_to_change_a_tables_storage_engine\" >How to Change a Table&#8217;s Storage Engine<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#more_technical_explanation\" >More Technical Explanation<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#similarities\" >Similarities<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#myisam\" >MyISAM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#innodb\" >InnoDB<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#memory\" >MEMORY<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#summary\" >Summary<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>When you create a table in MySQL, or MariaDB,&nbsp;you can choose a&nbsp;<em>storage engine<\/em>. The storage engine is the way the table data is stored in files or sometimes memory.&nbsp;There exist several different storage engines, but the most commonly used ones are MyISAM and InnoDB, each of which are the default storage engine in different MySQL versions. If you do not specify a storage engine when creating a table, the default engine for your MySQL version will be used. In MySQL versions earlier than 5.5.5, MyISAM was default, but in versions 5.5.5 and later, InnoDB is the default.&nbsp;In most cases, MyISAM is recommended, but there are some cases where for a particular table InnoDB might be recommended instead.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"general_comparison\"><\/span>General Comparison<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here is a very brief overview of common types of situations where one of these two engines might be better to use than the other.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"when_to_use_myisam_instead_of_innodb\"><\/span>When to use MyISAM instead of InnoDB<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>In general, if a MyISAM table has a problem, the problem will be limited to that table, rather than affecting the functionality of other tables or databases as can sometimes happen when an InnoDB table has a problem. For this reason, MyISAM is recommended whenever possible in servers with multiple sites.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"when_to_use_innodb_instead_of_myisam\"><\/span>When to use InnoDB instead of MyISAM<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Because InnoDB makes more extensive use of row-level locks instead of table-level locks, using InnoDB for specific tables that get written to frequently can help reduce the amount of time waiting for locks. This can in turn substantially reduce memory usage in the server in these specific cases.<\/p>\n\n\n\n<p>In part because databases using InnoDB tables cannot be individually restored as part of a&nbsp;<a href=\"https:\/\/www.knownhost.com\/kb\/information-about-backups-and-restorations\/\">Partial VPS Restore<\/a>, and in part because some types of issues with InnoDB tables can cause data loss in other InnoDB tables, it is even more important than usual to make sure&nbsp;<a href=\"https:\/\/www.knownhost.com\/kb\/information-about-backups-and-restorations\/\">automatic backups<\/a>&nbsp;are enabled and successfully being created, if any of the sites are using InnoDB.<\/p>\n\n\n\n<p>In part because issues with InnoDB tables can affect access to other databases, if a site has need for enough concurrent table writes to justify using InnoDB, that site might be busy enough to start considering putting it on its own server. If the site is not yet big enough for its own server, it might be better instead to recode the site to require less concurrency of table writes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"when_to_use_neither_myisam_nor_innodb\"><\/span>When to use neither MyISAM nor InnoDB<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Most types of sites store session information as files, but if it must be stored in a database table, MEMORY is likely a better choice of engine than either MyISAM or InnoDB.<\/li><li>Similarly, though it is even more rare, certain kinds of site cache data if being stored in a database table should probably use the MEMORY storage engine.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_change_a_tables_storage_engine\"><\/span>How to Change a Table&#8217;s Storage Engine<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If you already have a table created that needs to be changed to a different engine, this can be done with an&nbsp;<code>ALTER TABLE<\/code>&nbsp;statement, like this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  mysql&gt; ALTER TABLE dbname.tablename ENGINE = enginename;<\/code><\/pre>\n\n\n\n<p>If you prefer to use phpMyAdmin, you would need to select the table:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"541\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable-1024x541.png\" alt=\"\" class=\"wp-image-687\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable-1024x541.png 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable-300x159.png 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable-768x406.png 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>click the &#8220;Operations&#8221; tab:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"540\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselectoperations-1024x540.png\" alt=\"\" class=\"wp-image-688\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselectoperations-1024x540.png 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselectoperations-300x158.png 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselectoperations-768x405.png 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselectoperations.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>select the desired engine in the &#8220;Storage Engine&#8221; dropdown box:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"540\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminchooseengine-1024x540.png\" alt=\"\" class=\"wp-image-689\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminchooseengine-1024x540.png 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminchooseengine-300x158.png 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminchooseengine-768x405.png 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminchooseengine.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>and click the &#8220;Go&#8221; button:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"541\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminclickgo-1024x541.png\" alt=\"\" class=\"wp-image-690\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminclickgo-1024x541.png 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminclickgo-300x159.png 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminclickgo-768x406.png 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminclickgo.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Congratulations! You have now changed the storage engine of the table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"more_technical_explanation\"><\/span>More Technical Explanation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here is a little bit of more detailed information about the storage engines, to help explain&nbsp;<em>why<\/em>&nbsp;different ones are better for different purposes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"similarities\"><\/span>Similarities<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Any database table, regardless of which storage engine it uses, will have a&nbsp;<code>.frm<\/code>&nbsp;file. This file&#8217;s name will be the table name followed by this file extension. This file contains table metadata, such as the table definition. Depending on the table&#8217;s engine and sometimes the way the engine is configured,&nbsp;there may or may not be other files associated with the table.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"myisam\"><\/span>MyISAM<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>A MyISAM table has a total of three files. In addition to the&nbsp;<code>.frm<\/code>&nbsp;file that all tables have, there is also a&nbsp;<code>.MYD<\/code>&nbsp;file containing the table data, and a&nbsp;<code>.MYI<\/code>&nbsp;file containing the indexes.<\/li><li>Because MyISAM stores all table information directly within that table&#8217;s three files, a single crashed table will not directly interfere with the functionality of other tables.<\/li><li>Because MyISAM stores all table information directly within that table&#8217;s three files, it is possible if needed to restore a single database from a Partial VPS Restore, if&nbsp;<em>all<\/em>&nbsp;tables in that database are using MyISAM.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"innodb\"><\/span>InnoDB<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>An InnoDB table will have one or two files, depending on if&nbsp;<code>innodb_file_per_table<\/code>&nbsp;is enabled.<ul><li>Whether it is enabled or not, the table will still have an&nbsp;<code>.frm<\/code>&nbsp;file, containing the table definition, as all tables do.<\/li><li>If it is enabled, there will also be an&nbsp;<code>.ibd<\/code>&nbsp;file, containing table data and indexes.<\/li><li>If it is not enabled, the table data and indexes for all tables will instead be stored in the system tablespace.<\/li><li>Due to the change buffer, even if&nbsp;<code>innodb_file_per_table<\/code>&nbsp;is enabled, recent changes will not yet be written to the table files. This is why databases containing InnoDB tables cannot be individually restored as part of a Partial VPS Restore, which in turn is part of why it is even more important than usual to have automatic backups enabled when InnoDB tables exist.<\/li><\/ul><\/li><li>InnoDB has an automatic crash recovery process. When mysql stops unexpectedly, InnoDB has certain checks that run at mysql startup. In most cases, this crash recovery process will successfully finalize changes committed before the crash and undo changes that were in progress but not committed. However, sometimes this process fails, especially if InnoDB is being particularly active at a time when MySQL is shutdown particularly uncleanly. When this happens, MySQL will be completely unable to start, and no databases will be accessible. For this reason, it is strongly recommended that if a site needs enough table write concurrency to justify using InnoDB, that that site be on its own server, to help prevent it from contributing to other sites being down.<\/li><li>Additionally, if InnoDB crashes and is unable to recover automatically, it is possible for some of the InnoDB tables to be corrupted in a non-repairable way. This is another reason it is particularly important to have automatic backups enabled for any account using InnoDB tables.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"memory\"><\/span>MEMORY<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>A MEMORY table will&nbsp;<em>only<\/em>&nbsp;have one file: the&nbsp;<code>.frm<\/code>&nbsp;file itself, containing the table definition. The table data is stored&nbsp;<em>only<\/em>&nbsp;in memory.<\/li><li>If mysql is restarted, data in a MEMORY table is lost. This might not be a problem if it is ephemeral data that is not needed for very long.<\/li><li>Unlike internal temporary tables, which can be written to disk if they exceed a configured size,&nbsp;a MEMORY table will never be written to disk. A MEMORY table cannot exceed the size indicated by&nbsp;<code>max_heap_table_size<\/code>. If the table is filling up, you will need to add more places in the site scripts where the table is emptied.<\/li><li>MEMORY tables, like MyISAM tables, use table-level locks for certain operations, but because the changes are not written to the disk, this is still usually much faster than the same operations in a MyISAM table.<\/li><li>Because data from MEMORY tables is lost when mysql is restarted, corrupted MEMORY table data cannot prevent mysql from starting.<\/li><li>MEMORY tables should&nbsp;<em>only<\/em>&nbsp;be used for ephemeral, non-persistant data, that is only needed for short periods of time.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"summary\"><\/span>Summary<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>If a table is composed&nbsp;<em>entirely<\/em>&nbsp;of ephemeral data that does not need to be kept long, it may be better to store it in MEMORY tables, to combine speed with compartmentalization.<\/p>\n\n\n\n<p>If a table is not often written to,&nbsp;especially on a server with many sites, it is likely safest to store it as MyISAM, to better compartmentalize issues in case of the rare instances where InnoDB crash recovery would fail.<\/p>\n\n\n\n<p>If a table is frequently written to and contains non-ephemeral data, then the table should be stored as InnoDB to prevent lock competition from using up too many server resources. If using InnoDB for a table, it is even more important than usual to make sure that cPanel account has\u00a0<a href=\"https:\/\/docs.cpanel.net\/whm\/backup\/backup-configuration\/\">automatic backups<\/a>\u00a0enabled. If a site is busy enough to need InnoDB tables, it may be time to consider putting the site on its own server, to help prevent an InnoDB failure from affecting other sites.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you create a table in MySQL, or MariaDB,&nbsp;you can choose a&nbsp;storage engine. The storage engine is the way the table data is stored in files or sometimes memory.&nbsp;There exist several different storage engines, but the most commonly used ones are MyISAM and InnoDB, each of which are the default storage engine in different MySQL [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[261,123,260,186],"class_list":["post-686","post","type-post","status-publish","format-standard","hentry","category-getting-started","tag-innodb","tag-linux","tag-myisam","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What is the difference between MyISAM and InnoDB? - KnownHost<\/title>\n<meta name=\"description\" content=\"Learn more about different MySQL engines and which one will be the best for your KnownHost WordPress server.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is the difference between MyISAM and InnoDB? - KnownHost\" \/>\n<meta property=\"og:description\" content=\"Learn more about different MySQL engines and which one will be the best for your KnownHost WordPress server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/\" \/>\n<meta property=\"og:site_name\" content=\"KnownHost\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-07T11:23:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-16T13:02:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable-1024x541.png\" \/>\n<meta name=\"author\" content=\"Jonathan K. W.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan K. W.\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/\"},\"author\":{\"name\":\"Jonathan K. W.\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\"},\"headline\":\"What is the difference between MyISAM and InnoDB?\",\"datePublished\":\"2021-07-07T11:23:29+00:00\",\"dateModified\":\"2021-11-16T13:02:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/\"},\"wordCount\":1411,\"image\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/phpmyadminselecttable-1024x541.png\",\"keywords\":[\"innodb\",\"linux\",\"myisam\",\"mysql\"],\"articleSection\":[\"Getting Started\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/\",\"name\":\"What is the difference between MyISAM and InnoDB? - KnownHost\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/phpmyadminselecttable-1024x541.png\",\"datePublished\":\"2021-07-07T11:23:29+00:00\",\"dateModified\":\"2021-11-16T13:02:56+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\"},\"description\":\"Learn more about different MySQL engines and which one will be the best for your KnownHost WordPress server.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/phpmyadminselecttable.png\",\"contentUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/phpmyadminselecttable.png\",\"width\":1200,\"height\":634},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/what-is-the-difference-between-myisam-and-innodb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is the difference between MyISAM and InnoDB?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\",\"name\":\"KnownHost\",\"description\":\"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\",\"name\":\"Jonathan K. W.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"caption\":\"Jonathan K. W.\"},\"sameAs\":[\"https:\\\/\\\/www.knownhost.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is the difference between MyISAM and InnoDB? - KnownHost","description":"Learn more about different MySQL engines and which one will be the best for your KnownHost WordPress server.","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:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/","og_locale":"en_US","og_type":"article","og_title":"What is the difference between MyISAM and InnoDB? - KnownHost","og_description":"Learn more about different MySQL engines and which one will be the best for your KnownHost WordPress server.","og_url":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/","og_site_name":"KnownHost","article_published_time":"2021-07-07T11:23:29+00:00","article_modified_time":"2021-11-16T13:02:56+00:00","og_image":[{"url":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable-1024x541.png","type":"","width":"","height":""}],"author":"Jonathan K. W.","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jonathan K. W.","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#article","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/"},"author":{"name":"Jonathan K. W.","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b"},"headline":"What is the difference between MyISAM and InnoDB?","datePublished":"2021-07-07T11:23:29+00:00","dateModified":"2021-11-16T13:02:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/"},"wordCount":1411,"image":{"@id":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable-1024x541.png","keywords":["innodb","linux","myisam","mysql"],"articleSection":["Getting Started"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/","url":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/","name":"What is the difference between MyISAM and InnoDB? - KnownHost","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#primaryimage"},"image":{"@id":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable-1024x541.png","datePublished":"2021-07-07T11:23:29+00:00","dateModified":"2021-11-16T13:02:56+00:00","author":{"@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b"},"description":"Learn more about different MySQL engines and which one will be the best for your KnownHost WordPress server.","breadcrumb":{"@id":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#primaryimage","url":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable.png","contentUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/07\/phpmyadminselecttable.png","width":1200,"height":634},{"@type":"BreadcrumbList","@id":"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knownhost.com\/kb\/"},{"@type":"ListItem","position":2,"name":"What is the difference between MyISAM and InnoDB?"}]},{"@type":"WebSite","@id":"https:\/\/www.knownhost.com\/kb\/#website","url":"https:\/\/www.knownhost.com\/kb\/","name":"KnownHost","description":"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knownhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b","name":"Jonathan K. W.","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","caption":"Jonathan K. W."},"sameAs":["https:\/\/www.knownhost.com"]}]}},"_links":{"self":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/686","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/comments?post=686"}],"version-history":[{"count":0,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/686\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/media?parent=686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/categories?post=686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/tags?post=686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}