WP Cleaner Pro is an easy to use plugin that cleans and optimizes your WordPress database, making your website much more faster.
This is the only plugin of this type which can clean 26 types of orphan and obsolete database data, also which can optimize the database, everything at once or in a scheduled event. Clean user interface, no back-end errors, optimized for speed. This plugin is developed for WordPress single-site installations, it is not working with multi-site.

FEATURES

  • The plugin cleans:

    1. Trash comments
    2. Spam comments
    3. Waiting for moderation comments
    4. Orphan comment meta
    5. Duplicated comment meta
    6. Pingbacks
    7. Trackbacks
    8. Drafts
    9. Auto-drafts
    10. Revisions
    11. Trash posts
    12. Orphan post meta
    13. Duplicated post meta
    14. Orphan term relationships
    15. Unused terms
    16. Duplicated term meta
    17. Expired transients
    18. Orphan user meta
    19. Duplicated user meta
    20. Subscribers with invalid email
    21. Weird characters from posts
    22. Weird characters from comments
    23. Comment agent from comments
    24. oEmbed caches from posts meta
    25. Links in wp_links table
    26. Orphan tables
  • Scheduled cleaning of the WordPress database.
  • Background optimization of the WordPress database.
  • Backup of the WordPress database (create/download/delete backups).
  • Cleaning process is logged.
  • Logs can be seen and deleted.
  • Mobile-friendly admin dashboard.
  • 26 types of data that can be cleaned.
  • View details of what you clean.
  • Choose items to clean.
  • Filter items to clean.
  • Code checked with PHP CodeSniffer.
  • Code developed according to WP coding standards.
  • Automatic updates with Envato Market WP Plugin.
  • Code optimized for speed.
  • Mobile-friendly documentation.
  • Translation ready (English .mo and .po included).

WordPress Admin DEMO

Demo: https://hevada.com/wordpress/wp-login.php
Username: Demo
Password: 4Q&1k)ZrQjg0VgAdkWCGM)eq

DOCUMENTATION

https://hevada.com/wordpress/wp-content/plugins/wp-cleaner-pro/documentation/

CHANGELOG

7 January 2023 (version 5.0)
- fixed the way translated texts are processed.
- added frontend datatables for faster display.
- added pagination for tables.
- added search field for tables.
- added sorting capability for tables.
- replaced backend cleaning calls with Ajax calls.
- added back to top button.
- various CSS fixes and improvements. 

 26 June 2020 (version 3.8)
- removed the innodb_stats_on_metadata SQL statement because it caused errors on some restrictive web hosts.
- fixed a bug where the backups were removed on plugin deactivation.

2 January 2019 (version 3.7)
- fixed a slow query when getting orphan tables.
- fixed a bug with an array of tables being empty in a particular rare case.
- reordered the order of cleaning items so that orphan data (comments, users, etc) are deleted in the end, to avoid leftovers.
- made in the Details tab the table header fixed for a better readability.
- fixed the database charset in the generated backup file.

21 December 2019 (version 3.6)
- created alternated rows for better integration with WP UI.
- changed the "view" icon in the Clean tab with a more suggestive one from Dashicons list.
- fixed the error thrown when the list of orphan tables was empty.

17 December 2019 (version 3.5)
- removed the JavaScript confirm box for a more friendly UI.
- fixed an incompatibility with Wordfence plugin. 
15 December 2018 (version 3.4)
- fixed the bug with some texts not being picked up by translations tools
- added option to clean orphan tables
- fixed the default charset encoding when creating backup
- updated class-envato-market (for automatic updates)
- fixed the warnings generated by CodeSniffer according to the new set of WordPress coding standards
15 June 2018 (version 3.3)
- added protection to backups directory against public listing/download 
28 May 2018 (version 3.2)
- optimized the fonts loading
- optimized the progress bar 
9 May 2018 (version 3.1)
- added Envato Market plugin support
- ignore coding standards when trying to raise PHP limits
- ignore logs size when calculating database size
- clean old logs before starting a cleaning
- updated translation files 
15 March 2018 (version 3.0)
- added ignore warnings to ini_get, ini_set and ini_restore (needed for some hosting providers)
6 March 2018 (version 2.0)
- added raise of time limits to the main form
- extracted raise/restore time limits to an utility method
- disabled Pace loader for Ajax requests (as it is not necessary).
7 February 2018 (version 1.0)
- first version