high load of vb-mysql on my server

[Ruler]

hi on my vb forum i have only 100-200 ppl online sill my mysql database is using 350-390% load out of 400% load
its really annoying making my site slow
my server details:-

cpu speed/type single or dual cpus): 2 x 2.8ghz xeon
how much memory installed: 2 x 2gb ram
hard drive type/configuration: 2x 72GB 10,000 RPM SCSI
linux distributor or windows version: CentOS 5.3 i386
apache/IIS version: Apache/2.2.3
PHP version: 5.2.6
MySQL version: 5.0.45

and all the rest details are posted here:-

http://www.vbulletin.com/forum/showthread.php?t=310966

if somebody can fix it i an even pay few bucks to him i am not sure how much

Ruler Reviewed by Ruler on 18th Jun 2009. high load of vb-mysql on my server hi on my vb forum i have only 100-200 ppl online sill my mysql database is using 350-390% load out of 400% load its really annoying making my site slow my server details:- cpu speed/type single or dual cpus): 2 x 2.8ghz xeon how much memory installed: 2 x 2gb ram hard drive type/configuration: 2x 72GB 10,000 RPM SCSI linux distributor or windows version: CentOS 5.3 i386 apache/IIS version: Apache/2.2.3 PHP version: 5.2.6 Rating: 5

[Whoo]

Read this , it will help you find the queries that are causing this high load. When you found them maybe you can remove them or run them cached.

[Viz0n]

Have you considered memcache? As for your my.cnf, try increasing the values.

The following should be helpful: http://blog.highspeedweb.net/2008/07...log-for-mysql/ http://www.linuxweblog.com/tune-my.cnf

Your my.cnf is too basic, you can easily get more queries and tables cached to reduce CPU.