More RAM is always good. AFAIK, RAM is first preference, than CPU. You can write a small script to monitor CPU / Memory usage of WebServer and Database server (its easy, since you know both are long running process, so script can query based on their PID). If everything goes well, try to implement MemCache (you will say WOW, what a performance, but i am not sure how to integrate it with vBulletine. caching is good if implemented at application level, but you won't want to mess with their code). Apart from these, you can do static resources delivery through ngnix server. You will have to find which URL is mapped for static content, and then use sort of URL rewriter to point at ngnix. I did the same thing for a client's application, and the result was awesome (in terms of webserver responsivness and memory usage).
At database server, its always good idea to minimize their disk IO activities. So loading most indexes in memory is a win situation. Other MySQL optimizations, some are specifi to your server architecture (like max. no. of threads to use. Too less and too many are both a high performance hit). I think a site is called mysqlperformanceblog. You can find a lot there. On Wed, Mar 10, 2010 at 11:06 AM, Tanveer Singh <w...@tanveer.in> wrote: > Hi, > We have a website running vbulletin and some other stuff. The number of > visitors is huge, and our quad core 16GB RAM dedicated server is feeling > the > load. The web server is lightspeed > Poking around on vbull forums revealed that most big boards run on 2 server > config > 1. Database server > 2. Front end Web server. > We are on single server. Sometime back we were on apache, and loads were > very high, after moving to lightspeed, things improved, but looking at the > growing web traffic, we would need to go with dual server, with one > database > server running mysql, and vbull frontend etc., on the other server. > But before me make this plunge, we want to make an informed decision about > whats consuming what load. > Is the RAM the bottleneck, or is it CPU, if its CPU which process is eating > CPU, how much is mysql process consuming etc., etc., > > So we were thinking that we run a simple monitor software which dumps some > graphs etc., over a period of one week, where we can compare the real time > traffic vs CPU load graphs etc., and which process is memory intensive, > which is CPU intensive blah blah. > Any pointers to some easy to configure stuff? > > regards > Tanveer > _______________________________________________ > Ilugd mailing list > Ilugd@lists.linux-delhi.org > http://frodo.hserus.net/mailman/listinfo/ilugd > -- -=Ravi=- _______________________________________________ Ilugd mailing list Ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd
