YARPP requires your posts table to use the MyISAM storage engine.

  • Resolved madhavaji

    (@madhavaji)


    12 years ago

    Hi There,

    This plugin looks awesome but isn’t working for me because my tables are using the InnoDB engine. I’m considering running the suggested “ALTER TABLE posts ENGINE = MyISAM;” but fist a couple of questions..

    1. Is there any way of avoiding making the switch to the MyISAM engine?
    2. What are the “performance implications” you mention in the warning at the top of the settings page?

    Thanks for all your hard work on the plugin.

    Michael.

    https://www.ads-software.com/extend/plugins/yet-another-related-posts-plugin/

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

  • Using MyISAM tables is not required for basic functionality, but your results will be better with MyISAM. Here’s why:

    YARPP uses “fulltext” indices in order to do comparison of content and title keywords in a performant way. Unfortunately fulltext indices are only available with MyISAM tables. (InnoDB fulltext support is coming in the future, the MySQL project tells us.)

    The short version of how MyISAM and InnoDB tables are different is that, if you are on a very high volume site where many transactions are occurring at a time, MyISAM may have to wait for other transactions to complete before others move forward, while InnoDB can do things in parallel better. This is a *HUGE* simplification. For most sites (if you’re not a dba administrating tweaking MySQL server’s settings) switching your posts table to MyISAM shoud not be an issue.

    If you want to use YARPP with your InnoDB posts table, I suggest lowering your “match threshold” and making sure the “body” and “content” are not being considered in the “relatedness” algorithm. Go to YARPP settings, “screen options” tab, show the “relatedness” settings, and lower the match threshold and save. YARPP will just rely on tags an categories in common.

    I hope that helps.

    Thread Starter madhavaji

    (@madhavaji)

    Awesome, thanks for your reply.

    I figured this out from other support posts and have a workable version of the plugin going now.

    Great plugin by the way ??

    All the best,

    Michael.

    IT WORKS!!

    Thanks so much Mitcho. Also, thanks for replying earlier around this concern and apologies for such late reply myself!

    ??

    Great! ??

    I overrode the settings and it does not work.

    I am not able to change over to allowing Titles and Body, and also not even 1 page or post is showing even 1 related post.

    Installation was as normal, it just does not work.

    This solved a similar problem I was having. Thanks for being a great plugin author Mitcho.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘YARPP requires your posts table to use the MyISAM storage engine.’ is closed to new replies.