Clearing out wp_commentmeta

  • Resolved onthewight

    (@onthewight)


    4 years, 2 months ago

    It seems that Akismet (as wonderful as it is) created a entry in wp_commentmeta every time it checks a comment. I’ve got over 500k entries in wp_commentmeta now – which is a pretty crazy size (the site has a lot of comments).

    Am I safe deleting the Akisment-realted rows as multiple articles online suggest? (example)

    If so, what the best and safest way?

Viewing 2 replies - 1 through 2 (of 2 total)
  • briancolinger

    (@briancolinger)

    4 years, 2 months ago

    Howdy! Thanks for bringing this up!
    I checked the article you linked to and I think it would be safe to delete the commentmeta rows that are prefixed with ‘akismet_%’.
    I’ve used a similar method mentioned in the article by running the SQL delete queries using a tool like phpMyAdmin.
    I should mention that it is ALWAYS a good idea to make a backup of the table before running any delete queries.
    After deleting a massive amount of data from a table, you may want to run an OPTIMIZE TABLE query to reclaim the disk space if you are using the myisam engine. The process for reclaiming disk space with innodb tables is a bit different.
    Hope this helps!
    -Brian

    Thread Starter onthewight

    (@onthewight)

    4 years, 2 months ago

    Thanks for taking the time to respond Brian.

    It’s confidence inspiring to know that the actual author of the plugin says it’s OK.

    Much appreciated.

    Simon

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Clearing out wp_commentmeta’ is closed to new replies.