[gentoo-dev] Performance Apache/PHP / PHP-Problem

[gentoo-dev] Performance Apache/PHP / PHP-Problem

[Benjamin Podszun]

[-- Attachment #1: Type: text/plain, Size: 2092 bytes --]

Hi there.

I posted my Apache problems before and I think I found the root cause
now. I have a nntp2web-gateway as forum and the nntp-server regularly
reaches a high load because of some other applications.
The server still accepts connections, but feeds more or less a "wait a
moment" to my webserver..

First problem for me: Gentoo's mod_php isn't build with
--enable-memory-limit. I needed that to solve some of my performance
problems and I think it should be used by default, since one can set the
limit in the php.ini.

Second problem: I seem to miss something here.. My php-scripts won't
stop receiving data in spite of my self-made memory-limit-aware mod_php.

I get funny thinks like this with apachectl fullstatus:

 Srv PID Acc M CPU SS Req Conn Child Slot Client VHost Request
   0-0 24732 0/9710/9710 W 255.39 48435 0 0.0 12.94 12.94 217.82.173.211
   galactic-tales.4players.de GET /nntp2web/thread.php?group=rpg
HTTP/1.1
   1-0 28522 0/747/10693 W 19.49 47228 0 0.0 0.61 13.47 217.227.120.194
   galactic-tales.4players.de GET
/nntp2web/thread.php?group=rpg&it=54641
   HTTP/1.1
   2-0 28387 0/75/10032 W 1.00 48434 0 0.0 0.02 10.99 80.137.211.194
   galactic-tales.4players.de GET
/nntp2web/thread.php?group=rpg&it=48832
   HTTP/1.1
   3-0 24735 0/9494/9494 W 253.37 48442 0 0.0 12.14 12.14 80.145.106.208
   galactic-tales.4players.de GET /nntp2web/thread.php?group=rpg&it=282
   HTTP/1.1

The columns are:

   Srv  Child Server number - generation
    PID  OS process ID
    Acc  Number of accesses this connection / this child / this slot
     M   Mode of operation
    CPU  CPU usage, number of seconds
    SS   Seconds since beginning of most recent request
    Req  Milliseconds required to process most recent request
   Conn  Kilobytes transferred this connection
   Child Megabytes transferred this child
   Slot  Total megabytes transferred this slot

So.. Every Connection transferred ~50MB? *ugh*
I better don't count all the lines with similar problems..

Anyone able to provide me with a quick hint? ;-)

Ben

[-- Attachment #2: This is a digitally signed message part --]
[-- Type: application/pgp-signature, Size: 189 bytes --]

Re: [gentoo-dev] Performance Apache/PHP / PHP-Problem

[Robin H.Johnson]

[-- Attachment #1: Type: text/plain, Size: 2142 bytes --]

On Wed, Apr 16, 2003 at 10:57:09AM +0200, Benjamin Podszun wrote:
> I posted my Apache problems before and I think I found the root cause
> now. I have a nntp2web-gateway as forum and the nntp-server regularly
> reaches a high load because of some other applications.
> The server still accepts connections, but feeds more or less a "wait a
> moment" to my webserver..

> First problem for me: Gentoo's mod_php isn't build with
> --enable-memory-limit. I needed that to solve some of my performance
> problems and I think it should be used by default, since one can set the
> limit in the php.ini.
Ok, I'll at this in shortly.

> Second problem: I seem to miss something here.. My php-scripts won't
> stop receiving data in spite of my self-made memory-limit-aware mod_php.
> I get funny thinks like this with apachectl fullstatus:
>  Srv PID Acc M CPU SS Req Conn Child Slot Client VHost Request
>    0-0 24732 0/9710/9710 W 255.39 48435 0 0.0 12.94 12.94 217.82.173.211
>    galactic-tales.4players.de GET /nntp2web/thread.php?group=rpg
> HTTP/1.1
You have misread the columns.

Align the columns better or look at the web version "http://localhost/server-status" in a table capable browser.
Srv     PID     Acc         M   CPU     SS      Req     Conn    Child   Slot    Client          VHost   ...
0-0     24732   0/9710/9710 W   255.39  48435   0       0.0     12.94   12.94   217.82.173.211  galactic-tales.4players.de ...

The ~50 you see is NOT the size, it's the time in seconds since the last
request. The 'W' shows that the request is still open, so that IS a
serious issue. I would turn off keepalives + persistant connections in
apache/php totally. There is minimal performance gain with them in PHP
anyway. The '12.94Mb' for the Child column is how much that Apache child
process has transfered over its lifetime.
9170 connections and 12.94Mb is quite low traffic.

-- 
Robin Hugh Johnson
E-Mail     : robbat2@orbis-terrarum.net
Home Page  : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ#       : 30269588 or 41961639
GnuPG FP   : 11AC BA4F 4778 E3F6 E4ED  F38E B27B 944E 3488 4E85

[-- Attachment #2: Type: application/pgp-signature, Size: 232 bytes --]

Re: [gentoo-dev] Performance Apache/PHP / PHP-Problem

[Benjamin Podszun]

[-- Attachment #1: Type: text/plain, Size: 2725 bytes --]

Thanks.. Stupid me, I should've formatted it before I ask for help.
But I'm really quite annoyed already.. I cannot find any difference
between the Debian Installation that worked for about a year and this
Gentoo 1.4 . I'm sure I made a mistake somewhere, but I've no idea where
to start the search.

KeepAlive is already disabled.
The "W" states that it is currently responding to a request, right? I
used KeepAlive before, but a keepalive-State would be a "K" in the
"M"-Column.

PHP connections can only be persistant for Databases, afaik?
However: We don't use persistant connections and I just disabled them
completely.

No ideas what else I could turn off right now. :(

On Wed, 2003-04-16 at 11:29, Robin H.Johnson wrote:
> On Wed, Apr 16, 2003 at 10:57:09AM +0200, Benjamin Podszun wrote:
> > I posted my Apache problems before and I think I found the root cause
> > now. I have a nntp2web-gateway as forum and the nntp-server regularly
> > reaches a high load because of some other applications.
> > The server still accepts connections, but feeds more or less a "wait a
> > moment" to my webserver..
> 
> > First problem for me: Gentoo's mod_php isn't build with
> > --enable-memory-limit. I needed that to solve some of my performance
> > problems and I think it should be used by default, since one can set the
> > limit in the php.ini.
> Ok, I'll at this in shortly.
> 
> > Second problem: I seem to miss something here.. My php-scripts won't
> > stop receiving data in spite of my self-made memory-limit-aware mod_php.
> > I get funny thinks like this with apachectl fullstatus:
> >  Srv PID Acc M CPU SS Req Conn Child Slot Client VHost Request
> >    0-0 24732 0/9710/9710 W 255.39 48435 0 0.0 12.94 12.94 217.82.173.211
> >    galactic-tales.4players.de GET /nntp2web/thread.php?group=rpg
> > HTTP/1.1
> You have misread the columns.
> 
> Align the columns better or look at the web version "http://localhost/server-status" in a table capable browser.
> Srv     PID     Acc         M   CPU     SS      Req     Conn    Child   Slot    Client          VHost   ...
> 0-0     24732   0/9710/9710 W   255.39  48435   0       0.0     12.94   12.94   217.82.173.211  galactic-tales.4players.de ...
> 
> The ~50 you see is NOT the size, it's the time in seconds since the last
> request. The 'W' shows that the request is still open, so that IS a
> serious issue. I would turn off keepalives + persistant connections in
> apache/php totally. There is minimal performance gain with them in PHP
> anyway. The '12.94Mb' for the Child column is how much that Apache child
> process has transfered over its lifetime.
> 9170 connections and 12.94Mb is quite low traffic.

[-- Attachment #2: This is a digitally signed message part --]
[-- Type: application/pgp-signature, Size: 189 bytes --]