Disqus is (was) a very powerful WordPress commenting system. We were using it on Crunchify.com since long time and found it very effective until recently.
Sometimes people switch between their comment system. Below are few options available for WordPress Comment system.
- Disqus (we moved away)
- WordPress.com Comment System (Comes with Jetpack)
- Theme’s default Comment System (We are using this one on Crunchify now)
When you sync your comment systems, all above tools add 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:
phpMyAdmin from your cPanel.
Select your Database and Click on
wp_commentmeta table. Click on “Search” button.
dsq_ as mentioned below.
Another must read:
Select all and click Delete. Click Go Button.
Now let’s work on table
Follow the same above flow and search for
disqus_ values from table as mentioned below.
I was able to delete more than 10000 rows from
wp_commentmeta table. Once you do that, don’t forget to optimize DB. You could use our All in One Optimizer & Customizer plugin too if you want 🙂
Simplest WordPress Optimizer & Customizer Plugin!
WP Customizer provides simplest, light weight, most powerful All-in-One 50+ Optimization, Customization, Webmaster, Database, Configuration, Fine-tuning Options in one single plugin 🥳.
Let me know if you have any better way to clean these all metadata. This will help our blog running very fast.