I know there are existing buggy plugins out there or plugins which are upto date but not multisite ready an with no immediate plans to update it anytime soon.
I know you guys are always looking for amazing ways to keep people subscribing to your service and this would certainly be another incentive!
Every-time a theme or plugin is installed so is more crap to the DB tables, some plugins and themes have nice remove DB buttons or uninstall DB Hooks but the sad fact is that many don't and most developers don't seem to care much about it either or that seems to be the general consensus I've seen ESPECIALLY IN THE its FREE so stop your bitching market (Same people that complain about GPL and commercial *Sigh..... Yawn*).
So I put it to you that you consider a new plugin which would be smart and help maintain a multisites DB and infrastructure. Learn how to remove unused tables for plugins and themes, one might say "what if a cron runs and removes a theme or plugins options but the user would simply experimenting" have this new plugin register install and uninstall dates, if the plugin or theme has been uninstalled for X (admin defined) days then remove it, even have it send the webmaster an e-mail (or not) X (admin set) days before removal advising them of a DB cleanse and that their plugin or theme DB entries will be removed unless activated again and left or deactivated which would reset it for another X (admin set) days, weeks, months, year thus ensuring user data is not lost without giving the user a chance to save it.
Perhaps when uninstalling a theme or plugin it could give the end user/webmaster an option to remove the data associated with it and warn them that if they take no action now then in X days, weeks, months, year it will be removed by the system, obviously it would be a little more polite and user friendly, terming it as a way to help keep the website efficient and optimised. :slight_smile:
Other great ideas could be borrowed from: http://wordpress.org/extend/plugins/wp-optimize/ (not MU friendly)
Restrict post revisions (can currently be set in wp-config)
Remove the WordPress post revisions (after X days, weeks, months, year of age)
Remove the WordPress auto draft posts (after X days, weeks, months, year of age)
Remove all the comments in the spam queue (after X days, weeks, months, year of age)
Remove all the un-approved comments (after X days, weeks, months, year of age)
Rename one username to another username, it's designed to rename default "Admin" user to something else
Display Database table statistics. Shows how much space can be optimzied and how much space has been cleared.
Apply mysql optimize commands on your database tables without phpMyAdmin. (pre-set commands or buttons could be included):
- Delete All Pingbacks
- Clean Out Unused Tags
(That list of features is from WP Optimised with my remarks tags on the end)
Other plugins to consider features from:
I find it hard to understand that after years of complaints about issues relating DB bloat that more hasn't been done to tackle the issue to be honest.
I hope this is something you guys would consider for the near future, it would help so many out and give yet another reason for people to subscribe. :wink:
Thanks for reading!