Hi, We have a site of 700,000 pages which have a database of 2 GB size. The database is fully indexed with fulltext. For this site we have bought a dedicated server with configuration: Intel Celeron 2.6 GHz 3GB RAM 120GB SATA Hard Drive 2000GB Bandwidth But we cannot understand why the server load is always high (4-5). Any body please help me. Is the server configuration is not sufficient for this site? Or what should the server load for this site? Thanks, Amitava
Hey, Thats a very hard question to answer with the information you've given. Posting the output from 'top' might help, but basically its down to what: a) Your code is doing. b) Your queries are doing. If they're poorly designed or even designed well, but cpu-intensive, then that might account for your probelms. And "what is your code doing" is a very broad question... but as I said, post the output of top, will narrow things down a little.
It's hard to say. (How) do you cache the pages? Is there an internal search function? Any unoptimized queries running on every pageview (JOINs, ORDER BY RAND()s...)? How many visitors?
If your server load is always high then it means that some one is ddosing on your server.ddosing can be removed through serverl steps. thanks
Some things to check: Are the MySQL and Apache daemons running on same machine? if yes, it's a little harder to find the bottleneck Apache or MySQL or both.... Is the server swapping? this can cause the load to increase... Tune the apache and mysql configs to fit together in RAM.... Are your queries all using indexes? to detect slow queries, activate de slow query log in your mysql config file (my.cnf) For apache, ensure that the process pool is high enough to handle peaks and minimize de process creation/killing. This is under Server-Pool Size Regulation section of your apache config file. it's not a simple question to answer without enough details... Good luck
Hi All, Our site has 700,000 dynamic pages. Some datas, contents in those pages are fetched from database. There is no coding which has a chance to load server. Simple queries are full text indexed. There is an internal search section, which is totally done with full text search from database. There are no queries with JOIN, ORDER BY RAND (). Total visitors of our site are 2000 per day. And our server configuration is: Intel Celeron 2.6 GHz 3GB RAM 120GB SATA Hard Drive 2000GB Bandwidth Can u please tell me what should be the server load approx? Thanks
For Sites with High Traffic, usually Apache is the Culprit. It is a Memory Hog. Try using Lighttpd. High Server load can also be due to DDOS. Buy a Server from Staminus.net...they got one of the best DDOS protection on planet Anything above 3 is high sever load for me 2000 People a day should be easy enough...it think your server is geting DDOS