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

[rdn]

Right now I have:

Discussions: 41,322
Messages: 406,292

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.

 

[MattW]

Been using it since 220,000 posts. Definitely worth it

 

[Paul B]

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

 

[rdn]

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?

 

[rdn]

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

WoW I can search 1 character

 

[Andy.N]

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

 

[rdn]

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

 

[Moshe1010]

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

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.

 

[MattW]

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

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

 

[TheBigK]

We use it on CrazyEngineers. Why I bought it? I don't know. It works.

 

[CTXMedia]

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.

 

[TheBigK]

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.

64??

I'm doing fine with just 8 GB.

 

[Andy.N]

64??

I'm doing fine with just 8 GB.

RAM must be so cheap these days.

 

[rdn]

64??

I'm doing fine with just 8 GB.

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

 

[TheBigK]

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

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

 

[rdn]

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

 

[TheBigK]

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

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

 

[Moshe1010]

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

In what sense not coping up? Have you tried Percona?

 

[TheBigK]

In what sense not coping up? Have you tried Percona?

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.

 

[TheBigK]

64??

I'm doing fine with just 8 GB.

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