412 pointsWPMU DEV ExpertI'm helpful
Christopher Price
Member
—
16th January 2012
I have been running one of my networks for about a year. Splog signups vs Legit are about 100:1 despite using the antisplog plugin and recaptcha. Periodically, I manually go on a slash-and-burn campaign to spam any blog that looks fishy to me. At that rate I've built up a database of 181523 mostly worthless tables. That would be fine with me if it didn't affect performance.
I tried to do an export of the database and found the process moving VERY slowly, so I asked my host to help. After 16 HOURS they report:
As of now only 12M data has been fetched in the SQL dump file. I am running it with an option to use only one table at a time.
I'm no db admin, but this seems out of line to me. Is there some sort of maintenance I should be doing on the database to keep my database clean and spry?
I have been running one of my networks for about a year. Splog signups vs Legit are about 100:1 despite using the antisplog plugin and recaptcha. Periodically, I manually go on a slash-and-burn campaign to spam any blog that looks fishy to me. At that rate I've built up a database of 181523 mostly worthless tables. That would be fine with me if it didn't affect performance.
I tried to do an export of the database and found the process moving VERY slowly, so I asked my host to help. After 16 HOURS they report:
As of now only 12M data has been fetched in the SQL dump file. I am running it with an option to use only one table at a time.
I'm no db admin, but this seems out of line to me. Is there some sort of maintenance I should be doing on the database to keep my database clean and spry?
If you have the ID numbers of those spam sites you could quite easily generate a script which would loop through your database deleting tables relevant to those sites.
I don't think doing so would have an adverse impact, but I can't guarantee it either.
If possible you should do a mysqldump direct to a separate database that you can use as a sandbox to test the proceedure first.
Responses (1)
Sales & Support Pro — 17th January 2012 #
Hiya!
If you have the ID numbers of those spam sites you could quite easily generate a script which would loop through your database deleting tables relevant to those sites.
I don't think doing so would have an adverse impact, but I can't guarantee it either.
If possible you should do a mysqldump direct to a separate database that you can use as a sandbox to test the proceedure first.
Thanks,
Phil
Become a member