vbulletin and mysql - server load v.high

[jamie]

hi,

our vbulletin installation is maxing out our server at only 80 users.

loads are permanently at 7+

we have p4 2.4 and 2GB ram
mysql 4.0.24
php 4.4.2 with phpa

does anyone know of any issues which might be causing this?

it can't be the users as hardware like this should be able to cope with many, many more?

much appreciate any help

[andye]

Can you switch on the MySQL slow query log?

That can show you if there are particular SQL queries which are taking a long time to execute. If there are then this could help you track down the problem.

(of course, it could be unrelated to MySQL, but this is worth a try I think).

best, a.

[jamie]

andye

and i never thought about that!

i have tracked it down to a query which i added myself. i have disabled that and so far things appear to be calming down.

will monitor carefully though.

many thanks for the help!