null
If you have been using WordPress for a while, then you should think absolutely about a cleanup. Indeed, your database may be full of garbage that makes your site sluggish and bloated, such as revisions, drafts, spam comments, orphan options, orphan tables, etc. You should clean this unnecessary data to reduce the size of your database and improve efficiency when accessing tables. In addition, your backup files will be quicker and smaller.
- Clean up Posts Table
- Delete old revisions of posts and pages,
- delete old auto drafts & delete trash posts. This will help reducing the size of your “posts” table
- Clean up Comments Table
- Delete pending comments, spam comments, trash comments, pingbacks and trackbacks. This will reduce the number of rows in your “comments” table
- Clean up Orphaned Metadata
- Delete orphan post metadata, orphan comment metadata, orphan user metadata, orphan term metadata and orphan relationships
- Clean up Expired Transients
- Expired transients are temporary options that should not exist in your database since they are expired
- Display & View Orphaned Items
- View details about orphaned item before making a database clean-up so you can be sure about what you are going to clean-up
- Keep Last x Days’ Data
- You can keep the last x days’ data from being cleaned and clean up only data older than the number of days you have specified
- View & Manage Tables
- Display tables information such as the number of rows, table size, etc. Optimize tables & repair corrupted ones. You can also empty and delete tables if needed
- View & Manage Options
- Display all options list and options information such as name, value, size, autoload, etc. Set options autoload to no/yes and delete options if needed
- View & Manage Cron jobs
- Display active cron tasks list (scheduled tasks) with their information such as arguments, next run, etc. Clean and delete scheduled tasks
- Get and overview
- The plugin will help you get a clear idea of what is happening in your database. It will report all unused/orphaned items that should be cleaned
- Scheduling
- The plugin will automate the process and run a cleanup/optimization automatically based on your settings. No need to do it manually each time
- Reduce DB size
- By deleting unused/orphaned items, you will save space in your database and make quicker backups since the file of your backup will be smaller
Demo : https://sigmaplugin.com/downloads/wordpress-advanced-database-cleaner
Changelog
= 3.2.9 – 07/04/2024 =
Fix: a bug that may prevent the scan from completing
Compatibility: tested with the latest version of WordPress 6.5
= 3.2.8 – 07/02/2024 =
Scan: some options were incorrectly categorized
Scan: taking new options into consideration in the scan process
= 3.2.7 – 23/01/2024 =
Security: enhancing the security by avoiding deserialization (thanks to Richard Telleng from Wordfence)
Fix: endless scan reloading
Fix: warning PHP: Implicit conversion from float to int
Tweak: some code cleanup
= 3.2.3 – 12/09/2023 =
Security: enhanced the security by sanitizing some parameters
Fix: fixed 'Constant FILTER_SANITIZE_STRING is deprecated in PHP 8'
Fix: fixed 'Undefined property : stdClass::$data_free'
Fix: fixed 'PHP Fatal error: Uncaught TypeError: date(): Argument #2 ($timestamp) must be of type ?int'
Tweak: better handling of nonces
Compatibility: tested with the latest version of WordPress 6.3.1
