=== Database Cleaner and Optimizer (Built for 2022+) === Contributors: TigrouMeow Tags: database, db, clean, cleaner, optimize, table, orphan, draft Donate link: https://meowapps.com/donation/ Requires at least: 5.0 Tested up to: 6.0.1 Requires PHP: 7.0 Stable tag: 0.6.0 Clean and optimize your database, for real! Lot of features, handle oversized databases, built on latest WP and PHP evolutions. == Description == Clean your database for real, whatever its size is! It also focuses on what matters, in order to make your WordPress faster. A friendly and modern UI will help you making everything perfect. If there are too much data to delete, Database Cleaner will use asynchronous requests to process it little by little to avoid errors and timeouts. You'll find more information here: [Database Cleaner](https://meowapps.com/database-cleaner/) on Meow Apps. **IMPORTANT:** Always prepare a backup of your data before using such a plugin! It works well, but it is better be safe than sorry :) == Features == - **Easy** and **Expert** modes. - An **Auto Clean** button. You can choose the items you would like to be automatically cleaned, then this button will do the rest. - Keep an history of your database sizes. - Allow you to look into the data. == What does it clean == The usual, which are: Revisions, Auto-Drafts, Deleted Posts, Orphaned Post Meta, Orphaned Term Meta, Orphaned Term Relationships, oEmbed Caches, Unused Terms, Duplicated Term Meta, Duplicated Post Meta, Orphaned User Meta, Duplicated User Meta, Unapproved Comments, Spammed Comments, Deleted Comments, Orphaned Comments Data, Duplicated Comments Data, Expired, Transients, All Transients. Database Cleaner also gives you specific tools to analyze and check how your data is used for: - Post Types - Tables - Options - Cron Jobs **Database Cleaner use its own references and analysis to figure out by which plugins or themes your data is used. For an even better support of this feature, you will need the Pro Version.** == Why this plugin? == There are other database cleaners. I used them, but I always felt they were imperfect, with old UI, missing features and way to look though the data, and worse, none of them can actually properly handle big databases. So I decided to create my own, and I hope you'll like it. I'll add features while keeping the UI as much as possible. If you need more features, let me know, I am here :) == Installation == 1. Upload the plugin to WordPress. 2. Activate the plugin through the 'Plugins' menu in WordPress 3. Go to Meow Apps -> Database Cleaner in the sidebar and check the appropriate options. 4. Click on the button to clean your database automatically. == Screenshots == 1. No screenshot yet. == Changelog == = 0.6.0 (2022/09/06) = * Update: Update the size of the DB every day automatically. * Update: The UI is now a bit more elegant. * Add: We can now disable the message which is above the dashboard. = 0.5.9 (2022/08/29) = * Fix: The columns weren't aligned properly. * Fix: Tiny technical enhancements to make things smoother. * Info: You are also welcome to leave a review [here](https://wordpress.org/support/plugin/database-cleaner/). = 0.5.8 (2022/08/16) = * Add: Easy/Expert Switch. The plugin now fits two kinds of user. * Update: More UI improvements, we are getting close to perfection!? Let me know! 💕 = 0.5.7 (2022/08/10) = * Fix: It was not possible to select many tables at once. * Fix: Assigning a plugin to a specific cron task wasn't working. * Add: New plugins support. * Update: Little changes in the UI and how it works, should feel natural. = 0.5.6 (2022/08/04) = * Update: Assign Plugin now refreshes the items right away. * Update: Assign Plugin now features a filter to associate to plugins faster. * Update: Better UX when the plugin is busy. = 0.5.5 (2022/07/23) = * Fix: Could not delete or optimize tables without prefix. * Update: Use a button instead of a link to associate an item with a plugin. = 0.5.4 (2022/07/19) = * Add: Now possible to select a range of checkboxes/items by using SHIFT. = 0.5.3 (2022/07/12) = * Fix: There was a little UI issue with the columns. * Add: Deep-Cleaning option for Pro. * Add: We can now see/check all the data of all Posts through paging (by using the glass magnifier icon). = 0.5.1 (2022/06/24) = * Update: My library Neko UI was improved (that will impact the UI positively). = 0.4.9 (2022/06/03) = * Update: Enhanced the loading of the data of the first tab, for a smoother and nicer experience. * Update: Additional support for other plugins. = 0.4.7 (2022/05/25) = * Update: Lot of little UI enhancements. * Update: Additional support for other plugins. = 0.4.6 (2022/05/19) = * Fix: The handling of the _user_roles option was wrong. * Update: Icons have been updated; the trash means some data will be removed, while the cross means the item will be entirely removed (in a case of a table, it means it will be dropped). = 0.4.5 (2022/05/16) = * Update: Better handling of the Used By column with support of regexp. * Update: Little UI enhancements to avoid extra clicks. * Fix: Retrieve better option value for the modal. = 0.4.4 (2022/05/10) = * Add: We can now check what is the data stored by an option. = 0.4.3 (2022/05/03) = * Fix: Better UI for handling the Used By. = 0.4.2 (2022/04/29) = * Fix: Better support for ACF and various other plugins. * Fix: Little UI enhancements to handle the "Used By" data. = 0.4.1 (2022/04/24) = * Add: Support for item used by frameworks. * Fix: Better support for Elementor. * Update: Lot of UI enhancements. More to come next week! = 0.3.9 (2022/04/18) = * Fix: Removed some warnings on the PHP side which were sometimes breaking the asynchronous requests. * Add: We can now copy/paste the whole customized data related to Used By. = 0.3.8 (2022/04/15) = * Add: Sort by name, size, used by, etc. * Add: Search for name, used by, etc. * Fix: There was an issue with the count for transients. * Update: Better filters, improved UI. = 0.3.7 (2022/04/13) = * Add: User can now choose a plugin for the "Used By" column. * Fix: Removed a few warnings and enhanced the filters. = 0.3.6 (2022/04/10) = * Fix: The count was wrong for Post Types. = 0.3.4 (2022/04/08) = * Fix: Better handling of "Used By" overrides (to make sure we get some better information about how an item is used). * Add: Checkbox to hide the items "Used by WordPress". * Add: Paging for Post Types, Tables. * Fix: Statistics were not updated after Auto Clean. * Update: Again, many UI enhancements. = 0.3.0 (2022/04/05) = * Update: Many UI enhancements, buttons were simplified and actions moved on the left (to make it clearer which item it is linked to), smoother busy statuses. * Add: Autoload is now a checkbox (which we can enabled/disabled). = 0.2.9 (2022/03/30) = * Update: Changed the way (and filters) the items can be selected in bulk. = 0.2.8 (2022/03/29) = * Fix: There was some issues with deleting cron jobs. * Fix: Little UI issues. * Update: Possibility to select more than one item at the time. = 0.2.7 (2022/03/22) = * Add: Cron Tabs. = 0.2.6 (2022/03/18) = * Fix: The percentage was sometimes off. * Add: Support for Meow Apps plugins. = 0.2.5 (2022/03/15) = * Add: Ability to see how much the DB increased or decreased over time. * Add: Checkbox to select tables. * Update: Improved UI. = 0.2.4 (2022/03/11) = * Fix: Compatibility with MariaDB. * Add: Optimize for tables. * Update: Better UI for Options. * Update: UI enhancements. = 0.2.1 (2022/03/08) = * Add: Support for "Used By" for WordPress Core, WooCommerce, and the whole system behind it (actions, filters). * Update: Better SQL queries. * Update: Better UI. = 0.1.5 (2022/03/04) = * Add: A way to look into the data which is going to be removed. * Add: More ways to delete in bulk. * Fix: A few UI bugs related to refreshing. * Update: The UI is always evolving! Better and better! (and we are not done) = 0.1.2 (2022/02/21) = * Update: Better buffered deletions. * Update: Dynamicity of the UI has improved a lot. = 0.1.1 (2022/02/15) = * Add: Finally, support for big installs, with buffered deletions! * Update: A bunch of fixes and enhancements. = 0.1.0 (2022/01/26) = * Update: Doesn't work with risk level anymore, but a simpler option. * Update: UI improvements. = 0.0.7 (2022/01/11) = * Add: Logging. * Update: More information about what the plugin is cleaning after clicking the Clean DB button. = 0.0.6 (2021/12/20) = * Update: Nice UI improvements. = 0.0.5 (2021/12/14) = * Add: Support for removing tables, and check by which plugins they are used. * Add: Ignore status for Risk column. * Info: Additional and various enhancements. = 0.0.4 = * Fix: The default Risk Treshold was too high. = 0.0.3 = * Update: Small improvements, tables percentages, etc. = 0.0.2 = * Add: Table statistics. * Update: Improve UI (buttons, organization, etc). = 0.0.1 = * Info: First release.