I'm going to be deleting some plugins that I'm not using in hopes of reducing the strain on CPU and my database. What I am HOPING do do is eliminate databases that no longer are needed, especially for deleted blogs and splogs. The guy who is hosting my server is a wiz for this sort of thing, but I don't want to go to the well to often. Are there are plugins that I cna use to automatically delete this gunk
good plugin. But it doesn't clean out gunk from already-deleted blogs, just those marked as spam. Any other advice?
You might need a script to pick up all the wp_ tables from the information_schema.tables table and then use the wp_users table to exclude the numbers that exist and that can build a drop script.
If it's leftover plugin tables from deleted blogs, I'd go in and do them manually. Long time, yes. eye-bleeding, yes. Safer - yes. :D
And yes, I curse plugins that don't uninstall tables.