nginx(engine x) and sphinx...

[MalditohoN]

---

thanks for the reply bro...

[MalditohoN]

pwede magpa tutor nmu bro... hehehehehe... sort of nagcreate mig search engine.. heheheheh...

If you are planning to move to nginx from Apache, I suggest you read about php-fpm as well. The main difference, at least on my perspective, is that it is easier to scale php/fcgi under nginx into multiple servers as it can on it's own act as both a load balancer and web server. It is also generally accepted that nginx is more resource friendly compared to Apache.

For a dynamic website, Apache is faster out of the box. But if tuned properly, nginx can at least match Apache's performance if not better. If you don't want to go through the hassle of converting your Apache configurations/rewrite rules, you can also setup nginx as a reverse proxy which also improves performance quite significantly.

For MySQL optimization, it depends on your usage or query statistics. The most basic though is to buffer all your indexes into memory (ie: key_buffer_size) and a fast file-system (ie: RAID10 15k RPM SAS or Enterprise SSD's).

[moodsey211]

search engine like google? naa na moy web crawler? needed jud nimo if fine-tune ang mysql para ana. Between Apache and NGINX I'll recommend NGINX, since dako ra kaayo ug kaon ang Apache in terms of memory usage.

[MalditohoN]

yes boss, naa mi web crawlers... using apache as webserver, then dako kaaug consumption sa memory. sa memcached and sqlite...

search engine like google? naa na moy web crawler? needed jud nimo if fine-tune ang mysql para ana. Between Apache and NGINX I'll recommend NGINX, since dako ra kaayo ug kaon ang Apache in terms of memory usage.

[BeoR]

If you can tell me what you need I might be able to help. I will try my best to give you an answer.

pwede magpa tutor nmu bro... hehehehehe... sort of nagcreate mig search engine.. heheheheh...

[MalditohoN]

Sir, is your sphinx implementation on RT(real-time)?

If you can tell me what you need I might be able to help. I will try my best to give you an answer.

[BeoR]

Sorry for the late reply. No as that would kill our MySQL. ^_^

Sir, is your sphinx implementation on RT(real-time)?

[xyrusdvirus2k]

Maybe create a cron job to update indexes during non-peak hours?

[BeoR]

Our indexes are updated every 5 minutes... ^_^

[MalditohoN]

just to answer this question bro, MYISAM engine amo gigamit.
then wala nako ni implement sa FULLTEXT since naggamit naman ko sa sphinx.

which table type do you have? myisam, innodb...?

need to let mysql know about it, .ini file.
[mysqld]
ft_min_word_len=?
ft_max_word_len=?

is your index FULLTEXT?

and marami pa.