Posted 4 months ago #
Hello,
Is it possible to have YARPP working with innoDB database?.
It could be possible to configure YARPP to avoid fulltext keyword search and use only taxonomies to generate related posts?
Regards,
http://wordpress.org/extend/plugins/yet-another-related-posts-plugin/
Posted 4 months ago #
Yes! That's what YARPP does if you run it with wp_posts in InnoDB. It'll first warn you about it, and tell you that it can't create a fulltext index, but then it'll simply work by just looking at taxonomies. You may need to lower the match threshold, though.
With fulltext support in mysql 5.6.4+ with innodb, will yarpp take advantage of that?
Posted 2 months ago #
Yes, hopefully, though MySQL 5.6+ adoption is going to take a long time. People are slow to switch...
Are you running InnoDB with fulltext right now?
Posted 2 months ago #
Hi Mitcho :)
Yes, it is warning us about it - and it doesn't seem to work...?
Here's an example: http://uk.iacworld.org/get-vibrational-state-astral-projection/
There are a couple of articles on the very same topic (very similar) but nothing comes up under related posts.
I lowered the maximum display of related posts to 1; not sure if that's what you mean by lowering the match threshold...
Any help at this point very much appreciated.
Thanks in advance!!
Posted 2 months ago #
@Patrilux: are you having the same issue with InnoDB tables? Or is this a different issue?
See a longer post on InnoDB vs MyISAM tables here: https://wordpress.org/support/topic/yarpp-requires-your-posts-table-to-use-the-myisam-storage-engine?replies=2#post-3959160
You must log in to post.
