Load average is going wild

[faifas]

Hello fellows,

 

I'm having a weird issue and wanted to find out if any of you know how to deal with it.

I've got myself Ubuntu box and online RPG game hosted on it.

The problem is that apache and mysqld is going wild (I mean it).

 

load average: 1.22, 1.20, 1.07

 

That's an usual load when I only have 40 players online.

Tried stopping apache, server load went to 0.02 (ircd was using it)

 

Server speed: 2.0Ghz

RAM: 500mb

apache conf:

timeout 5

 

Keepalive On

keep alive timeout 15

 

My server is good enough for such project and I can bet that I have a bug somewhere in my PHP code, that causes a never ending loop and apache with mysqld are going wild.

 

Mysql is using ~20% of CPU and few apache childs are using ~11% each, so that's really not normal.

 

What do I want you to help me with is a tool for showing php files CPU usage or something similar, so that I could find out which of my files are causing that server load.

 

Thanks in advance,

Faifas

[anyweb]

hi, interesting problem as i've seen it myself on this server when it got on the front page of Digg.com

 

however, at the time i didn't bother to read my http.conf better, if i had I probably would have noticed this

 

Code:

# for digg do MinSpareServers 15
MinSpareServers 5
# digg > MaxSpareServers 65
MaxSpareServers 10
#
# Number of servers to start initially --- should be a reasonable ballpark
# figure.
#
StartServers 15

#

 

i've now changed it to this and restarted apache

 

Code:

# for digg do MinSpareServers 15
MinSpareServers 15
# digg > MaxSpareServers 65
MaxSpareServers 65
#
# Number of servers to start initially --- should be a reasonable ballpark
# figure.
#
StartServers 15

#

 

i wonder could this also help you ? also, my keep alive is set to Off

 

why have you set yours to on ?

 

cheers

anyweb

[hijinks]

keepalive is generally not a good option to have on unless you run like a image hosting service where you want to show a lot of pictures at once to a client

[faifas]

Thank you both for your answers,

 

while I was waiting for them I've realized that I had to do something on my own, so first thing I did was lowered memory setting in php.ini

That really helped a little and now I am going to try out your tips.

 

I never really understood what is keepalive and should I turn it on or off, now I realize that I had to turn it off.

 

Thank you!

Faifas