{"id":6512,"date":"2021-04-30T20:58:00","date_gmt":"2021-04-30T20:58:00","guid":{"rendered":"https:\/\/truehost.co.ke\/support\/?post_type=ht_kb&#038;p=6512"},"modified":"2024-06-07T13:03:09","modified_gmt":"2024-06-07T13:03:09","password":"","slug":"how-to-optimize-mysql-database-tables","status":"publish","type":"docs","link":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/","title":{"rendered":"How to Optimize MySQL Database Tables"},"content":{"rendered":"\n<p>1.Login to <a href=\"https:\/\/truehost.com\/support\/knowledge-base\/how-to-login-to-cpanel\/\">cPanel<\/a>.<\/p>\n\n\n\n<p>2.Click on <strong>phpMyAdmin<\/strong> to open.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"973\" height=\"172\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png\" alt=\"\" class=\"wp-image-7411\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png 973w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1-300x53.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1-768x136.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1-50x9.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1-920x163.png 920w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1-600x106.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1-320x57.png 320w\" sizes=\"auto, (max-width: 973px) 100vw, 973px\" \/><\/figure>\n\n\n\n<p>3.Navigate to the\u00a0<strong>Databases<\/strong>\u00a0tab and click on the name of the desired database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"877\" height=\"254\" src=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-1.png\" alt=\"\" class=\"wp-image-7412\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-1.png 877w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-1-300x87.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-1-768x222.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-1-50x14.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-1-600x174.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-08-18-sbg108.truehost.cloud-_-localhost-phpMyAdmin-4.9.7-1-320x93.png 320w\" sizes=\"auto, (max-width: 877px) 100vw, 877px\" \/><\/figure>\n\n\n\n<p>4.Select all of the tables that you want to be optimized by ticking the check-box next to their name. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"520\" src=\"http:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7.png\" alt=\"\" class=\"wp-image-7407\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7.png 900w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-300x173.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-768x444.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-50x29.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-600x347.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-10-15-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-320x185.png 320w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/figure>\n\n\n\n<p>5.From the\u00a0<strong>With Selected:<\/strong>\u00a0drop-down menu choose\u00a0<strong>Optimize table<\/strong>. The optimization will be performed automatically and a new page will open that shows the result of the operation.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"200\" src=\"http:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-1024x200.png\" alt=\"\" class=\"wp-image-7408\" srcset=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-1024x200.png 1024w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-300x59.png 300w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-768x150.png 768w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-50x10.png 50w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-920x179.png 920w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-600x117.png 600w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7-320x62.png 320w, https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-14-11-21-sbg108.truehost.cloud-_-localhost-_-toptruehost_wp920-phpMyAdmin-4.9.7.png 1256w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You have successfully optimized your database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_eb_attr":"","_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"doc_category":[],"doc_tag":[],"class_list":["post-6512","docs","type-docs","status-publish","hentry"],"year_month":"2026-06","word_count":75,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"Patrick K","author_nicename":"patrick","author_url":"https:\/\/truehost.com\/support\/author\/patrick\/"},"doc_category_info":[],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Optimize MySQL Database Tables -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Optimize MySQL Database Tables -\" \/>\n<meta property=\"og:description\" content=\"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;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-07T13:03:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-optimize-mysql-database-tables\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-optimize-mysql-database-tables\\\/\",\"name\":\"How to Optimize MySQL Database Tables -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-optimize-mysql-database-tables\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-optimize-mysql-database-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png\",\"datePublished\":\"2021-04-30T20:58:00+00:00\",\"dateModified\":\"2024-06-07T13:03:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-optimize-mysql-database-tables\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-optimize-mysql-database-tables\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-optimize-mysql-database-tables\\\/#primaryimage\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png\",\"contentUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png\",\"width\":973,\"height\":172},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/knowledge-base\\\/how-to-optimize-mysql-database-tables\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/truehost.com\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Optimize MySQL Database Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"name\":\"\",\"description\":\"Help In a Click\",\"publisher\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/truehost.com\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#organization\",\"name\":\"Truehost Kenya\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"contentUrl\":\"https:\\\/\\\/truehost.com\\\/support\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/cropped-image_2026-04-16_174808866.png\",\"width\":240,\"height\":48,\"caption\":\"Truehost Kenya\"},\"image\":{\"@id\":\"https:\\\/\\\/truehost.com\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Optimize MySQL Database Tables -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/","og_locale":"en_US","og_type":"article","og_title":"How to Optimize MySQL Database Tables -","og_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;]","og_url":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/","article_modified_time":"2024-06-07T13:03:09+00:00","og_image":[{"url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/","url":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/","name":"How to Optimize MySQL Database Tables -","isPartOf":{"@id":"https:\/\/truehost.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/#primaryimage"},"image":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png","datePublished":"2021-04-30T20:58:00+00:00","dateModified":"2024-06-07T13:03:09+00:00","breadcrumb":{"@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/#primaryimage","url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png","contentUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2022\/05\/Screenshot-2022-05-06-at-13-57-30-cPanel-Main-1.png","width":973,"height":172},{"@type":"BreadcrumbList","@id":"https:\/\/truehost.com\/support\/knowledge-base\/how-to-optimize-mysql-database-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/truehost.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Optimize MySQL Database Tables"}]},{"@type":"WebSite","@id":"https:\/\/truehost.com\/support\/#website","url":"https:\/\/truehost.com\/support\/","name":"","description":"Help In a Click","publisher":{"@id":"https:\/\/truehost.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/truehost.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/truehost.com\/support\/#organization","name":"Truehost Kenya","url":"https:\/\/truehost.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","contentUrl":"https:\/\/truehost.com\/support\/wp-content\/uploads\/2026\/04\/cropped-image_2026-04-16_174808866.png","width":240,"height":48,"caption":"Truehost Kenya"},"image":{"@id":"https:\/\/truehost.com\/support\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/6512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/comments?post=6512"}],"version-history":[{"count":2,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/6512\/revisions"}],"predecessor-version":[{"id":7413,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/docs\/6512\/revisions\/7413"}],"wp:attachment":[{"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/media?parent=6512"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_category?post=6512"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/truehost.com\/support\/wp-json\/wp\/v2\/doc_tag?post=6512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}