Need help with high loads

[tactic]

Hi guys,

for some reason after upgrading to vbb3 some server load has sometimes gone through the roof 70+

here is soemthing from top

20:39:24 up 19:06, 1 user, load average: 61.12, 29.76, 21.75
223 processes: 221 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 17.6% 0.0% 1.6% 0.1% 0.0% 80.5% 0.0%
Mem: 1028484k av, 1012188k used, 16296k free, 0k shrd, 4748k buff
772676k actv, 95348k in_d, 14116k in_c
Swap: 2048276k av, 340736k used, 1707540k free 153100k cached


server is a p4 2.4ghz with 1gb of ram

the load seems to be usually around 2ish and then rockets up and i usually have to restart httpd..

any one have any ideas?

[eva2000]

1. which vB version did you upgrade from ? and to vb3.0.3 ?
2. upgrade to vb3.0.3 for new optimisations in the code for better performance
3. vB 3.x uses more memory footprint than vB2.x due to the new features etc but less cpu load
4. post answers to questions asked at http://www.vbulletin.com/forum/showthread.php?t=70117

[tactic]

we were on vb2.3.4 perviously


1.
It is a dedicated server, but is runing Ensim

2.
single p4 2.8ghz cpu
1gb of ram
redhad EL linux
Apache/2.0.46
PHP 4.3.2
MySQL 3.23.58


3.
Not sure, we pretty much just use mysql for vb3

4.
Unsure

5.
10:57:32 up 12:51, 1 user, load average: 0.49, 0.40, 0.38
108 processes: 105 sleeping, 3 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 14.5% 0.0% 1.3% 0.0% 0.0% 0.7% 83.2%
Mem: 1028484k av, 996364k used, 32120k free, 0k shrd, 19704k buff
681264k actv, 39132k in_d, 12728k in_c
Swap: 2048276k av, 63224k used, 1985052k free 590444k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
25291 apache 16 0 13464 12M 4960 S 5.9 1.2 0:06 0 httpd
26247 apache 16 0 13004 12M 4740 R 5.7 1.1 0:03 0 httpd
26822 apache 16 0 12504 11M 4756 S 1.7 1.1 0:02 0 httpd
3449 mysql 17 0 14288 12M 1728 S 1.3 1.2 8:49 0 mysqld
26824 apache 15 0 11548 10M 4696 S 0.3 1.0 0:00 0 httpd
26251 apache 15 0 12344 11M 4760 S 0.1 1.1 0:01 0 httpd
26349 apache 15 0 14304 13M 4944 S 0.1 1.3 0:02 0 httpd
26854 root 15 0 1236 1236 832 R 0.1 0.1 0:00 0 top
1 root 15 0 484 452 428 S 0.0 0.0 0:04 0 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0


6.
[mysqld]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock
datadir=/var/lib/mysql
set-variable = max_connections = 250

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock


7.
http://www.boredofstudies.org/mark/mysql.php

8.
vb is not the only thing that uses php/mysql
the main site uses it as well, altho not to the extent that vb does

9.
Average would be about 70-80 i think
Max we have had on this server is about 225 users

10.
www.boredofstudies.org/mark/phpinfo.php

11.
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 150

12.
vb3.0.1

i think i will upgrade to vb3.0.3 tonight..