{"id":6752,"date":"2019-01-10T15:53:38","date_gmt":"2019-01-10T15:53:38","guid":{"rendered":"https:\/\/www.siliconhouse.net\/support\/?page_id=6752"},"modified":"2019-01-10T15:55:30","modified_gmt":"2019-01-10T15:55:30","slug":"how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel","status":"publish","type":"page","link":"https:\/\/www.siliconhouse.net\/support\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\/","title":{"rendered":"How to Optimize MySQL Database Using phpMyAdmin in cPanel?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"> MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language in the <a rel=\"noreferrer noopener\" href=\"https:\/\/www.siliconhouse.net\/linux-reseller-web-hosting-india\" target=\"_blank\">Reseller Hosting<\/a>.The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. The most common use for mySQL however, is for the purpose of a web database in <a rel=\"noreferrer noopener\" href=\"https:\/\/www.siliconhouse.net\/linux-reseller-web-hosting-india\" target=\"_blank\">Linux hosting<\/a>. MySQL is a database management system, like SQL Server, Oracle, Informix, Postgres, etc. You can optimize the unused space of the table for the performance of the server. If you have made a lot of changes to the table, optimizing the table can delete the unused space thereby you can improve the database performance. You can follow procedure to Optimize MySQL Database Using phpMyAdmin in<a rel=\"noreferrer noopener\" href=\"https:\/\/www.siliconhouse.net\/linux-reseller-web-hosting-india\" target=\"_blank\">hosting<\/a> cPanel.&nbsp;&nbsp;<\/p>\n\n\n<aside id=\"text-16\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><div class=\"reseller_web_hosting_support_advts\">\r\n\r\n<div class=\"reseller_web_hosting_support_advts_left\">\r\n<a href=\"https:\/\/www.siliconhouse.net\/linux-reseller-web-hosting-india\" target=\"_blank\"><img decoding=\"async\" border=\"0\" src=\"https:\/\/www.siliconhouse.net\/wp-content\/uploads\/2018\/06\/336X280-saffron-unlimited-499-kickstart.gif\" width=\"336\" height=\"280\" alt=\"Reseller Hosting Special Offer\"><\/a>\r\n<\/div>\r\n\r\n<div class=\"reseller_web_hosting_support_advts_right\">\r\n<a href=\"https:\/\/www.siliconhouse.net\/linux-cloud-server-hosting-india\" target=\"_blank\"><img decoding=\"async\" border=\"0\" src=\"https:\/\/www.siliconhouse.net\/wp-content\/uploads\/2018\/06\/336X280-purple-enterprise-cloud-stak-19.jpg\" width=\"336\" height=\"280\" alt=\"Enterprise Cloud Stack\"><\/a>\r\n<\/div>\r\n\r\n<\/div><\/div>\n\t\t<\/aside>\n\n\n\n<p class=\"wp-block-paragraph\"> <aside id=\"text-20\" class=\"extendedwopts-md-center widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><div class=\"reseller_web_hosting_support_advts\">\r\n<div class=\"reseller_web_hosting_support_advts_left\">\r\n<img decoding=\"async\" border=\"0\" src=\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/12\/reseller-hosting-249-offer.gif\" width=\"320\" height=\"100\" alt=\"Reseller Hosting Special Offer\">\r\n<\/div>\r\n\r\n<div class=\"reseller_web_hosting_support_advts_right\">\r\n<img decoding=\"async\" border=\"0\" src=\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/12\/reseller-hosting-249-offer.gif\" width=\"320\" height=\"100\" alt=\"Reseller Hosting Special Offer\">\r\n<\/div>\r\n\r\n<\/div><\/div>\n\t\t<\/aside><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> [1]&nbsp; Login to cPanel and go to \u201cphpMyAdmin\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[2]\u00a0 Click On \u201cDatabases\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[3]\u00a0 Select the database you want to optimize from the database list.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[4] It will take you to the \u201cStructure\u201d tab for the database where you can select the table you want to optimize. Check the box in front of each one, or click on Select All if you want to optimize all of them.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[5]\u00a0 On the drop down box that says \u201cwith selected\u201d select \u201cOptimize Table.\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[6] This will optimize the table and take you to a new screen where you can see the list of tables which you have optimized. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language in the Reseller Hosting.The<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-6752","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Optimize MySQL Database Using phpMyAdmin in cPanel? - Silicon House - Reseller Hosting - Dedicated Servers - Cloud<\/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:\/\/www.siliconhouse.net\/support\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\/\" \/>\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 Using phpMyAdmin in cPanel? - Silicon House - Reseller Hosting - Dedicated Servers - Cloud\" \/>\n<meta property=\"og:description\" content=\"MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language in the Reseller Hosting.The\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.siliconhouse.net\/support\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Silicon House - Reseller Hosting - Dedicated Servers - Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/siliconhouse.net\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-10T15:55:30+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@siliconhouse\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\\\/\",\"url\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\\\/\",\"name\":\"How to Optimize MySQL Database Using phpMyAdmin in cPanel? - Silicon House - Reseller Hosting - Dedicated Servers - Cloud\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#website\"},\"datePublished\":\"2019-01-10T15:53:38+00:00\",\"dateModified\":\"2019-01-10T15:55:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Optimize MySQL Database Using phpMyAdmin in cPanel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/\",\"name\":\"Silicon House - Reseller Hosting - Dedicated Servers - Cloud\",\"description\":\"Reseller Hosting - Dedicated Servers - Cloud\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#organization\",\"name\":\"Silicon House\",\"url\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/siliconhouse-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/siliconhouse-logo.png\",\"width\":42,\"height\":40,\"caption\":\"Silicon House\"},\"image\":{\"@id\":\"https:\\\/\\\/www.siliconhouse.net\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/siliconhouse.net\",\"https:\\\/\\\/x.com\\\/siliconhouse\",\"https:\\\/\\\/www.youtube.com\\\/siliconhouse\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Optimize MySQL Database Using phpMyAdmin in cPanel? - Silicon House - Reseller Hosting - Dedicated Servers - Cloud","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:\/\/www.siliconhouse.net\/support\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"How to Optimize MySQL Database Using phpMyAdmin in cPanel? - Silicon House - Reseller Hosting - Dedicated Servers - Cloud","og_description":"MySQL is an Oracle-backed open source relational database management system (RDBMS) based on Structured Query Language in the Reseller Hosting.The","og_url":"https:\/\/www.siliconhouse.net\/support\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\/","og_site_name":"Silicon House - Reseller Hosting - Dedicated Servers - Cloud","article_publisher":"https:\/\/www.facebook.com\/siliconhouse.net","article_modified_time":"2019-01-10T15:55:30+00:00","twitter_card":"summary_large_image","twitter_site":"@siliconhouse","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.siliconhouse.net\/support\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\/","url":"https:\/\/www.siliconhouse.net\/support\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\/","name":"How to Optimize MySQL Database Using phpMyAdmin in cPanel? - Silicon House - Reseller Hosting - Dedicated Servers - Cloud","isPartOf":{"@id":"https:\/\/www.siliconhouse.net\/support\/#website"},"datePublished":"2019-01-10T15:53:38+00:00","dateModified":"2019-01-10T15:55:30+00:00","breadcrumb":{"@id":"https:\/\/www.siliconhouse.net\/support\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.siliconhouse.net\/support\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.siliconhouse.net\/support\/how-to-optimize-mysql-database-using-phpmyadmin-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.siliconhouse.net\/support\/"},{"@type":"ListItem","position":2,"name":"How to Optimize MySQL Database Using phpMyAdmin in cPanel?"}]},{"@type":"WebSite","@id":"https:\/\/www.siliconhouse.net\/support\/#website","url":"https:\/\/www.siliconhouse.net\/support\/","name":"Silicon House - Reseller Hosting - Dedicated Servers - Cloud","description":"Reseller Hosting - Dedicated Servers - Cloud","publisher":{"@id":"https:\/\/www.siliconhouse.net\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.siliconhouse.net\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.siliconhouse.net\/support\/#organization","name":"Silicon House","url":"https:\/\/www.siliconhouse.net\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png","contentUrl":"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png","width":42,"height":40,"caption":"Silicon House"},"image":{"@id":"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/siliconhouse.net","https:\/\/x.com\/siliconhouse","https:\/\/www.youtube.com\/siliconhouse"]}]}},"_links":{"self":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/6752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/comments?post=6752"}],"version-history":[{"count":3,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/6752\/revisions"}],"predecessor-version":[{"id":6756,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/6752\/revisions\/6756"}],"wp:attachment":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/media?parent=6752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}