Get the most out of your Centmin Mod LEMP stack
Become a Member

Xenforo Need the best setup for supporing 2 characters seach in XF

Discussion in 'Forum software usage' started by ModeltogTossen, Jan 11, 2016.

  1. ModeltogTossen

    ModeltogTossen I wish I could??

    313
    97
    28
    Dec 20, 2015
    Denmark
    Ratings:
    +143
    Local Time:
    4:44 PM
    1.9.12
    10.0.23
    Hi there..

    Have seen by other threads in here that we are a few xf admins with advanced setups. So, I have to ask this.

    If I need to give my users accurate 2 characters search options what is in need to gain that? Not about XF itself but more about the backend stuff to support it. Is any mysql flavor DB enough to handle that or should I have something else?


    The only requirement - must be able to install in a centminmod environment - not necessarily from a centminmod menu options - can do it manually if reguired.

    I does not have to be speedy - I just wish to get accurate query results returned.

    Hope to hear from some of you guys.
     
  2. eva2000

    eva2000 Administrator Staff Member

    55,802
    12,272
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,858
    Local Time:
    12:44 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  3. ModeltogTossen

    ModeltogTossen I wish I could??

    313
    97
    28
    Dec 20, 2015
    Denmark
    Ratings:
    +143
    Local Time:
    4:44 PM
    1.9.12
    10.0.23
    Wow - that results was fast returned.. I will try a little to 'mis use' your search function here. Do you have any stats about how huch indexes is growing to be handle 2 characters search vs 4-5 characters options?
     
  4. eva2000

    eva2000 Administrator Staff Member

    55,802
    12,272
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,858
    Local Time:
    12:44 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    don't have any stats that i tracked

    maybe better to ask at Enhanced Search Support | XenForo Community :)
     
  5. ModeltogTossen

    ModeltogTossen I wish I could??

    313
    97
    28
    Dec 20, 2015
    Denmark
    Ratings:
    +143
    Local Time:
    4:44 PM
    1.9.12
    10.0.23
    Allright guys.. I got elasticsearch installed on my least important servers. Debian Wheezy. I have 8 GB ram to that, did edit /etc/default/elasticsearch and change ES_HEAP_SIZE to 2G and not those 50% as mention in file.

    After install of missing java jre and elasticsearch start I tested it with curl - and got this:

    Code:
    root@hosting:~# curl http://127.0.0.1:9200
    {
      "name" : "Cordelia Frost",
      "cluster_name" : "mt-xfsearch",
      "version" : {
        "number" : "2.1.1",
        "build_hash" : "40e2c53a6b6c2972b3d13846e450e66f4375bd71",
        "build_timestamp" : "2015-12-15T13:05:55Z",
        "build_snapshot" : false,
        "lucene_version" : "5.3.1"
      },
      "tagline" : "You Know, for Search"
    }
    
    Will now go to Xenforo to flash my visa card and buy this €65 expensive enhanced search add-on..

    I still wish to hear from others..
     
  6. ModeltogTossen

    ModeltogTossen I wish I could??

    313
    97
    28
    Dec 20, 2015
    Denmark
    Ratings:
    +143
    Local Time:
    4:44 PM
    1.9.12
    10.0.23
    And it works - XF backend show this and I do have very very good 2 characters search now..

    Code:
    Elasticsearch Server:
        http://127.0.0.1:9200/mtxfsearch
    
        Version:         2.1.1
        Documents:         6,197 (4 MB)
        Index Updates:         6,197 (0.0003 seconds average)
        Searches:         55 (0.0117 seconds average)
        Fetches: 34 (0.0015 seconds average)
    
        Note that statistics will be reset if Elasticsearch is restarted or if the index is temporarily closed.
    
     
  7. eva2000

    eva2000 Administrator Staff Member

    55,802
    12,272
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,858
    Local Time:
    12:44 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Looking good :D
     
  8. ModeltogTossen

    ModeltogTossen I wish I could??

    313
    97
    28
    Dec 20, 2015
    Denmark
    Ratings:
    +143
    Local Time:
    4:44 PM
    1.9.12
    10.0.23
    Yes indeed - after some time with elastic running it now tells:

    Code:
    Elasticsearch Server:
        http://127.0.0.1:9200/mtxfsearch
    
        Version: 2.1.1
        Documents: 6,212 (3.9 MB)
        Index Updates: 6,445 (0.0003 seconds average)
        Searches: 435 (0.0060 seconds average)
        Fetches: 249 (0.0005 seconds average) 
    Still don't have many post - but that will come in time.. I wish to say, I think this is the best investment I have done to my XF beside of XF itself of course.