{"id":1388,"date":"2021-07-26T06:12:06","date_gmt":"2021-07-26T11:12:06","guid":{"rendered":"https:\/\/www.knownhost.com\/kb\/?p=1388"},"modified":"2026-01-23T06:14:15","modified_gmt":"2026-01-23T12:14:15","slug":"check-wordpress-database-tables","status":"publish","type":"post","link":"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/","title":{"rendered":"How to Know if Your WordPress Database Tables are MyISAM or 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' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/#why_change_wordpress_database_from_myisam_to_innodb\" >Why Change WordPress Database from MyISAM to InnoDB?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>Option 1:<\/p>\n\n\n\n<p>Login to phpMyAdmin, highlight your database and browse the tables. Check the \u201cType\u201d column to see what type of tables they are\u2026<\/p>\n\n\n\n<p>Option 2:<\/p>\n\n\n\n<p>Use phpMyAdmin SQL tab and run the query to find the tables that might still be MyISAM:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT TABLE_NAME, ENGINE\n  FROM information_schema.TABLES\n  WHERE TABLE_SCHEMA = 'yourdatabasename' and ENGINE = 'MyISAM';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"why_change_from_myisam_to_innodb\"><span class=\"ez-toc-section\" id=\"why_change_wordpress_database_from_myisam_to_innodb\"><\/span>Why Change WordPress Database from MyISAM to InnoDB?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Depending on when you installed WordPress and what\u2019s transpired since then, it could be that some, or all, of your database tables are still MyISAM. While this is perfectly acceptable &#8211; many sites have run MyISAM for ages, there are some reasons to consider moving over to <a href=\"https:\/\/wordpress.org\/support\/article\/optimization\/\">InnoDB<\/a>.<\/p>\n\n\n\n<p>InnoDB is a generational step forward from MyISAM, providing features like transaction handling, foreign key constraints (so that it\u2019s a relational database) and row level locking. Performance benchmarks show InnoDB to be the favorite as well. If you would like to learn more about the <a href=\"https:\/\/www.knownhost.com\/kb\/what-is-the-difference-between-myisam-and-innodb\/\">differences between MyISAM and InnoDBs WordPress Database read here<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now that we\u2019ve gone over how to check what database tables WordPress is set to. Use our knowledge base to get other helpful articles, or contact support to get help now.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.knownhost.com\/\">KnownHost<\/a>&nbsp;offers 365 days a year, 24 hours a day, all 7 days of the week best in class technical support. A dedicated team is ready to help you should you need our assistance. You\u2019re not using KnownHost for the best web hosting experience? Well, why not? Check with&nbsp;our Sales team&nbsp;to see what can KnownHost do for you in improving your web hosting experience.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Option 1: Login to phpMyAdmin, highlight your database and browse the tables. Check the \u201cType\u201d column to see what type of tables they are\u2026 Option 2: Use phpMyAdmin SQL tab and run the query to find the tables that might still be MyISAM: Why Change WordPress Database from MyISAM to InnoDB? Depending on when you [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[146],"tags":[251,252,257,261,260,106],"class_list":["post-1388","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-blogs","tag-cms","tag-database","tag-innodb","tag-myisam","tag-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Check WordPress Database Tables: MyISAM vs InnoDB | KnownHost<\/title>\n<meta name=\"description\" content=\"Learn how to check if your WordPress database uses MyISAM or InnoDB storage engines. Step-by-step guide to identify and optimize your MySQL database tables.\" \/>\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\/check-wordpress-database-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Check WordPress Database Tables: MyISAM vs InnoDB | KnownHost\" \/>\n<meta property=\"og:description\" content=\"Learn how to check if your WordPress database uses MyISAM or InnoDB storage engines. Step-by-step guide to identify and optimize your MySQL database tables.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"KnownHost\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-26T11:12:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-23T12:14:15+00:00\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/check-wordpress-database-tables\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/check-wordpress-database-tables\\\/\"},\"author\":{\"name\":\"Jonathan K. W.\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\"},\"headline\":\"How to Know if Your WordPress Database Tables are MyISAM or InnoDB?\",\"datePublished\":\"2021-07-26T11:12:06+00:00\",\"dateModified\":\"2026-01-23T12:14:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/check-wordpress-database-tables\\\/\"},\"wordCount\":265,\"keywords\":[\"blogs\",\"cms\",\"database\",\"innodb\",\"myisam\",\"wordpress\"],\"articleSection\":[\"WordPress\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/check-wordpress-database-tables\\\/\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/check-wordpress-database-tables\\\/\",\"name\":\"Check WordPress Database Tables: MyISAM vs InnoDB | KnownHost\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\"},\"datePublished\":\"2021-07-26T11:12:06+00:00\",\"dateModified\":\"2026-01-23T12:14:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\"},\"description\":\"Learn how to check if your WordPress database uses MyISAM or InnoDB storage engines. Step-by-step guide to identify and optimize your MySQL database tables.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/check-wordpress-database-tables\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/check-wordpress-database-tables\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/check-wordpress-database-tables\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Know if Your WordPress Database Tables are MyISAM or 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":"Check WordPress Database Tables: MyISAM vs InnoDB | KnownHost","description":"Learn how to check if your WordPress database uses MyISAM or InnoDB storage engines. Step-by-step guide to identify and optimize your MySQL database tables.","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\/check-wordpress-database-tables\/","og_locale":"en_US","og_type":"article","og_title":"Check WordPress Database Tables: MyISAM vs InnoDB | KnownHost","og_description":"Learn how to check if your WordPress database uses MyISAM or InnoDB storage engines. Step-by-step guide to identify and optimize your MySQL database tables.","og_url":"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/","og_site_name":"KnownHost","article_published_time":"2021-07-26T11:12:06+00:00","article_modified_time":"2026-01-23T12:14:15+00:00","author":"Jonathan K. W.","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jonathan K. W.","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/#article","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/"},"author":{"name":"Jonathan K. W.","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b"},"headline":"How to Know if Your WordPress Database Tables are MyISAM or InnoDB?","datePublished":"2021-07-26T11:12:06+00:00","dateModified":"2026-01-23T12:14:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/"},"wordCount":265,"keywords":["blogs","cms","database","innodb","myisam","wordpress"],"articleSection":["WordPress"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/","url":"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/","name":"Check WordPress Database Tables: MyISAM vs InnoDB | KnownHost","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/#website"},"datePublished":"2021-07-26T11:12:06+00:00","dateModified":"2026-01-23T12:14:15+00:00","author":{"@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b"},"description":"Learn how to check if your WordPress database uses MyISAM or InnoDB storage engines. Step-by-step guide to identify and optimize your MySQL database tables.","breadcrumb":{"@id":"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.knownhost.com\/kb\/check-wordpress-database-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knownhost.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to Know if Your WordPress Database Tables are MyISAM or 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\/1388","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=1388"}],"version-history":[{"count":1,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/1388\/revisions"}],"predecessor-version":[{"id":8013,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/1388\/revisions\/8013"}],"wp:attachment":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/media?parent=1388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/categories?post=1388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/tags?post=1388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}