I recently replied to an issue about site load time from another member. After doing some research I realized that my site load time might be an issue with a bloated MySQL.
A few months ago thousands of splogs (spam blogs) were created on my site. Using myphpadmin I can only drop one table at a time. If I try to drop more than one table I get an error:
“Error in Processing Request
Error code: 500
Error text: Internal Server Error.”
This is a fresh instal (well from a backup sql file), of MySQL on a new server. I was wondering if there is any better way to clean out my database of the spam blogs than dropping one table at a time. It could take me many many hours at this rate. I have about 600 fake blogs at the moment (I do have a list of blog ID’s to keep so I know what tables to avoid).