Server loading 20+

[adambloch]

Hi all I have a problem with my site.

We will normally have around 800+ user on line at which point the server will start hitting loads of 20+

We have removed all images from the database and done most of the other suggestion that appear on the sites. I feel like beating my head against the wall as no matter what we do the laoding still gets higher and higher.

I was wondering what settings people are using in the PHP.ini, the MySql and apache (my.cnt & HPPTD.com i think)

Also people keep saying that thay only have loads of 1 or 2 but never state how many users or on line.. What would you see on most sites for 800+ users ?

Many thanks

Adam

[Kaelon]

Tell us a bit about your hardware configuration. How many dedicated machines and load balancers are you using to serve your web and database processes? What do those machines consist of?

Around 800+ concurrent users (including guests) should be fine on a single quad-core dedicated server, or two dual-core boxes (one for web, another for database).

[Lynne]

I would suggest you get your server optimized over on vb.com in the Server Configuration forum.

[Angel-Wings]

<a href="http://httpd.apache.org/docs/2.2/misc/perf-tuning.html" target="_blank">http://httpd.apache.org/docs/2.2/misc/perf-tuning.html</a> for Apache

And for MySQL use mysqltuner / tuning-primer while ignoring the key_buffer_size tuning-primer may report - safe & good to use up to 1/4 of the installed RAM for key_buffer_size

Finally check your addons for anything server intensive - automatic image resizers and so on and maybe use a profiling tool for MySQL to find what your DB is doing all the time or apachetop for Apache - maybe together with mod_status (only for testing, not for production use).

[imported_silkroad]

And for MySQL use mysqltuner / tuning-primer while ignoring the key_buffer_size tuning-primer may report - safe & good to use up to 1/4 of the installed RAM for key_buffer_size.

Agreed these are excellent scripts. If you tune with mysqltuner.pl and tuning-primer.sh (http://www.unix.com/web-programming-web-2-0-mashups/75618-mysql-tuning-tools-mysqltuner-pl-tuning-primer-sh.html) as a starting point, you may find you understand your system constraints quickly.

We recently set up an OpenX ad server recently and these scripts really helped us properly size our VPS slice.

[adambloch]

Virtual Server - 2.3 Ghz Opteron, 3 GB RAM, 20 GB iSCSI SAN
Threads:79,478 Posts:806,209 Members:43,560

At around 900 the load starts to jump but thing that is really killimg me is that if I turn the search back on the site will hit over 25 almost straight away...
With out the search it will be between 2 and 5

[Marco van Herwaarden]

As per the forum description:

General PHP/MySQL/webserver configuration.

Please use vBulletin.com to get suggestions on your servers configuration on the topic of general PHP/MySQL optimisation. On the vBulletin.com Server Configuration (http://www.vbulletin.com/forum/forumdisplay.php?f=14) you will get suggestions by one of our Support Professionals.

[adambloch]

Hi Marco

Rather than Configurations I was trying to get more of a feel for server sizes and if anyone else has noticed a load increase with VB4 the highest number of people the old site 3.6.x was over 4000 and it might have got a little slow but it stayed up.

The search part of VB4 seems to be really causing problems and while there are other options out there there are all quite a bit of money...

[Marco van Herwaarden]

That would still best be asked on vBulletin.com forums. That is the place to discuss behaviour of default vBulletin.

[motowebmaster]

There was a time I was having problems with the internal search engine on a site, and re-coded some templates so that it would direct users to Google Search (of my site).

The search results weren't always that great, but generally accurate up to the previous 2-3 days. It also bought me some time to focus on sorting out the issue.

This may sound quirky, but switching the default style and disabling plugins can help reveal issues.