Have you removed Disqus? Now it’s Time to Clean up Comment Metadata

Disqus is a very powerful WordPress commenting system. I’m using it on Crunchify.com since long time and found it very effective. Sometimes people switch between their comment system. Below are few options available for WordPress Comment system.

• Disqus
• LiveFyre
• WordPress.com Comment System (Comes with Jetpack)
• Theme’s default Comment System

When you sync your comment systems, above tool adds respective metadatas to your wp_commentmeta table. I’ve published one article long time back on how to clean up all transient variable from wp_options table.

Below steps will help you clean this table:

1) Open phpMyAdmin from your cPanel.

2) Select your Database and Click on wp_commentmeta table. Click on “Search” button.

3) Enter dsq_ as mentioned below.

Another must read: 

• Genesis Framework: How to Display Number of Comments in Comment Header Text

4) Select all and click Delete. Click Go Button.

5) Now let’s work on table wp_options.

Follow the same above flow and search for “disqus” values from table as mentioned below.

Let me know if you have any better way to clean these all metadata. This will help our blog running very fast.

Would love to know what you think. Chime in and share it as a comment. Don’t forget to share this guide!