WordPress.org

Ready to get started?Download WordPress

Forums

Yet Another Related Posts Plugin (YARPP)
[resolved] YARPP requires your posts table to use the MyISAM storage engine. (7 posts)

  1. madhavaji
    Member
    Posted 1 year 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.

    http://wordpress.org/extend/plugins/yet-another-related-posts-plugin/

  2. mitcho (Michael Yoshitaka Erlewine)
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  3. madhavaji
    Member
    Posted 1 year ago #

    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.

  4. Patrilux
    Member
    Posted 1 year ago #

    IT WORKS!!

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

    :)

  5. mitcho (Michael Yoshitaka Erlewine)
    Member
    Plugin Author

    Posted 1 year ago #

    Great! :)

  6. thenewbreed
    Member
    Posted 10 months ago #

    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.

  7. johnwebsites
    Member
    Posted 9 months ago #

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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.