I just found out that the Yet Another Related Posts plugin (YARPP) uses FULLTEXT indexes on the wp-posts table, which greatly slows down sites with a large amount of posts.

Can I can just delete the plugin, or do I have to clean out the wp-posts table of those indexes in order to fix the issue?

1 Answer 1


YARPP doesn't do anything on uninstall.

So you have to uninstall it then go remove the indexes manually from the DB. The index names should be prefixed with yarpp_. Very untested SQL follows:

DROP INDEX yarpp_title ON wp_posts;
DROP INDEX yarpp_content ON wp_posts;
  • Do I just need to drop the yarpp_ tables, or are there columsn in wp_posts that I need to drop as well?
    – jetlej
    Mar 8, 2013 at 1:34
  • Just the indexes. Mar 8, 2013 at 1:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.