|
full text search, what are you using ?
i am using mysql native full text search. but increased traffic is crashing my mysql., and server load is fucking high too, eben on 64 gig box with ssd.
i used sphinx before on different project and it was pain in the ass, taking my server load to the roof. eating all my cpu.
i heard good things about elasticsearch, but looks difficult to implement.
or is it time to scale horizontally ? and throw more servers., and do master slave replication in mysql.
how many servers does the big sites own ? under 10k alexa sites ?
thanks for your time.
i have around 5 mil records and i only need to search title which is varchar 255 .
why the fuck this shit has to be so difficult for dbms.,
one of these days i am gonna code my own fts search engine.,
|