{"id":763,"date":"2017-12-27T11:08:32","date_gmt":"2017-12-27T05:38:32","guid":{"rendered":"https:\/\/www.coimbatorewebhosting.com\/blog\/?p=763"},"modified":"2017-12-27T16:48:20","modified_gmt":"2017-12-27T11:18:20","slug":"easy-way-to-optimize-the-wordpress-data-base","status":"publish","type":"post","link":"https:\/\/coimbatorewebhosting.com\/blog\/easy-way-to-optimize-the-wordpress-data-base\/","title":{"rendered":"Easy way to optimize the WordPress Data base."},"content":{"rendered":"<h3><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-806\" src=\"https:\/\/www.coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/optimize.png\" alt=\"\" width=\"857\" height=\"529\" srcset=\"https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/optimize.png 857w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/optimize-300x185.png 300w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/optimize-768x474.png 768w\" sizes=\"auto, (max-width: 857px) 100vw, 857px\" \/><\/h3>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/coimbatorewebhosting.com\/blog\/easy-way-to-optimize-the-wordpress-data-base\/#Introduction\" >Introduction:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/coimbatorewebhosting.com\/blog\/easy-way-to-optimize-the-wordpress-data-base\/#Need_of_optimization_-_word_press\" >Need of optimization:- word press<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/coimbatorewebhosting.com\/blog\/easy-way-to-optimize-the-wordpress-data-base\/#How_to_Optimize_WordPress_database\" >How to Optimize WordPress database?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/coimbatorewebhosting.com\/blog\/easy-way-to-optimize-the-wordpress-data-base\/#Key_features_of_WP-optimize_plugin\" >Key features of WP-optimize plugin:-<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/coimbatorewebhosting.com\/blog\/easy-way-to-optimize-the-wordpress-data-base\/#Conclusion\" >Conclusion:<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Introduction\"><\/span>Introduction:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Are you ever optimized your WordPress database? Now its time to do it.<br \/>\nOptimizing your database means clean unwanted data which reduces database size and improve better performance.<\/p>\n<p>Here in this article, we will show you how to easily optimize your WordPress database with one-click.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Need_of_optimization_-_word_press\"><\/span>Need of optimization:- word press<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Since if you are using the <a  href=\"https:\/\/www.coimbatorewebhosting.com\/blog\/steps-to-redirecting-the-url-by-using-htaccess\/\" title=\"wordpress\" alt=\"wordpress\">wordpress<\/a> for a long span,then there is probably a lot of unused data in your database such as post reviews,spam comments,trash,transient options,metadat,etc..and so on.<\/p>\n<p>Cleaning up this unwanted data significantly reduces your WordPress database size, which means faster backups, easier restore, and improved database performance.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_Optimize_WordPress_database\"><\/span>How to Optimize WordPress database?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Since you will be working on your WordPress database, you have to make sure that you create a complete WordPress backup before moving forward.<\/p>\n<p>And the Next step, you need to install and activate the WP-Optimize plugin.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Key_features_of_WP-optimize_plugin\"><\/span>Key features of WP-optimize plugin:-<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Removes all unnecessary data (e.g. trashed\/unapproved\/spam comments, stale data) plus ping backs, trackbacks and expired transient options<\/li>\n<li>Compact\/de-fragment MySQL tables with a smart button-press<\/li>\n<li>Detailed control of which optimizations you wish to carry out<\/li>\n<li>Carries out automatic weekly (or otherwise) clean-ups<\/li>\n<li>Retains a set number of weeks\u2019 data during clean-ups<\/li>\n<li>Performs optimizations without the need for running manual queries<\/li>\n<li>Automatically trigger a pre-optimize backup via UpdraftPlus (https:\/\/updraftplus.com)<\/li>\n<li>Show database statistics and potential savings<\/li>\n<li>Mobile friendly and easy-to-use.<\/li>\n<li>Guide to <a  href=\"https:\/\/www.coimbatorewebhosting.com\/blog\/easy-way-to-config-local-mail-server-using-post-fix-dovecot-and-squirrel-mail-on-cent-os-6\/\" title=\"Install\" alt=\"Install\">Install<\/a> the Wp-optimize:-<\/li>\n<\/ul>\n<p>There are different ways to install the WP-Optimize as with any ohter wordpress.org plugins<\/p>\n<p>The best easiest and simple way is through wordpress admin dashboard.<\/p>\n<p>Using the <a  href=\"https:\/\/www.coimbatorewebhosting.com\/blog\/easy-steps-to-install-and-configure-lamp-in-centos-7\/\" title=\"WordPress\" alt=\"WordPress\">WordPress<\/a> dashboard<\/p>\n<ul>\n<li>Navigate to the \u2018Add New\u2019 in the plugins dashboard<\/li>\n<li>Search for \u2018WP-Optimize\u2019<\/li>\n<li>Click \u2018Install Now\u2019<\/li>\n<\/ul>\n<p>Activate the plugin on the Plugin dashboard<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-764\" src=\"https:\/\/www.coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/wp-admin.jpg\" alt=\"\" width=\"1355\" height=\"661\" srcset=\"https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/wp-admin.jpg 1355w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/wp-admin-300x146.jpg 300w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/wp-admin-768x375.jpg 768w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/wp-admin-1024x500.jpg 1024w\" sizes=\"auto, (max-width: 1355px) 100vw, 1355px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>After activating the plugin You will see a list of operations that the plugin will perform on your database.<\/p>\n<p>Read them carefully and un check any item that you don\u2019t want to run at the moment.<\/p>\n<p>Items marked in red require more intensive database operations. If the process is interrupted during the operation, then it may corrupt data.<\/p>\n<p>That\u2019s the reason we strongly recommend that you create a backup of your website before selecting the items in red.<\/p>\n<p>After selecting the items, click on \u2018Run on all selected items\u2019 button at the top.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-765\" src=\"https:\/\/www.coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/optimize.jpg\" alt=\"\" width=\"1356\" height=\"651\" srcset=\"https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/optimize.jpg 1356w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/optimize-300x144.jpg 300w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/optimize-768x369.jpg 768w, https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/optimize-1024x492.jpg 1024w\" sizes=\"auto, (max-width: 1356px) 100vw, 1356px\" \/><\/p>\n<p>The plugin will now start optimizing your WordPress database and show you the progress.<\/p>\n<p>That\u2019s all, you have successfully optimized your WordPress database.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The database MYSQL (the database that WordPress uses) will run, over time, become inefficient as data is added, removed, moved around.<\/p>\n<p>Asking MySQL to optimize its database every now and again will keep your site running as fast as possible.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: Are you ever optimized your WordPress database? Now its time to do it. Optimizing your database means clean unwanted data which reduces database size and improve better performance. Here in this article, we will show you how to easily optimize your WordPress database with one-click. Need of optimization:- word [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":806,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[],"class_list":["post-763","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2017\/12\/optimize.png","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pa2YU7-cj","_links":{"self":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts\/763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/comments?post=763"}],"version-history":[{"count":0,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts\/763\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/media\/806"}],"wp:attachment":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/media?parent=763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/categories?post=763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/tags?post=763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}