Hi again. After disabled KeepAlive setting and apache work around 18 hours, i had the same situation. Apache started to spawn processes, in mytop i saw a lot of queries that are working (too many threads) and in server-status page i saw a lot of requests with mode "W". Every new connection and requests was staying with mode "W". Any other suggestions what can cause this problem? If you need any info please tell me so i can give you. Thanks. Regards, Ali Nebi! On Mon, 2009-02-02 at 18:35 +0200, anebi@xxxxxxxxxxxx wrote: > hi, thanks for reply. > > I will set now keepalive to off and check how it will work. > MaxKeepAliveRequests that i set was for testing. I usually use default > value 100. > > I will inform you how server is going with disabled keepalive. > > Regards, Ali Nebi! > > On Mon, 2009-02-02 at 21:44 +0530, ganesh ganesh wrote: > > Hi, > > > > Without complete interrogation i wont be able to provide you the exact > > answer.. but the immediate suggestion i can suggest you is disable the > > KeepAlive: > > > > KeepAlive Off > > > > and restart your apache... let me know how it goes... also the max > > keepalive reqeust is i think a bit too much taking in to > > consideration no of child process that can be spawned based on the > > parents > > > > > > Regards, > > Ganesh, > > ganesh@xxxxxxxxxxxxx > > > > On Fri, Jan 30, 2009 at 7:48 PM, anebi@xxxxxxxxxxxx > > <anebi@xxxxxxxxxxxx> wrote: > > Hi, > > > > we have installed apache 2 on centos 5 system and we have a > > big problem > > with spawning too much child processes. These are the versions > > that we > > use: > > > > > > Centos 5.2 x86_64 > > httpd-2.2.8-jason.3 > > php-5.2.6-1.el5.remi > > mysql-5.0.45-7.el5 > > > > System has 2xquat processor (total 8 cores) and 16 GB RAM > > > > > > We have this configuration for prefork MPM and timeouts: > > > > # > > # Timeout: The number of seconds before receives and sends > > time out. > > # > > Timeout 100 > > > > # > > # KeepAlive: Whether or not to allow persistent connections > > (more than > > # one request per connection). Set to "Off" to deactivate. > > # > > KeepAlive On > > > > # > > # MaxKeepAliveRequests: The maximum number of requests to > > allow > > # during a persistent connection. Set to 0 to allow an > > unlimited amount. > > # We recommend you leave this number high, for maximum > > performance. > > # > > MaxKeepAliveRequests 500 > > > > # > > # KeepAliveTimeout: Number of seconds to wait for the next > > request from > > the > > # same client on the same connection. > > # > > KeepAliveTimeout 2 > > > > ## > > ## Server-Pool Size Regulation (MPM specific) > > ## > > > > # prefork MPM > > # StartServers: number of server processes to start > > # MinSpareServers: minimum number of server processes which > > are kept > > spare > > # MaxSpareServers: maximum number of server processes which > > are kept > > spare > > # ServerLimit: maximum value for MaxClients for the lifetime > > of the > > server > > # MaxClients: maximum number of server processes allowed to > > start > > # MaxRequestsPerChild: maximum number of requests a server > > process > > serves > > <IfModule prefork.c> > > StartServers 5 > > MinSpareServers 5 > > MaxSpareServers 20 > > ServerLimit 250 > > MaxClients 250 > > MaxRequestsPerChild 5000 > > </IfModule> > > > > Apache and mysql works fine around 20 hours, and then in some > > moment > > apache start to spawn a lot of processes until stop to handle > > requests. > > > > I checked with top,mytop,apachetop our system and what i saw > > is this. > > When this happen apachetop (parse server-status result) shows > > that there > > are a lot of requests with "W" mode and at the same time i see > > a lot of > > not finished threads and queries in mytop (run time monitoring > > of > > mysql). > > > > In top and other system monitoring tools i see that memory is > > ok. There > > is enough free memory. System does not swap, but CPU usage > > from mysql > > and apache is getting too high. Apache is spawning and mysql > > cannot > > handle these requests. It use also too much CPU during this > > time. > > > > What i cannot understand is why there are so many requests > > with "W" mode > > in server-status page. Of course this is not happen every > > time. Maybe 2 > > times per day, but i need to find out why this happen and to > > try to fix > > this problem. > > > > What can be the problem, how to troubleshoot this and > > undestand what > > exactly happens? > > > > Thanks in advanced! > > > > Regards, Ali Nebi! > > > > > > --------------------------------------------------------------------- > > The official User-To-User support forum of the Apache HTTP > > Server Project. > > See <URL:http://httpd.apache.org/userslist.html> for more > > info. > > To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx > > " from the digest: > > users-digest-unsubscribe@xxxxxxxxxxxxxxxx > > For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx > > > > > > > > > > -- > > Regards, > > GANESH. > > > --------------------------------------------------------------------- > The official User-To-User support forum of the Apache HTTP Server Project. > See <URL:http://httpd.apache.org/userslist.html> for more info. > To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx > " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx > For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx > --------------------------------------------------------------------- The official User-To-User support forum of the Apache HTTP Server Project. See <URL:http://httpd.apache.org/userslist.html> for more info. To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|