{"version":"1.0","provider_name":"OWS KB","provider_url":"https:\/\/ownwebservers.com\/kb","author_name":"admin","author_url":"https:\/\/ownwebservers.com\/kb\/author\/it_iq6s6sdy\/","title":"Optimize MySQL database - OWS KB","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"IusyljM9q3\"><a href=\"https:\/\/ownwebservers.com\/kb\/optimize-mysql-database\/\">Optimize MySQL database<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/ownwebservers.com\/kb\/optimize-mysql-database\/embed\/#?secret=IusyljM9q3\" width=\"600\" height=\"338\" title=\"&#8220;Optimize MySQL database&#8221; &#8212; OWS KB\" data-secret=\"IusyljM9q3\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\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:\/\/ownwebservers.com\/kb\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"Usually, for a web site having large volume of data, optimizing the MySQL database becomes crucial for enhancing the performance to indexing. Indexing helps in an exceedingly better collation of data and is an internal feature that comes with MySQL. Consider a table \u201cabc\u201d that includes a set of rows could also be two whereby [&hellip;]"}