{"id":2151,"date":"2020-06-09T03:29:34","date_gmt":"2020-06-08T19:29:34","guid":{"rendered":"https:\/\/www.wesbytes.com\/guide\/?post_type=kb&#038;p=2151"},"modified":"2026-01-09T17:26:30","modified_gmt":"2026-01-09T09:26:30","slug":"how-to-optimize-your-mysql-databases","status":"publish","type":"kb","link":"https:\/\/www.servergigabit.com\/guide\/kb\/how-to-optimize-your-mysql-databases","title":{"rendered":"How to optimize your MySQL databases"},"content":{"rendered":"<h3 dir=\"ltr\"><strong>Steps to optimize your MySQL databases<\/strong><\/h3>\n<p dir=\"ltr\">Databases is one of the important entities for the website to work normally. There is also some times that the required database may some times take up to many resources which may leads to the website to down or either showing error below is on how to optimize your databases to help your website system to work normally.<\/p>\n<p dir=\"ltr\"><strong>Step 1: Login to phpMyAdmin<\/strong><\/p>\n<p dir=\"ltr\">cPanel: (Shared, Reseller, SEO, Linux Dedicated, VPS with cPanel)<\/p>\n<p dir=\"ltr\">Login to cPanel<\/p>\n<p dir=\"ltr\">\u2013 Click on the <a href=\"https:\/\/www.phpmyadmin.net\/\" rel=\"nofollow noopener\" target=\"_blank\">phpMyAdmin<\/a> button in the Databases section.<\/p>\n<p dir=\"ltr\">\u2013 Plesk 10: (Windows Shared, Windows Dedicated, VPS with Plesk)<\/p>\n<p dir=\"ltr\">Login to Plesk<\/p>\n<p dir=\"ltr\">\u2013 Click on the Websites &amp; Domains tab.<\/p>\n<p dir=\"ltr\">\u2013 Next, Click on the Databases icon.<\/p>\n<p dir=\"ltr\">\u2013 Click on the database you want to manage.<\/p>\n<p dir=\"ltr\">\u2013 Lastly, Click on the Webadmin icon.<\/p>\n<p dir=\"ltr\"><strong>Step 2: Optimize Tables<\/strong><\/p>\n<p>On the left side of phpMyAdmin, you\u2019ll see a list of databases:<\/p>\n<ol>\n<li>Select your database from the list.\n<dl>\n<dd><em>In the center panel, a list of your tables appears:<\/em><\/dd>\n<dd><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/kbimages.dreamhosters.com\/images\/01_Optimizing_Database.fw.png\" alt=\"optimize your MySQL databases-list of tables\" width=\"1038\" height=\"525\" \/><\/dd>\n<\/dl>\n<\/li>\n<li dir=\"ltr\">Look at the \u2018Overhead\u2019 column to the far right \u2013 if you see any numerical values, those tables can be optimized. In the example above, only those tables have been selected.<\/li>\n<li>At the bottom of your table list, click the \u2018<strong>With selected<\/strong>\u2019 dropdown menu.<img decoding=\"async\" class=\"alignnone\" src=\"https:\/\/kbimages.dreamhosters.com\/images\/02_Optimizing_Database.fw.png\" alt=\"Optimize MySQL databases-dropdown menu\" width=\"168\" height=\"318\" \/><\/li>\n<li>From the dropdown menu, select \u2018<strong>Optimize table<\/strong>\u2019.\n<dl>\n<dd>The optimization may take time to complete depending how large the database is. Once it completes, the page displays the query that was run along with a success message:<\/dd>\n<dd><img decoding=\"async\" class=\"alignnone\" src=\"https:\/\/kbimages.dreamhosters.com\/images\/03_Optimizing_Database.fw.png\" alt=\"Optimize MySQL databases-selesct-optimize databses\" width=\"662\" height=\"346\" \/><\/dd>\n<\/dl>\n<\/li>\n<li>\u00a0Done to optimize MySQL databases.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><em>Please refer to the following article to know more.\u00a0<\/em><br \/>\n<strong>Knowledge Base: <\/strong><a href=\"https:\/\/www.servergigabit.com\/guide\/kb\/how-to-update-mysql-database-user-privilege\/\">How to update MySQL Database user privilege<\/a><\/p>\n<dl><\/dl>\n","protected":false},"excerpt":{"rendered":"<p>Steps to optimize your MySQL databases Databases is one of the important entities for the website to work normally. There is also some times that the required database may some times take up to many resources which may leads to the website to down or either showing error below is on how to optimize your databases to help your website&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[51],"kbtag":[1310],"class_list":["post-2151","kb","type-kb","status-publish","hentry","kbtopic-mysql","kbtag-optimize-mysql-database"],"_links":{"self":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/comments?post=2151"}],"version-history":[{"count":6,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2151\/revisions"}],"predecessor-version":[{"id":5714,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2151\/revisions\/5714"}],"wp:attachment":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/media?parent=2151"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=2151"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtag?post=2151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}