Title and body indexes with InnoDB

  • eclev91

    (@eclev91)


    7 years, 2 months ago

    Hey,

    So in the plugin settings I get the following message:

    YARPP’s “consider titles” and “consider bodies” relatedness criteria require your sdi_posts table to use the MyISAM enginefulltext indexing feature. Unfortunately your table seems to be using the InnoDB engine. Because fulltext indexing is not supported by your current table engine, these two options have been disabled.

    Fair enough, but as of MySQL 5.6, InnoDB does have FULLTEXT indexing, see here. Any chance we see this feature expanded to InnoDB databases on MySQL 5.6? Obv. I could alter my tables, but InnoDB offers a variety of other advantages.

Viewing 1 replies (of 1 total)
  • 762mm

    (@762mm)

    7 years, 2 months ago

    I am using InnoDB and am not seeing this message. YARPP has created FULLTEXT indexes of the post_title and post_content columns in my wp_posts table.

    What version of MySQL are you using? The above is true for me on both a server running MySQL 5.6.35 and one running MariaDB 10.0.29.

Viewing 1 replies (of 1 total)
  • The topic ‘Title and body indexes with InnoDB’ is closed to new replies.