httpd-users-de mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Goik" <Thomas.G...@echtwahr.com>
Subject RE: apache2 performance
Date Mon, 18 Jul 2005 12:06:54 GMT
Hi Simon,

es ist denke ich mal ein Problem bei deinem Speicher, und zwar hast du 69
mysql instanzen laufen die jeweils 2.5 % deines Speichers belegen, dazu
kommen dann noch andere programme, und eben die httpd instanzen, die mit 33
zu buchen schlagen, ich würde mal einfach tippen, dein speicher ist
aufgfressen und du dein server swap't die ganze zeit, daher muß er länger
auf die antworten warten was die Load hochtreibt.

Kannst du die Seite betreiben ohne  den Mysql zu verwenden, besser wäre
einen extra sql server zu haben :)

Gruß Thomas


Mit freundlichen Grüssen
    Thomas Goik

------------------------
http://www.echtwahr.de
http://www.echtwahr.com

> -----Original Message-----
> From: Simon Lange [mailto:sl@polynaturedesign.com]
> Sent: Monday, July 18, 2005 1:44 PM
> To: users-de@httpd.apache.org
> Subject: RE: apache2 performance
>
>
> On 18.07.05 at 13:33:38 [+0200], Thomas Goik <Thomas.Goik@echtwahr.com>
> wrote:

> beispiel:
> load 1.5
> ich rufe die seite auf
> und schlagartig ist die load um 6 punkte gestiegen!
> -----------------snip---------------------
> [root@srv3 root]# ps auxf
> USER       PID %CPU %MEM   VSZ  RSS TTY      STAT START   TIME COMMAND
> root         1  0.0  0.0  3528  480 ?        S    Jul17   0:05 init [3]
> root         2  0.0  0.0     0    0 ?        SW   Jul17   0:00 [keventd]
> root         3  0.0  0.0     0    0 ?        SWN  Jul17   0:00
> [ksoftirqd/0]
> root         5  0.0  0.0     0    0 ?        SW   Jul17   0:00 [bdflush]
> root         4  0.0  0.0     0    0 ?        SW   Jul17   1:38 [kswapd]
> root         6  0.0  0.0     0    0 ?        SW   Jul17   0:00 [kupdated]
> root         7  0.0  0.0     0    0 ?        SW   Jul17   0:00
> [mdrecoveryd]
> root        11  0.0  0.0     0    0 ?        SW   Jul17   0:33 [kjournald]
> root       490  0.0  0.0     0    0 ?        SW   Jul17   0:00 [kjournald]
> root       854  0.0  0.0  2904  580 ?        S    Jul17   0:03 syslogd -m
> 0
> root       858  0.0  0.0  2776  428 ?        S    Jul17   0:00 klogd -x
> root       934  0.0  0.0  2296  624 ?        S    Jul17   0:00
> /usr/sbin/smartd
> root       951  0.0  0.0  4732  980 ?        S    Jul17   0:02
> /usr/sbin/sshd
> root     13785  0.0  0.1  8072 1328 ?        S    Jul17   0:01  \_ sshd:
> root@pts/0
> root     13788  0.0  0.1  4944 1108 pts/0    S    Jul17   0:03  |   \_ -
> bash
> root      2700  0.0  0.0  5264  636 pts/0    S    13:42   0:00  |       \_
> sleep 1
> root      2497  0.0  0.1  7940 1940 ?        S    13:40   0:00  \_ sshd:
> root@pts/2
> root      2515  0.0  0.1  5316 1400 pts/2    S    13:40   0:00      \_ -
> bash
> root      2696  0.0  0.0  4216  892 pts/2    R    13:41   0:00          \_
> ps
> auxf
> root       967  0.0  0.0  3532  780 ?        S    Jul17   0:00 xinetd
> -stayalive -pidfile /var/run/xinetd.pid
> exim      1008  0.0  0.0 11888  732 ?        S    Jul17   0:00
> /usr/sbin/clamd
> exim      1018  0.0  0.0  4740  964 ?        S    Jul17   0:00
> /usr/bin/freshclam -d -p /var/run/clamav/freshclam.pid
> nobody    1028  0.0  0.0  5412  884 ?        S    Jul17   0:00 proftpd:
> (accepting connections)
> exim      1039  0.0  0.1 26656 1880 ?        S    Jul17   0:00
> /usr/bin/spamd
> -d -c -a -m5 -H -x -u exim
> root      1050  0.0  0.0  2612  472 ?        S    Jul17   0:00 spfd -file
> /var/run/spfd
> root      1087  0.0  0.0  5440  920 ?        S    Jul17   0:00 /bin/sh
> /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql
> mysql     1128  0.0  2.5 577956 25952 ?      S    Jul17   0:01  \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-
> fi
> mysql     1143  0.0  2.5 577956 25952 ?      S    Jul17   0:02      \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pi
> mysql     1144  0.0  2.5 577956 25952 ?      S    Jul17   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1145  0.0  2.5 577956 25952 ?      S    Jul17   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1146  0.0  2.5 577956 25952 ?      S    Jul17   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1147  0.0  2.5 577956 25952 ?      S    Jul17   0:04          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1172  0.0  2.5 577956 25952 ?      S    Jul17   1:24          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1173  0.0  2.5 577956 25952 ?      S    Jul17   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1192  0.0  2.5 577956 25952 ?      S    Jul17   0:07          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1193  0.0  2.5 577956 25952 ?      S    Jul17   0:08          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1217  0.0  2.5 577956 25952 ?      S    Jul17   1:08          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1218  0.1  2.5 577956 25952 ?      S    Jul17   4:10          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1219  0.0  2.5 577956 25952 ?      S    Jul17   0:26          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    24438  0.0  2.5 578084 25956 ?      S    Jul17   0:07          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    25564  0.0  2.5 578084 25956 ?      S    Jul17   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    25858  0.0  2.5 578084 25956 ?      S    Jul17   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    26099  0.0  2.5 578084 25956 ?      S    Jul17   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    26390  0.0  2.5 578084 25956 ?      S    Jul17   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    26472  0.0  2.5 578084 25956 ?      S    Jul17   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    26489  0.0  2.5 578084 25956 ?      S    Jul17   0:02          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    26519  0.0  2.5 578084 25956 ?      S    Jul17   0:06          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    27206  0.0  2.5 578084 25956 ?      S    Jul17   0:03          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    28804  0.0  2.5 578084 25956 ?      S    00:00   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    28876  0.0  2.5 578084 25956 ?      S    00:01   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    30277  0.0  2.5 578084 25956 ?      S    00:15   0:08          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    30468  0.0  2.5 578084 25956 ?      S    00:20   0:02          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    30559  0.0  2.5 578084 25956 ?      S    00:22   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    30701  0.0  2.5 578084 25956 ?      S    00:24   0:09          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    30720  0.0  2.5 578084 25956 ?      S    00:24   0:04          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    31134  0.0  2.5 578084 25956 ?      S    00:28   0:02          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    32053  0.0  2.5 578084 25956 ?      S    00:34   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    32731  0.0  2.5 578084 25956 ?      S    00:40   0:04          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql      368  0.0  2.5 578084 25956 ?      S    00:41   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql      442  0.0  2.5 578084 25956 ?      S    00:42   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql      451  0.0  2.5 578084 25956 ?      S    00:42   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1026  0.0  2.5 578084 25956 ?      S    00:46   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     2897  0.0  2.5 578084 25956 ?      S    01:01   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     6166  0.0  2.5 578084 25956 ?      S    01:31   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     7620  0.0  2.5 578084 25956 ?      S    01:43   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     8785  0.0  2.5 578084 25956 ?      S    01:53   0:01          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     8876  0.0  2.5 578084 25956 ?      S    01:53   0:02          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     8944  0.0  2.5 578084 25956 ?      S    01:54   0:03          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    17953  0.0  2.5 578084 25956 ?      S    10:58   0:02          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    23493  0.0  2.5 578084 25956 ?      S    11:49   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    27696  0.0  2.5 578084 25956 ?      S    12:32   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    28357  0.0  2.5 578084 25956 ?      S    12:37   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    28580  0.0  2.5 578084 25956 ?      S    12:39   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    28588  0.0  2.5 578084 25956 ?      S    12:39   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    28611  0.0  2.5 578084 25956 ?      S    12:39   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    28614  0.0  2.5 578084 25956 ?      S    12:39   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    28747  0.0  2.5 578084 25956 ?      S    12:40   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    29251  0.0  2.5 578084 25956 ?      S    12:46   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    29497  0.0  2.5 578084 25956 ?      S    12:47   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    29563  0.0  2.5 578084 25956 ?      S    12:48   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    29614  0.0  2.5 578084 25956 ?      S    12:49   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    29620  0.0  2.5 578084 25956 ?      S    12:49   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    30409  0.0  2.5 578084 25956 ?      S    12:55   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    30440  0.0  2.5 578084 25956 ?      S    12:55   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    31072  0.0  2.5 578084 25956 ?      S    13:00   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    31225  0.0  2.5 578084 25956 ?      S    13:02   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    31898  0.0  2.5 578084 25956 ?      S    13:08   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    32246  0.0  2.5 578084 25956 ?      S    13:11   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    32266  0.0  2.5 578084 25956 ?      S    13:11   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql    32529  0.0  2.5 578084 25956 ?      S    13:15   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql      871  0.0  2.5 578084 25956 ?      S    13:26   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1289  0.0  2.5 578084 25956 ?      S    13:30   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1381  0.0  2.5 578084 25956 ?      S    13:31   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     1562  0.0  2.5 578084 25956 ?      S    13:33   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     2159  0.0  2.5 578084 25956 ?      S    13:38   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> mysql     2699  0.0  2.5 578084 25956 ?      R    13:42   0:00          \_
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> xfs       1161  0.0  0.0  7960  600 ?        S    Jul17   0:00 xfs -
> droppriv
> -daemon
> daemon    1182  0.0  0.0  2100  564 ?        S    Jul17   0:00
> /usr/sbin/atd
> dbus      1194  0.0  0.0  3048  608 ?        S    Jul17   0:00 dbus-
> daemon-1
> --system
> root      1203  0.0  0.0  2640  400 tty1     S    Jul17   0:00
> /sbin/mingetty
> tty1
> root      1204  0.0  0.0  2344  400 tty2     S    Jul17   0:00
> /sbin/mingetty
> tty2
> root      1205  0.0  0.0  2832  400 tty3     S    Jul17   0:00
> /sbin/mingetty
> tty3
> root      1206  0.0  0.0  2036  400 tty4     S    Jul17   0:00
> /sbin/mingetty
> tty4
> root      1207  0.0  0.0  1852  400 tty5     S    Jul17   0:00
> /sbin/mingetty
> tty5
> root      1208  0.0  0.0  2356  400 tty6     S    Jul17   0:00
> /sbin/mingetty
> tty6
> root     25464  0.0  0.1 1743908 1412 ?      S    Jul17   0:25
> /usr/sbin/httpd
> apache   22735  1.3  1.7 1756696 17596 ?     S    Jul17  12:45  \_
> /usr/sbin/httpd
> apache   24368  1.2  1.7 1756744 17688 ?     R    Jul17  10:39  \_
> /usr/sbin/httpd
> apache   24371  1.0  1.7 1756604 17868 ?     S    Jul17   9:04  \_
> /usr/sbin/httpd
> apache   25641  1.2  1.8 1757736 18616 ?     S    Jul17  10:50  \_
> /usr/sbin/httpd
> apache   25665  1.1  1.8 1756848 18080 ?     S    Jul17   9:51  \_
> /usr/sbin/httpd
> apache   25684  1.1  1.8 1756812 18536 ?     S    Jul17   9:49  \_
> /usr/sbin/httpd
> apache   27860  1.1  1.8 1756724 18652 ?     S    Jul17   9:20  \_
> /usr/sbin/httpd
> apache   27874  1.2  1.8 1756844 18104 ?     S    Jul17  10:13  \_
> /usr/sbin/httpd
> apache   28899  1.1  1.8 1756788 18112 ?     S    00:02   9:46  \_
> /usr/sbin/httpd
> apache   28901  1.1  1.6 1754940 16736 ?     S    00:02   9:20  \_
> /usr/sbin/httpd
> apache   30385  0.8  1.8 1756916 18132 ?     S    00:18   6:41  \_
> /usr/sbin/httpd
> apache   30387  1.1  1.8 1756768 18344 ?     S    00:18   9:31  \_
> /usr/sbin/httpd
> apache   30389  1.0  1.8 1756824 18476 ?     S    00:18   8:29  \_
> /usr/sbin/httpd
> apache   30390  0.7  1.8 1756704 18336 ?     S    00:18   5:51  \_
> /usr/sbin/httpd
> apache   30474  0.7  0.4 1756520 4116 ?      S    00:20   5:45  \_
> /usr/sbin/httpd
> apache   30483  1.0  1.8 1756944 18100 ?     S    00:20   8:32  \_
> /usr/sbin/httpd
> apache   23686  2.6  1.6 1754940 16956 ?     S    11:52   2:55  \_
> /usr/sbin/httpd
> apache   27631  1.7  1.6 1754804 16272 ?     S    12:30   1:12  \_
> /usr/sbin/httpd
> apache   27632  1.2  1.7 1756484 17776 ?     R    12:30   0:51  \_
> /usr/sbin/httpd
> apache   27633  1.2  1.6 1755036 16248 ?     S    12:30   0:53  \_
> /usr/sbin/httpd
> apache   27641  0.9  1.6 1754892 16148 ?     R    12:30   0:40  \_
> /usr/sbin/httpd
> apache   27642  2.0  1.6 1754904 16476 ?     S    12:30   1:27  \_
> /usr/sbin/httpd
> apache   27644  1.8  1.7 1756092 17604 ?     S    12:30   1:18  \_
> /usr/sbin/httpd
> apache   27648  0.7  1.6 1754904 16028 ?     R    12:30   0:30  \_
> /usr/sbin/httpd
> apache   27649  1.4  1.8 1756496 18012 ?     S    12:30   1:03  \_
> /usr/sbin/httpd
> apache   27653  2.9  1.6 1755036 16388 ?     S    12:30   2:07  \_
> /usr/sbin/httpd
> apache   27654  1.5  1.6 1754908 16312 ?     S    12:30   1:06  \_
> /usr/sbin/httpd
> apache   27657  1.2  1.6 1754912 16344 ?     S    12:31   0:54  \_
> /usr/sbin/httpd
> apache   27658  1.9  1.6 1755692 16968 ?     S    12:31   1:24  \_
> /usr/sbin/httpd
> apache   27659  4.2  1.8 1756356 18128 ?     S    12:31   2:59  \_
> /usr/sbin/httpd
> apache   27660  2.1  1.6 1754812 16296 ?     R    12:31   1:30  \_
> /usr/sbin/httpd
> apache   27661  0.7  1.6 1754908 16012 ?     S    12:31   0:32  \_
> /usr/sbin/httpd
> apache   27675  1.6  1.6 1754808 16460 ?     S    12:31   1:11  \_
> /usr/sbin/httpd
> root     31473  0.0  0.0  2500  608 ?        S    00:30   0:00 crond
> root      2697  0.0  0.0  2500  656 ?        D    13:42   0:00  \_ CROND
> root      2698  0.0  0.0  2500  656 ?        R    13:42   0:00      \_
> CROND
> [root@srv3 root]# uptime
>  13:42:17  up 1 day, 12:11,  2 users,  load average: 7.52, 4.07, 5.48
> [root@srv3 root]#
> ------------------------snap-------------------------------------
>





--------------------------------------------------------------------------
                Apache HTTP Server Mailing List "users-de" 
      unsubscribe-Anfragen an users-de-unsubscribe@httpd.apache.org
           sonstige Anfragen an users-de-help@httpd.apache.org
--------------------------------------------------------------------------


Mime
View raw message