{"id":1002,"date":"2020-06-15T21:01:00","date_gmt":"2020-06-16T01:01:00","guid":{"rendered":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/?p=1002"},"modified":"2020-06-17T15:42:20","modified_gmt":"2020-06-17T19:42:20","slug":"database-storage-engine","status":"publish","type":"post","link":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/2020\/database-storage-engine\/","title":{"rendered":"Database Storage Engine"},"content":{"rendered":"\n<p>I have run into more than one database that has both MyISAM and InnoDB tables and I&#8217;m very happy to know that I can change all of them into InnoDB&#8211;providing it&#8217;s at least MySQL 5.6.4.<\/p>\n\n\n\n<p>This little, practical <a rel=\"noreferrer noopener\" href=\"https:\/\/kinsta.com\/knowledgebase\/convert-myisam-to-innodb\/\" target=\"_blank\">article from Kinsta<\/a> tells how and has more detail, but basically, you can just change it from a dropdown once you&#8217;re in phpMyAdmin, or you can use:<\/p>\n\n\n\n<!--more-->\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE wp_comments ENGINE=InnoDB;<\/code><\/pre>\n\n\n\n<p>using <code>wp_comments<\/code> as an example.<\/p>\n\n\n\n<p>This will help me streamline some old DBs! \\o\/<\/p>\n\n\n\n<p>If you want to read more about databases and WordPress, <a rel=\"noreferrer noopener\" href=\"https:\/\/deliciousbrains.com\/tour-wordpress-database\/\" target=\"_blank\">Delicious Brains<\/a> has a nice article about it, which is also where I got the link to the Kinsta one.<\/p>\n\n\n\n<div class=\"_3bJ2H CHExY\">Photo credit: <a href=\"https:\/\/blindeman.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">de moi<\/a>, 2020<\/div>\n","protected":false},"excerpt":{"rendered":"<p>I have run into more than one database that has both MyISAM and InnoDB tables and I&#8217;m very happy to know that I can change all of them into InnoDB&#8211;providing it&#8217;s at least MySQL 5.6.4. This little, practical article from Kinsta tells how and has more detail, but basically, you can just change it from &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Database Storage Engine\" class=\"read-more button\" href=\"https:\/\/www.blindemanwebsites.com\/today-i-learned\/2020\/database-storage-engine\/#more-1002\" aria-label=\"Read more about Database Storage Engine\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[173,177,176,172,175,174],"class_list":["post-1002","post","type-post","status-publish","format-standard","hentry","category-new-things","tag-database","tag-delicious-brains","tag-innodb","tag-kinsta","tag-myisam","tag-optimization","infinite-scroll-item"],"_links":{"self":[{"href":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/wp-json\/wp\/v2\/posts\/1002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/wp-json\/wp\/v2\/comments?post=1002"}],"version-history":[{"count":2,"href":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/wp-json\/wp\/v2\/posts\/1002\/revisions"}],"predecessor-version":[{"id":1008,"href":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/wp-json\/wp\/v2\/posts\/1002\/revisions\/1008"}],"wp:attachment":[{"href":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/wp-json\/wp\/v2\/media?parent=1002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/wp-json\/wp\/v2\/categories?post=1002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blindemanwebsites.com\/today-i-learned\/wp-json\/wp\/v2\/tags?post=1002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}