Donaldson R F
WordPress
Clean Spam Comments & Optimise WP Database
Clear out spam comments in bulk and tidy up the database bloat they leave behind.
The Problem
Thousands of spam comments (even held in moderation) bloat your database and slow down admin screens, and manually deleting them one by one isn't a realistic option.
About this problem
Spam comments are stored as rows in the comments table, with matching metadata, even when they are never shown. Sites without effective filtering can collect tens of thousands, which slows the comments screen, increases the database size and backup time, and makes real comments hard to find. Deleting them from the dashboard works only a page at a time.
People usually look for this when the admin becomes slow, the pending comments counter shows a huge number, or backups have unexpectedly grown. Many also want the problem to stop recurring.
What's Included
- Bulk removal of spam/pending comments that are clearly not genuine
- Reviewing and tightening comment spam filtering (Akismet or similar) going forward
- Database cleanup and table optimisation afterwards
- Confirming genuine comments weren't affected
What's NOT Included
- Moderating genuinely ambiguous comments — those get left for your review
- Setting up a comment system replacement
- General database optimisation unrelated to comments (separate service)
How It Works
- I take a database backup and count comments by status to see how many are spam, pending, trashed and approved.
- I identify clearly spam content by status and patterns such as links, repeated text and known spam sources.
- I remove those in bulk using direct database queries or WP-CLI, together with their orphaned comment metadata.
- I leave ambiguous comments in the moderation queue for you to review.
- I review the spam filtering setup, for example Akismet or similar, and discussion settings such as moderation rules and link limits.
- I optimise the comment-related tables and confirm approved comments were not affected.
In practice: you buy the service, send over whatever access or details the job needs, I investigate and do the work, and you confirm it's resolved before we call it done.
Frequently Asked Questions
- How do I delete thousands of spam comments in WordPress?
- Bulk removal using database queries or WP-CLI is far quicker than the dashboard. I back up first, and remove only clear spam.
- Will genuine comments be deleted?
- No. Approved comments are left alone, and anything ambiguous stays for you to review.
- How do I stop the spam coming back?
- I review and tighten the filtering, for example Akismet and discussion settings. No filter is perfect, but it reduces the volume substantially.
- Do you replace my comment system?
- No, setting up a replacement comment system is excluded.
- Is general database optimisation included?
- Only the tables related to comments. Wider database cleanup is a separate service.
- Will this speed up my site?
- It usually makes the admin faster and shrinks the database, but a visible effect on the front end depends on the site.