=== Database Cleaner (New 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: 5.9.1 Requires PHP: 7.0 Stable tag: 0.2.2 Clean your database for real, whatever its size is, while focusing on what can make it faster. == Description == Clean your database for real, whatever its size is, while focusing on what can make it faster. An user-friendly UI will help you to make everything perfect. If there are too many issues to delete, it will use asynchronous requests to avoid timeouts. You will more information here: [Database Cleaner on Meow Apps](https://meowapps.com/database-cleaner/). == Features == There are others database cleaners on the market, but since I felt like there were rather incomplete and old, based on my experiences with modern UIs and ways of coding plugins, I had to create this new one. Here are the current features: - **The Clean DB Button**. It will clean everything you set on Auto in Database Cleaner. That will make your life easier, once everything is set up. - **Clean the Usual Items**: Revisions, drafts, trash, useless metas, useless comments, useless users, transients, etc. If I missed something, let me know: I can add support for new items right away. - **Clean your Post Types**. List your post types, and help you getting rid of data in unimportant post types such as the ones used for temporary data such as logs. Those slow down your WordPress more than anything else! - **Clean your Tables**. Display all your tables, their sizes, and help you getting rid of the useless ones. - **Clean your Options**. Display all your options, their sizes, and help you getting rid of the useless ones. You can also set your options as being not autoloaded. ***For Post Types, Tables and Options, Database Cleaner has its own references in order to tell you by which plugins or themes they are use. For full support of this, you will need the Pro Version.*** **IMPORTANT:** Please prepare a backup of your database before using this plugin! Better be safe than sorry :) == Why this plugin? == There are other similar cleaners on the market. I used them, but I always felt they were imperfect, with old UI, somehow frozen in time. There were also missing Post Types support, but I could handle this manually. At the end of 2021, I had issues with my databases (which were too big) and all those plugins simply failed; this was the last straw: I started to develop a fresh and new database cleaner plugin, with a PHP 7 base, modern concepts, and build to actually speed-up WordPress. I am now resolved to make it work for everyone, adding all the features you absolutely need. == Installation == 1. Upload the plugin to WordPress. 2. Activate the plugin through the 'Plugins' menu in WordPress 3. Go to Meow Apps -> DB 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.2.2 (2022/03/11) = * Add: Optimize for tables. * Update: Better UI for Options. * Update: UI enhancements. * Info: The plugin is evolving a lot and very fast, don't hesitate to leave my feedback and requests here: https://wordpress.org/support/plugin/database-cleaner/. Next week, there will be another updates :) = 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.