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:[EMAIL PROTECTED]
> Sent: Monday, July 18, 2005 1:44 PM
> To: [email protected]
> Subject: RE: apache2 performance
>
>
> On 18.07.05 at 13:33:38 [+0200], Thomas Goik <[EMAIL PROTECTED]>
> wrote:
> beispiel:
> load 1.5
> ich rufe die seite auf
> und schlagartig ist die load um 6 punkte gestiegen!
> -----------------snip---------------------
> [EMAIL PROTECTED] 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:
> [EMAIL PROTECTED]/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:
> [EMAIL PROTECTED]/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
> [EMAIL PROTECTED] root]# uptime
> 13:42:17 up 1 day, 12:11, 2 users, load average: 7.52, 4.07, 5.48
> [EMAIL PROTECTED] root]#
> ------------------------snap-------------------------------------
>
--------------------------------------------------------------------------
Apache HTTP Server Mailing List "users-de"
unsubscribe-Anfragen an [EMAIL PROTECTED]
sonstige Anfragen an [EMAIL PROTECTED]
--------------------------------------------------------------------------
