Too Much Unnecessary load on server

[Punjabi.Warri0r]

I have a site which dont even have that much traffic but still gets down often, its a linux server and with 30-40 ppl on it site goes down, the problem is mostly with mysql server , what could b wrong with my vbuletin database???

[Lynne]

Server load is different than mysql server going down - which is the problem? Is this your own server? If so, you should get it optimized over on vb.com.

[Punjabi.Warri0r]

Yea I M The Owner, And I No Its The Problem With Mysql , How Can I Resolve It?? , cuz i have been having the same problem when i had shared hosting then i moved to virtual dedicated the problem persists, then now again on dedicated server i have same problem

[imported_silkroad]

Yea I M The Owner, And I No Its The Problem With Mysql , How Can I Resolve It?? , cuz i have been having the same problem when i had shared hosting then i moved to virtual dedicated the problem persists, then now again on dedicated server i have same problem

The easiest way to check MySQL (without the hassle of posting pages and pages of server information publicly), is to download and run two very simple MySQL tuning scripts:

http://www.unix.com/web-programming-web-2-0-mashups/75618-mysql-tuning-tools-mysqltuner-pl-tuning-primer-sh.html

These scripts will work for most people. They work great for us.

--------------- Added 1252538091 at 1252538091 ---------------

Server load is different than mysql server going down - which is the problem? Is this your own server? If so, you should get it optimized over on vb.com.

MySQL issues can and do contribute directly to server load.

We currently see an occasional MySQL deadlock issue that sends our load average to the stratosphere :( I have seen MySQL issues drive server load from 1.4 to 100 :down:

[Lynne]

MySQL issues can and do contribute directly to server load.

We currently see an occasional MySQL deadlock issue that sends our load average to the stratosphere :( I have seen MySQL issues drive server load from 1.4 to 100 :down:
Sure they can. But what I was saying is that server load problems can also be caused by so many other things too. I wanted clarification of the exact issue.

[Marco van Herwaarden]

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.