My blog is filled with comments spam as pending comments. The spamming is so serious that the spam filled up the database very quickly, causing it’s overall size to exceed the account limit.

I initially used manual methods to delete pending comments into trash, and clearing trash permanently. But I quickly realized that the manual method will take too long.

I searched and used the good plugin called “delete pending comments”, so aptly named after what I want to do. Installed it and deleted all pending comments. But the overall size of the database still remained very high. Then I found the commentmeta table is unusually high.

I followed this post to reduce the size of the table.

http://www.webmaster.net/clean-wordpress-comment-meta-table-get-rid-akismet-meta-and-table-overhead

Specifically this SQL comment:

DELETE FROM tableprefix_commentmeta WHERE meta_key LIKE "%akismet%"

One day I will need to upgrade the blog to the latest version.

  • Digg
  • del.icio.us
  • StumbleUpon
  • Sphinn
  • Facebook
  • Mixx
  • Google Bookmarks
  • Haohao
  • LinkedIn
  • Live
  • MyShare
  • MySpace
  • Reddit
  • Technorati
  • TwitThis

Related posts:

  1. False Alarm: WP-Print Got to Work After All
  2. Top 20 Movers Among WordPress Plugins – Week of September 13, 2009
  3. Why a Database Restore Does not Completely Clean It Up
  4. Top 20 Movers of WordPress Plugins Week of September 7, 2009
  5. A Few Plugins to Add Visual Pizzazz to Your WordPress Sites

Tags: , , ,

Comments are closed.