Database Optimization - The Cloud Keeper

How to Convert Database Tables Storage Engine from MyISAM to InnoDB

In this post, I will show you how to easily convert your WordPress database tables from the MyISAM engine to the InnoDB engine. One of the biggest reasons that WordPress…

August 24, 2019
4 minute read
0

img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 .07em !important;vertical-align:-.1em !important;background:none !important;padding:0 !important;}body{--wp--preset--color--black:#000;--wp--preset--color--cyan-bluish-gray:#abb8c3;--wp--preset--color--white:#fff;--wp--preset--color--pale-pink:#f78da7;--wp--preset--color--vivid-red:#cf2e2e;--wp--preset--color--luminous-vivid-orange:#ff6900;--wp--preset--color--luminous-vivid-amber:#fcb900;--wp--preset--color--light-green-cyan:#7bdcb5;--wp--preset--color--vivid-green-cyan:#00d084;--wp--preset--color--pale-cyan-blue:#8ed1fc;--wp--preset--color--vivid-cyan-blue:#0693e3;--wp--preset--color--vivid-purple:#9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple:linear-gradient(135deg,rgba(6,147,227,1) 0%,#9b51e0 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan:linear-gradient(135deg,#7adcb4 0%,#00d082 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange:linear-gradient(135deg,rgba(252,185,0,1) 0%,rgba(255,105,0,1) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red:linear-gradient(135deg,rgba(255,105,0,1) 0%,#cf2e2e 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray:linear-gradient(135deg,#eee 0%,#a9b8c3 100%);--wp--preset--gradient--cool-to-warm-spectrum:linear-gradient(135deg,#4aeadc 0%,#9778d1 20%,#cf2aba 40%,#ee2c82 60%,#fb6962 80%,#fef84c 100%);--wp--preset--gradient--blush-light-purple:linear-gradient(135deg,#ffceec 0%,#9896f0 100%);--wp--preset--gradient--blush-bordeaux:linear-gradient(135deg,#fecda5 0%,#fe2d2d 50%,#6b003e 100%);--wp--preset--gradient--luminous-dusk:linear-gradient(135deg,#ffcb70 0%,#c751c0 50%,#4158d0 100%);--wp--preset--gradient--pale-ocean:linear-gradient(135deg,#fff5cb 0%,#b6e3d4 50%,#33a7b5 100%);--wp--preset--gradient--electric-grass:linear-gradient(135deg,#caf880 0%,#71ce7e 100%);--wp--preset--gradient--midnight:linear-gradient(135deg,#020381 0%,#2874fc 100%);--wp--preset--duotone--dark-grayscale:url("#wp-duotone-dark-grayscale");--wp--preset--duotone--grayscale:url("#wp-duotone-grayscale");--wp--preset--duotone--purple-yellow:url("#wp-duotone-purple-yellow");--wp--preset--duotone--blue-red:url("#wp-duotone-blue-red");--wp--preset--duotone--midnight:url("#wp-duotone-midnight");--wp--preset--duotone--magenta-yellow:url("#wp-duotone-magenta-yellow");--wp--preset--duotone--purple-green:url("#wp-duotone-purple-green");--wp--preset--duotone--blue-orange:url("#wp-duotone-blue-orange");--wp--preset--font-size--small:13px;--wp--preset--font-size--medium:20px;--wp--preset--font-size--large:36px;--wp--preset--font-size--x-large:42px;}.has-black-color{color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color:var(--wp--preset--color--white) !important;}.has-pale-pink-color{color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color:var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color:var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color:var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color:var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color:var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background:var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background:var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background:var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background:var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background:var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background:var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background:var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background:var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background:var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background:var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size:var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size:var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size:var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size:var(--wp--preset--font-size--x-large) !important;}.wp-block-navigation a:where(:not(.wp-element-button)){color:inherit;}:where(.wp-block-columns.is-layout-flex){gap:2em;}.wp-block-pullquote{font-size:1.5em;line-height:1.6;}div.wpforms-container-full .wpforms-form .h-captcha,#wpforo #wpforo-wrap div .h-captcha,.h-captcha{position:relative;display:block;margin-bottom:2rem;padding:0;clear:both;}.gform_previous_button + .h-captcha{margin-top:2rem;}#wpforo #wpforo-wrap.wpft-topic div .h-captcha,#wpforo #wpforo-wrap.wpft-forum div .h-captcha{margin:0 -20px;}.wpdm-button-area + .h-captcha{margin-bottom:1rem;}.w3eden .btn-primary{background-color:var(--color-primary) !important;color:#fff !important;}div.wpforms-container-full .wpforms-form .h-captcha[data-size="normal"],.h-captcha[data-size="normal"]{width:303px;height:78px;}div.wpforms-container-full .wpforms-form .h-captcha[data-size="compact"],.h-captcha[data-size="compact"]{width:164px;height:144px;}div.wpforms-container-full .wpforms-form .h-captcha[data-size="invisible"],.h-captcha[data-size="invisible"]{display:none;}.h-captcha::before{content:"";display:block;position:absolute;top:0;left:0;background:url("https://www.thecloudkeeper.io/wp-content/plugins/hcaptcha-for-forms-and-more/assets/images/hcaptcha-div-logo.svg") no-repeat;border:1px solid transparent;border-radius:4px;}.h-captcha[data-size="normal"]::before{width:300px;height:74px;background-position:94% 27%;}.h-captcha[data-size="compact"]::before{width:156px;height:136px;background-position:50% 77%;}.h-captcha[data-theme="light"]::before{background-color:#fafafa;border:1px solid #e0e0e0;}.h-captcha[data-theme="dark"]::before{background-color:#333;border:1px solid #f5f5f5;}.h-captcha[data-size="invisible"]::before{display:none;}div.wpforms-container-full .wpforms-form .h-captcha iframe,.h-captcha iframe{position:relative;}span[data-name="hcap-cf7"] .h-captcha{margin-bottom:0;}span[data-name="hcap-cf7"] ~ input[type="submit"]{margin-top:2rem;}.elementor-field-type-hcaptcha .elementor-field{background:transparent !important;}.elementor-field-type-hcaptcha .h-captcha{margin-bottom:unset;}div[style*="z-index: 2147483647"] div[style*="border-width: 11px"][style*="position: absolute"][style*="pointer-events: none"]{border-style:none;}a{color:#348aa7;}a:hover,a:focus{color:#525174;}.page-title:after{background:#5dd39e;}blockquote{color:#5dd39e;}.no-results{color:#525174;}input[type="submit"],input[type="button"],button{background:#348aa7;color:#fff;}.primary-nav li.menu-item:after{background:#348aa7;}.hero .slide-wrapper{background:#513b56;}.hero:not(.cover) .entry-header,.hero:not(.cover) .entry-content,.hero:not(.cover) .entry-meta li,.hero:not(.cover) .entry-meta li a,.hero:not(.cover) .entry-title a,.hero:not(.cover) .entry-title{color:#fff;}.hero:not(.cover) .post-category > span.category-link-bg{background:rgba(255,255,255,.2);}.hero:not(.cover) .post-category a{color:#fff;}.hero[data-slides="2"] .slide-wrapper.slide-2{background:#5dd39e;}.hero[data-slides="2"] .slide-wrapper.slide-3{background:#348aa7;}.hero[data-slides="2"] .slide-wrapper.slide-4{background:#e9c67b;}.carousel-content .page-title:after{background:#e9c67b;}.content-area:not(.the-post) article[class*="post"],.content-area.the-post .post-navigation article{background:#e9c67b;color:#fff;}.content-area.grid article[class*="post"] .entry-title a,.content-area.classic article[class*="post"]:not(.post_format-post-format-image) .entry-title a,.content-area.list article[class*="post"]:not(.post_format-post-format-image) .entry-title a,.content-area.masonry article[class*="post"]:not(.post_format-post-format-image) .entry-title a{color:#fff;}.entry-comments-title span{color:#fff;}.content-area.grid article[class*="post"] .entry-meta li,.content-area.classic article[class*="post"]:not(.post_format-post-format-image) .entry-meta li,.content-area.list article[class*="post"]:not(.post_format-post-format-image) .entry-meta li,.content-area.masonry article[class*="post"]:not(.post_format-post-format-image) .entry-meta li{color:#fff;}.content-area.grid article[class*="post"] .entry-meta a,.content-area.classic article[class*="post"]:not(.post_format-post-format-image) .entry-meta a,.content-area.list article[class*="post"]:not(.post_format-post-format-image) .entry-meta a,.content-area.masonry article[class*="post"]:not(.post_format-post-format-image) .entry-meta a{color:#fff;}.content-area .entry-meta li.entry-comment-count,ol.popular-posts.list-style-list-first-grid > li:first-child:before,ol.popular-posts.list-style-grid > li:before{background:#333;color:#fff !important;}.entry-meta li.entry-comment-count a{color:#fff;}.loop-comments.has-comment-count li:first-child:before{border-top-color:#333;}.the-post .hentry .entry-meta li.entry-comment-count:after{border-top-color:#333;}.content-area.grid article .post-category > span.category-link-bg,.content-area.classic article:not(.post_format-post-format-image) .post-category > span.category-link-bg,.content-area.list article:not(.post_format-post-format-image) .post-category > span.category-link-bg,.content-area.masonry article:not(.post_format-post-format-image) .post-category > span.category-link-bg{background:rgba(255,255,255,.2);}.content-area.grid article .post-category a,.content-area.classic article:not(.post_format-post-format-image) .post-category a,.content-area.list article:not(.post_format-post-format-image) .post-category a,.content-area.masonry article:not(.post_format-post-format-image) .post-category a{color:#fff !important;}.sticky-sash{background:#513b56;}.content-area:not(.the-post) article[class*="post"]:nth-child(4n+2),.content-area.the-post .post-navigation article.next-article{background:#5dd39e;}.content-area:not(.the-post) article[class*="post"]:nth-child(4n+3){background:#348aa7;}.content-area:not(.the-post) article[class*="post"]:nth-child(4n){background:#525174;}.the-post .entry-content p.dropcaps::first-letter{background:#e9c67b;}.the-post .entry-meta a{color:#348aa7;}.comment.bypostauthor > .comment-body cite:after{color:#348aa7;}.widget .widget-title:after{background:#5dd39e;}.widget.widget_categories span{background:#348aa7;color:#fff;}.widget.widget_categories .children li a{color:#525174;}.widget.widget_categories .children li .children li a{color:#348aa7;}.widget.widget_recent_comments span{color:#5dd39e;}.widget.widget_recent_comments a.url{color:#348aa7;}.widget_rss cite{color:#5dd39e;}.widget_calendar th{background:#348aa7;color:#fff;}.widget.widget_tag_cloud li a{background:#e9c67b;}.widget.widget_tag_cloud li:nth-child(5n+2) a{background:#5dd39e;}.widget.widget_tag_cloud li:nth-child(5n+3) a{background:#348aa7;}.widget.widget_tag_cloud li:nth-child(5n+4) a{background:#525174;}.widget.widget_tag_cloud li:nth-child(5n+5) a{background:#513b56;}.widget_tag_cloud ul li span{color:#fff;}.widget_about{background:#348aa7;}.nav-links .current{color:#348aa7;}.nav-links .page-numbers.next,.nav-links .page-numbers.prev,.nav-links .nav-previous a,.nav-links .nav-next a{background:#5dd39e;border-color:#5dd39e;color:#fff;}.prev span,.next span,.nav-next span,.nav-previous span{color:#348aa7;}.post-navigation h3 a{color:#fff;}.nav-links.page-pagination > span:not(.pages){color:#348aa7;}.wp-block-pullquote.alignleft,.wp-block-pullquote.alignright{color:#fff;background:#5dd39e;}pre{color:#24292e;background-color:#f6f8fa;}ul{font-family:"Karla";}p{font-family:"Karla",sans-serif;font-style:normal;font-weight:400;}h1{font-family:"Roboto Slab",sans-serif;font-style:normal;font-weight:400;}h2{}h3{}h4{}h5{}h6{}