1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Fulltext Support

Discussion in 'XenForo Questions and Support' started by nrep, Jun 21, 2013.

  1. nrep

    nrep Well-Known Member

    I thought that XenForo supported Fulltext searching, however I can see a huge search index table as part of my forum database.

    Can someone clarify if fulltext searching is possible? I can't see any options for it in the Admin panel.

    I should add that I'm using MySQL 5.6 (InnoDB), which support FT indexes.
  2. Mike

    Mike XenForo Developer Staff Member

    The standard XenForo search uses MySQL's full text search.
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That table is for the fulltext index. XenForo maintains a separate table with copies of the posts for the fulltext index rather than having the index as part of the original post table. This is probably because the post table is InnoDB. If XenForo had MySQL 5.6 as a requirement then they might change that. In the meantime space is cheap and large forums will be using the Enhanced Search addon anyways.
    nrep likes this.
  4. nrep

    nrep Well-Known Member

    Thanks for the detail Jake.

    It would be nice if we could have the option of adding FT indexes to the main InnoDB thread/post tables at some point (for those of us on 5.6). I understand it may not be soon, but I'd very much like to save some of that storage space on a few of my forums (SSD RAID setup, so not as cheap storage as I'd like).

    I've got FT InnoDB search working on another forum software (take a guess which ;)) and it works well. For medium sized forums that aren't search intensive, it's more convenient than the ES addon (especially on my Windows server).
  5. Mike

    Mike XenForo Developer Staff Member

    InnoDB or not, I can say that adding the index to the post table would never happen - it's simply not how XF's search system works (which searches more than just posts).
    nrep likes this.
  6. nrep

    nrep Well-Known Member

    OK, fair enough. Thanks for the clarification.

Share This Page