{"version":"1.0","provider_name":"","provider_url":"https:\/\/truehost.com\/support","author_name":"Patrick K","author_url":"https:\/\/truehost.com\/support\/author\/patrick\/","title":"How to Optimize MySQL Database Tables -","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"LzeXopV9SX\"><a href=\"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/\">How to Optimize MySQL Database Tables<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/embed\/#?secret=LzeXopV9SX\" width=\"600\" height=\"338\" title=\"&#8220;How to Optimize MySQL Database Tables&#8221; &#8212; \" data-secret=\"LzeXopV9SX\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/truehost.com\/support\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"1.Login to cPanel. 2.Click on phpMyAdmin to open. 3.Navigate to the\u00a0Databases\u00a0tab and click on the name of the desired database. 4.Select all of the tables that you want to be optimized by ticking the check-box next to their name. 5.From the\u00a0With Selected:\u00a0drop-down menu choose\u00a0Optimize table. The optimization will be performed automatically and a new page [&hellip;]","thumbnail_url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png"}