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

Forums under 500K post: Did you already use Elastic Search?

Discussion in 'Forum Management' started by RoldanLT, Jan 20, 2014.

  1. RoldanLT

    RoldanLT Well-Known Member

    Right now I have:
    But still using the default mysql search.

    I'm planning of purchasing Elastic Search addon, but is it worth it?
    Maybe I should wait 1M post before using it.
     
  2. MattW

    MattW Well-Known Member

    Been using it since 220,000 posts. Definitely worth it
     
    RoldanLT likes this.
  3. Brogan

    Brogan XenForo Moderator Staff Member

    I use it here: http://cliptheapex.com/
    It's not just useful for large sites, it has additional functionality, fewer stop words, etc.
     
    RoldanLT likes this.
  4. RoldanLT

    RoldanLT Well-Known Member

    Ok then, I have to raise funds first :)
    Maybe Next Month I'll be installing it on my server.

    Server Specs:
    CPU: Intel i5 (4 cores / 4 Threads)
    Frequency: 3.1GHz (3.8GHz Turbo Boost)
    RAM: 8 GB DDR3
    CentOS 6.5 Server

    All my forum applications are run on this server (mysql, php, memcache, etc.)
    Can it still handle Elastic Search?

    Or I have to setup it other server?
     
  5. RoldanLT

    RoldanLT Well-Known Member

    WoW I can search 1 character :D
     
  6. Andy.N

    Andy.N Well-Known Member

    Yes, my site uses a lot of 3-letter words like MBA, MFE, MSF so it's definitely useful.
     
    RoldanLT likes this.
  7. RoldanLT

    RoldanLT Well-Known Member

    @MattW @Brogan @Andy.N
    May I know your Server Specs?
    How much Elastic service consumes memory ?
     
  8. Moshe1010

    Moshe1010 Well-Known Member

    I run it on a VPS with 4 cores, 5GB RAM and have zero problems. It takes about 500-700MB of RAM, depends on the usage. I have about 600K messages at my board.
     
    RoldanLT likes this.
  9. MattW

    MattW Well-Known Member

    Linode VPS with 2GB ram. I allocated 256MB to it for the cache, and it's using just over 100MB
     
    RoldanLT likes this.
  10. TheBigK

    TheBigK Well-Known Member

    We use it on CrazyEngineers. Why I bought it? I don't know. It works.
     
    RoldanLT likes this.
  11. CyclingTribe

    CyclingTribe Well-Known Member

    I use it on all of mine, in particular for the word stemming.

    I have 64GB RAM in my server so memory isn't an issue.
     
    RoldanLT likes this.
  12. TheBigK

    TheBigK Well-Known Member

    64??

    I'm doing fine with just 8 GB.
     
  13. Andy.N

    Andy.N Well-Known Member

    RAM must be so cheap these days.
     
  14. RoldanLT

    RoldanLT Well-Known Member

    With those 6K simultaneous login?
    8GB can handle that?
     
  15. TheBigK

    TheBigK Well-Known Member

    Not logins; but just online users; with a cookie life of about 1 hour.
     
    RoldanLT likes this.
  16. RoldanLT

    RoldanLT Well-Known Member

    OK, As I remember you're using LiteSpeed maybe that's the reason it handle that kind of traffic :)
     
  17. TheBigK

    TheBigK Well-Known Member

    Yep, we're on litespeed. But looks like MySQL isn't coping up.
     
  18. Moshe1010

    Moshe1010 Well-Known Member

    In what sense not coping up? Have you tried Percona?
     
    RoldanLT likes this.
  19. TheBigK

    TheBigK Well-Known Member

    Frankly speaking, my knowledge of databases is very very limited. In all the similar situations a few months ago; it was HTTP that'd crash. We moved over to LiteSpeed and life's been wonderful since then.

    It was only until a few hours ago that the traffic spiked like anything and we got mySQL crashed. Note that the 'load' on the server, as indicated in our server control panel was still about 1.5 and LiteSpeed handeled it all well.

    The problem was with MySQL. It crashed every time our online user count crossed 6k. Analytics would report about 800 real-time visitors and restarting MySQL was only option. The server admins (host) said they didn't see anything unusual in the logs.

    I'm reading all the nice things about Percona. But I feel comfortable with phpMyadmin. I'll also have to check whether my web hosting folks would support it.
     
  20. TheBigK

    TheBigK Well-Known Member

    We're on a VPS; so they don't just upgrade RAM. But I'm checking with them again.
     

Share This Page