{"id":1944,"date":"2014-12-24T04:52:23","date_gmt":"2014-12-24T04:52:23","guid":{"rendered":"http:\/\/www.vishmax.com\/en\/?p=1944"},"modified":"2014-12-24T05:02:34","modified_gmt":"2014-12-24T05:02:34","slug":"best-wordpress-plugins-to-cleanup-and-optimize-database","status":"publish","type":"post","link":"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/","title":{"rendered":"Best WordPress Plugins to Cleanup, Optimize DB"},"content":{"rendered":"<p><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.vishmax.com\/en\/innovattive-cms\/uploads\/2014\/12\/wp-db-cleanup.jpg\" alt=\"wp-db-cleanup\" width=\"600\" height=\"236\" class=\"alignnone size-full wp-image-1948\" srcset=\"https:\/\/www.vishmax.com\/en\/wp-content\/uploads\/2014\/12\/wp-db-cleanup.jpg 600w, https:\/\/www.vishmax.com\/en\/wp-content\/uploads\/2014\/12\/wp-db-cleanup-400x157.jpg 400w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<h2>WP-Optimize<\/h2>\n<p>WP-Optimize is an extensive WordPress database cleanup and optimization tool. It doesn&#8217;t require PhpMyAdmin to clean and optimize your database tables. The requirements to install this plugin is WordPress 3.8+, PHP 5.1.xx and MySql 5.1.xx.<br \/>\n<strong>How this could help you?<\/strong><\/p>\n<ul>\n<li>\n\tEvery-time you save a new post or pages, WordPress creates a revision of that post or page. If you edit a post 6 times you might have 5 copy of that post as revisions. Imagine if your post or pages are long and big. It is a huge number of bytes that&#8217;s on your MySQL overhead. Now WP-Optimize allows you to optimize and shrink your posts table by removing not necessary post revisions from the database. As example, if you have a post which is approximately 100KB data and you have 5 revisions of that post, the total space wasted is about 500KB. And if you have 100 posts similar to it, you have 50MB database space wasted.\n\t<\/li>\n<li>\n\tSimilar to the scenario described above, there might be thousands of spam and un-approved comments in your comments table, WP-Optimize can clean and remove those in a single click\n\t<\/li>\n<li>\n\tWP-Optimize reports which database tables have overhead and wasted spaces also it allows you to shrink and get rid of those wasted spaces\n\t<\/li>\n<li>\n\tAutomatically cleans database every week and respects the &#8220;Keeps selected number of weeks data&#8221; option.\n\t<\/li>\n<\/ul>\n<p><a class=\"external-download\" href=\"https:\/\/wordpress.org\/plugins\/wp-optimize\/\" target=\"_blank\">Download<\/a><\/p>\n<h2>P3 (Plugin Performance Profiler)<\/h2>\n<p>This plugin creates a profile of your WordPress site&#8217;s plugins&#8217; performance by measuring their impact on your site&#8217;s load time.  Often times, WordPress sites load slowly because of poorly configured plugins or because there are so many of them. By using the P3 plugin, you can narrow down anything causing slowness on your site.<\/p>\n<p>This plugin uses the canvas element for drawing charts and requires requires Firefox, Chrome, Opera, Safari, or IE9 or later. This plugin will not work in IE8 or lower.<\/p>\n<p>The requirements to install this plugin is 3.3 or higher and compatible up to: 4.1<\/p>\n<p><a class=\"external-download\" href=\"https:\/\/wordpress.org\/plugins\/p3-profiler\/\" target=\"_blank\">Download<\/a><\/p>\n<h2>WP Clean Up<\/h2>\n<p>WP Clean Up can help us to clean up the wordpress database by removing &#8220;revision&#8221; &#8220;draft&#8221; &#8220;auto draft&#8221; and so on.<br \/>\nIt allows you to optimize your WordPress database without phpMyAdmin. It adds a settings page to &#8220;Dashboard&#8221;->&#8221;Settings&#8221;->&#8221;WP Clean Up&#8221; where you can clean up the wordpress database. It allows you to remove the redundant data within few clicks. It is a effective tool to keep your database clean and surely save a lot of space of your MySQL Database.<br \/>\nThe requirements to install this plugin is 2.7 or higher and compatible up to: 3.9.2<\/p>\n<p><a class=\"external-download\" href=\"https:\/\/wordpress.org\/plugins\/wp-clean-up\/\" target=\"_blank\">Download<\/a><\/p>\n<h2>Optimize Database after Deleting Revisions<\/h2>\n<p>This plugin is a &#8216;One Click&#8217; WordPress Database Cleaner \/ Optimizer. It have features like Deletes redundant revisions of posts and pages,Deletes trashed posts, pages and comments, Deletes spammed comments, Deletes unused tags, Deletes &#8216;orphan postmeta items&#8217;, Deletes &#8216;expired transients&#8217;, Optimizes the database tables etc.<br \/>\nThe requirements to install this plugin is 2.8 or higher and compatible up to: 4.1<\/p>\n<p><a class=\"external-download\" href=\"https:\/\/wordpress.org\/plugins\/rvg-optimize-database\/\" target=\"_blank\">Download<\/a><\/p>\n<h2>WP-DBManage<\/h2>\n<p>Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop\/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.<br \/>\nThe requirements to install this plugin is 3.9 or higher and compatible up to: 4.1<\/p>\n<p><a class=\"external-download\" href=\"https:\/\/wordpress.org\/plugins\/wp-dbmanager\/\" target=\"_blank\">Download<\/a><\/p>\n<p>Disclaimer<br \/>\nNO WARRANTY, USE IT AT YOUR OWN RISK!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WP-Optimize WP-Optimize is an extensive WordPress database cleanup and optimization tool. It doesn&#8217;t require PhpMyAdmin to clean and optimize your database tables. The requirements to install this plugin is WordPress 3.8+, PHP 5.1.xx and MySql 5.1.xx. How this could help you? Every-time you save a new post or pages, WordPress creates a revision of that [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1947,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[92,49],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Best WordPress Plugins to Cleanup, Optimize DB - Vishmax.com<\/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.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Best WordPress Plugins to Cleanup, Optimize DB - Vishmax.com\" \/>\n<meta property=\"og:description\" content=\"WP-Optimize WP-Optimize is an extensive WordPress database cleanup and optimization tool. It doesn&#8217;t require PhpMyAdmin to clean and optimize your database tables. The requirements to install this plugin is WordPress 3.8+, PHP 5.1.xx and MySql 5.1.xx. How this could help you? Every-time you save a new post or pages, WordPress creates a revision of that [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Vishmax.com\" \/>\n<meta property=\"article:published_time\" content=\"2014-12-24T04:52:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-12-24T05:02:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vishmax.com\/en\/wp-content\/uploads\/2014\/12\/wp-db-cleanup400x230.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"230\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/www.vishmax.com\/en\/#\/schema\/person\/785fa94b56eb17ae7706d30777d6ab93\"},\"headline\":\"Best WordPress Plugins to Cleanup, Optimize DB\",\"datePublished\":\"2014-12-24T04:52:23+00:00\",\"dateModified\":\"2014-12-24T05:02:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/\"},\"wordCount\":555,\"publisher\":{\"@id\":\"http:\/\/www.vishmax.com\/en\/#organization\"},\"keywords\":[\"Blogging Tips\",\"WordPress\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/\",\"url\":\"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/\",\"name\":\"Best WordPress Plugins to Cleanup, Optimize DB - Vishmax.com\",\"isPartOf\":{\"@id\":\"http:\/\/www.vishmax.com\/en\/#website\"},\"datePublished\":\"2014-12-24T04:52:23+00:00\",\"dateModified\":\"2014-12-24T05:02:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/www.vishmax.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Best WordPress Plugins to Cleanup, Optimize DB\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.vishmax.com\/en\/#website\",\"url\":\"http:\/\/www.vishmax.com\/en\/\",\"name\":\"Vishmax.com\",\"description\":\"Software Company in Calicut for Web Design and eCommerce\",\"publisher\":{\"@id\":\"http:\/\/www.vishmax.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.vishmax.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/www.vishmax.com\/en\/#organization\",\"name\":\"Vishmax.com\",\"url\":\"http:\/\/www.vishmax.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/www.vishmax.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vishmax.com\/en\/wp-content\/uploads\/2023\/03\/logo-vishmax.png\",\"contentUrl\":\"https:\/\/www.vishmax.com\/en\/wp-content\/uploads\/2023\/03\/logo-vishmax.png\",\"width\":150,\"height\":50,\"caption\":\"Vishmax.com\"},\"image\":{\"@id\":\"http:\/\/www.vishmax.com\/en\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"http:\/\/www.vishmax.com\/en\/#\/schema\/person\/785fa94b56eb17ae7706d30777d6ab93\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/www.vishmax.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e218268870406c917d20b442936d9e68?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e218268870406c917d20b442936d9e68?s=96&d=monsterid&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.vishmax.com\/en\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Best WordPress Plugins to Cleanup, Optimize DB - Vishmax.com","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.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/","og_locale":"en_US","og_type":"article","og_title":"Best WordPress Plugins to Cleanup, Optimize DB - Vishmax.com","og_description":"WP-Optimize WP-Optimize is an extensive WordPress database cleanup and optimization tool. It doesn&#8217;t require PhpMyAdmin to clean and optimize your database tables. The requirements to install this plugin is WordPress 3.8+, PHP 5.1.xx and MySql 5.1.xx. How this could help you? Every-time you save a new post or pages, WordPress creates a revision of that [&hellip;]","og_url":"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/","og_site_name":"Vishmax.com","article_published_time":"2014-12-24T04:52:23+00:00","article_modified_time":"2014-12-24T05:02:34+00:00","og_image":[{"width":400,"height":230,"url":"https:\/\/www.vishmax.com\/en\/wp-content\/uploads\/2014\/12\/wp-db-cleanup400x230.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/#article","isPartOf":{"@id":"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/"},"author":{"name":"admin","@id":"http:\/\/www.vishmax.com\/en\/#\/schema\/person\/785fa94b56eb17ae7706d30777d6ab93"},"headline":"Best WordPress Plugins to Cleanup, Optimize DB","datePublished":"2014-12-24T04:52:23+00:00","dateModified":"2014-12-24T05:02:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/"},"wordCount":555,"publisher":{"@id":"http:\/\/www.vishmax.com\/en\/#organization"},"keywords":["Blogging Tips","WordPress"],"articleSection":["Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/","url":"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/","name":"Best WordPress Plugins to Cleanup, Optimize DB - Vishmax.com","isPartOf":{"@id":"http:\/\/www.vishmax.com\/en\/#website"},"datePublished":"2014-12-24T04:52:23+00:00","dateModified":"2014-12-24T05:02:34+00:00","breadcrumb":{"@id":"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vishmax.com\/en\/blog\/best-wordpress-plugins-to-cleanup-and-optimize-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.vishmax.com\/en\/"},{"@type":"ListItem","position":2,"name":"Best WordPress Plugins to Cleanup, Optimize DB"}]},{"@type":"WebSite","@id":"http:\/\/www.vishmax.com\/en\/#website","url":"http:\/\/www.vishmax.com\/en\/","name":"Vishmax.com","description":"Software Company in Calicut for Web Design and eCommerce","publisher":{"@id":"http:\/\/www.vishmax.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.vishmax.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/www.vishmax.com\/en\/#organization","name":"Vishmax.com","url":"http:\/\/www.vishmax.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.vishmax.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.vishmax.com\/en\/wp-content\/uploads\/2023\/03\/logo-vishmax.png","contentUrl":"https:\/\/www.vishmax.com\/en\/wp-content\/uploads\/2023\/03\/logo-vishmax.png","width":150,"height":50,"caption":"Vishmax.com"},"image":{"@id":"http:\/\/www.vishmax.com\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"http:\/\/www.vishmax.com\/en\/#\/schema\/person\/785fa94b56eb17ae7706d30777d6ab93","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/www.vishmax.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e218268870406c917d20b442936d9e68?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e218268870406c917d20b442936d9e68?s=96&d=monsterid&r=g","caption":"admin"},"url":"https:\/\/www.vishmax.com\/en\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.vishmax.com\/en\/wp-json\/wp\/v2\/posts\/1944"}],"collection":[{"href":"https:\/\/www.vishmax.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vishmax.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vishmax.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vishmax.com\/en\/wp-json\/wp\/v2\/comments?post=1944"}],"version-history":[{"count":0,"href":"https:\/\/www.vishmax.com\/en\/wp-json\/wp\/v2\/posts\/1944\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vishmax.com\/en\/wp-json\/wp\/v2\/media\/1947"}],"wp:attachment":[{"href":"https:\/\/www.vishmax.com\/en\/wp-json\/wp\/v2\/media?parent=1944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vishmax.com\/en\/wp-json\/wp\/v2\/categories?post=1944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vishmax.com\/en\/wp-json\/wp\/v2\/tags?post=1944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}