Geschwindigkeit optimieren

MySQL, PostgreSQL, SQLite
tobias1985
Posts: 68
Joined: 2004-04-15 11:01

Geschwindigkeit optimieren

Post by tobias1985 » 2005-08-15 15:29

Hi,
ich hab das Problem dass mittlerweile wohl zuviel ansturm auf meinem Server ist. Auf jeden Fall ist es tagsüber grausam langsam beim laden der Webseiten.
(testen: http://www.losefreaks.de/ http://www.bercki.de/ http://www.dream-mailer.de/ und noch viele mehr)

System: Suse Linux 9.0
Hardware: Strato Highend-Sever (Celeron 2,4 Ghz, 512MB Ram)

"mysqladmin version" liefert folgendes:
Server version 4.0.15
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 14 hours 8 min 13 sec

Threads: 91 Questions: 506331 Slow queries: 26 Opens: 3628 Flush tables: 1 Open tables: 256 Queries per second avg: 9.949
In /etc/my.cnf ist MySQL wie folgt konfiguriert:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 64M
set-variable = max_connections=2500
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
"php -v" gibt folgendes zurück:
PHP 4.3.3 (cgi) (built: Apr 22 2005 12:00:14)
Copyright (c) 1997-2003 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies
with eAccelerator v0.9.3, Copyright (c) 2004-2004 eAccelerator, by eAccelerator
Hat hier jemand eine Idee? Weil eigentlich sollte der Server doch damit klar kommen.
Ich bin der Haupt-User auf dem Server. Das heißt da laufen noch ein paar kleinere Homepages drauf, welche aber nur selten Zugriffe haben.
Die Statistik von Webalizer meines confixx-users für August beläuft sich auf:

Hits per Hour
Avg 6.331
Max 28.748

Hits per Day
Avg 151.955
Max 268.865

Visits per Day
Avg 1.112
Max 2.240

KBytes per Day
Avg 587.558
Max 1.404.341

Danke schonmal an alle die mir helfen. :)

User avatar
Joe User
Project Manager
Project Manager
Posts: 11139
Joined: 2003-02-27 01:00
Location: Hamburg

Re: Geschwindigkeit optimieren

Post by Joe User » 2005-08-15 15:40

PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.

stefanpropehan
Posts: 335
Joined: 2002-12-17 22:25
Location: Berlin

Re: Geschwindigkeit optimieren

Post by stefanpropehan » 2005-08-15 15:43

Poste mal eine Ausgabe von "pstree"...

Guter Ansatz ist außerdem sich mal die Abfragen zu beschauen die den Server in die Knie zwingen... Stichwörter "long_query_time" und "log-slow-queries" um dann evtl. Ã?nderungen am Datenbanklayout zu treffen.

tobias1985
Posts: 68
Joined: 2004-04-15 11:01

Re: Geschwindigkeit optimieren

Post by tobias1985 » 2005-08-15 15:54

stefanpropehan wrote:Poste mal eine Ausgabe von "pstree"...

Guter Ansatz ist außerdem sich mal die Abfragen zu beschauen die den Server in die Knie zwingen... Stichwörter "long_query_time" und "log-slow-queries" um dann evtl. Ã?nderungen am Datenbanklayout zu treffen.
init-+-agetty
|-bdflush
|-cron---cron
|-dhcpcd
|-httpd2-prefork-+-48*[httpd2-prefork]
| `-2*[pipelog.pl]
|-keventd
|-khubd
|-2*[kjournald]
|-klogd
|-ksoftirqd_CPU0
|-kswapd
|-kupdated
|-master-+-pickup
| `-qmgr
|-6*[mingetty]
|-mysqld_safe---mysqld---mysqld---25*[mysqld]
|-named---named---3*[named]
|-nscd---nscd---5*[nscd]
|-4*[pipelog.pl]
|-portmap
|-saslauthd---4*[saslauthd]
|-sshd---sshd-+-bash---pstree
| `-sshd
|-startpar
|-syslogd
`-xinetd
@Joe User: Schau ich mir gleich mal an die Links.

tobias1985
Posts: 68
Joined: 2004-04-15 11:01

Re: Geschwindigkeit optimieren

Post by tobias1985 » 2005-08-15 16:16

@Joe User: Beides geändert. Und rcapache2 restart und rcmysql restart gemacht.
Ist aber immer noch so langsam. :(

vevelt
Posts: 122
Joined: 2003-08-01 12:18
Location: Itzehoe

Re: Geschwindigkeit optimieren

Post by vevelt » 2005-08-15 16:32

Eine Ausgabe von TOP wäre zu unterschiedlichen Zeiten auch ganz ratsam. Soweit ich denke, wird der Server wohl etwas knapp mit Speicher ausgerüstet sein... zudem mußt du mal schauen, ob du auf ein wenig Sicherheit zugunsten von Geschwindigkeit verzichten kannst/willst:

Apache2: Prefork --> Worker
PHP: CGI --> ApacheModul

Zudem kann es bei dem knappen Speicher nützen, PHP so schlank wie möglich zu kompilieren, d.h. nur die nötigsten Extensions einkompilieren...

Gruß, Vevelt.

tobias1985
Posts: 68
Joined: 2004-04-15 11:01

Re: Geschwindigkeit optimieren

Post by tobias1985 » 2005-08-15 16:47

Vevelt wrote:Eine Ausgabe von TOP wäre zu unterschiedlichen Zeiten auch ganz ratsam. Soweit ich denke, wird der Server wohl etwas knapp mit Speicher ausgerüstet sein... zudem mußt du mal schauen, ob du auf ein wenig Sicherheit zugunsten von Geschwindigkeit verzichten kannst/willst:

Apache2: Prefork --> Worker
PHP: CGI --> ApacheModul

Zudem kann es bei dem knappen Speicher nützen, PHP so schlank wie möglich zu kompilieren, d.h. nur die nötigsten Extensions einkompilieren...

Gruß, Vevelt.

Hier mal die Ausgabe von ps aux. Die Ausgabe von top bekomm ich irgendwie nicht komplett hin.
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 620 72 ? S Jul22 0:06 init [3]
root 2 0.0 0.0 0 0 ? SW Jul22 0:00 [keventd]
root 3 0.0 0.0 0 0 ? SWN Jul22 0:00 [ksoftirqd_CPU0]
root 4 0.0 0.0 0 0 ? SW Jul22 0:07 [kswapd]
root 5 0.0 0.0 0 0 ? SW Jul22 0:00 [bdflush]
root 6 0.0 0.0 0 0 ? SW Jul22 0:00 [kupdated]
root 9 0.0 0.0 0 0 ? SW Jul22 0:00 [khubd]
root 10 0.0 0.0 0 0 ? SW Jul22 1:52 [kjournald]
root 55 0.0 0.0 0 0 ? SW Jul22 0:00 [kjournald]
root 431 0.0 0.0 1520 444 ? S Jul22 0:00 /sbin/dhcpcd -H -D -N -t 999999 -h linux eth0
root 498 0.0 0.1 1560 604 ? S Jul22 2:21 /sbin/syslogd -a /var/lib/named/dev/log
root 501 0.0 0.3 2464 1600 ? S Jul22 0:00 /sbin/klogd -c 1 -2
bin 520 0.0 0.0 1516 304 ? S Jul22 0:00 /sbin/portmap
root 530 0.0 0.2 5660 1424 ? S Jul22 1:02 /usr/sbin/saslauthd -a pam
root 557 0.0 0.2 5660 1412 ? S Jul22 1:02 /usr/sbin/saslauthd -a pam
root 558 0.0 0.2 5660 1416 ? S Jul22 1:01 /usr/sbin/saslauthd -a pam
root 559 0.0 0.2 5660 1428 ? S Jul22 1:01 /usr/sbin/saslauthd -a pam
root 560 0.0 0.2 5660 1424 ? S Jul22 1:03 /usr/sbin/saslauthd -a pam
root 564 0.0 0.1 2172 760 ? S Jul22 0:07 /usr/sbin/xinetd
root 602 0.0 0.2 4912 1092 ? S Jul22 0:01 /usr/sbin/sshd -o PidFile=/var/run/sshd.init.pid
root 614 0.0 0.0 1352 228 ? S Jul22 0:00 /sbin/startpar -f -- /etc/init.d/rc3.d/S12named
named 622 0.0 0.2 11268 1328 ? S Jul22 0:00 /usr/sbin/named -t /var/lib/named -u named
named 623 0.0 0.2 11268 1328 ? S Jul22 0:00 /usr/sbin/named -t /var/lib/named -u named
named 624 0.0 0.2 11268 1328 ? S Jul22 0:00 /usr/sbin/named -t /var/lib/named -u named
named 625 0.0 0.2 11268 1328 ? S Jul22 0:00 /usr/sbin/named -t /var/lib/named -u named
named 626 0.0 0.2 11268 1328 ? S Jul22 0:00 /usr/sbin/named -t /var/lib/named -u named
root 798 0.0 0.2 4168 1120 ? S Jul22 2:27 /usr/lib/postfix/master
root 869 0.0 0.1 12272 740 ? S Jul22 0:31 /usr/sbin/nscd
root 870 0.0 0.1 1516 552 ? S Jul22 0:00 /usr/sbin/cron
root 873 0.0 0.1 12272 740 ? S Jul22 0:00 /usr/sbin/nscd
root 874 0.0 0.1 12272 740 ? S Jul22 0:31 /usr/sbin/nscd
root 875 0.0 0.1 12272 740 ? S Jul22 0:01 /usr/sbin/nscd
root 876 0.0 0.1 12272 740 ? S Jul22 0:00 /usr/sbin/nscd
root 877 0.0 0.1 12272 740 ? S Jul22 0:01 /usr/sbin/nscd
root 878 0.0 0.1 12272 740 ? S Jul22 0:00 /usr/sbin/nscd
root 880 0.0 0.0 1500 440 tty1 S Jul22 0:00 /sbin/mingetty --noclear tty1
root 881 0.0 0.0 1500 440 tty2 S Jul22 0:00 /sbin/mingetty tty2
root 882 0.0 0.0 1500 440 tty3 S Jul22 0:00 /sbin/mingetty tty3
root 883 0.0 0.0 1500 440 tty4 S Jul22 0:00 /sbin/mingetty tty4
root 884 0.0 0.0 1500 440 tty5 S Jul22 0:00 /sbin/mingetty tty5
root 886 0.0 0.0 1500 440 tty6 S Jul22 0:00 /sbin/mingetty tty6
root 1990 0.0 0.0 1492 428 ttyS0 S Jul22 0:00 /sbin/agetty -L 57600 ttyS0 vt102
postfix 3452 0.0 0.2 4332 1312 ? S Aug09 0:32 qmgr -l -t fifo -u
root 29252 0.0 0.2 3312 1264 ? S 00:46 0:00 /usr/bin/perl /root/srvreport-0.70/bin/pipelog.pl
root 29253 0.0 0.2 3312 1300 ? S 00:46 0:00 /usr/bin/perl /root/confixx/pipelog.pl
root 29378 0.0 0.2 3312 1076 ? S 00:47 0:00 /usr/bin/perl /root/srvreport-0.70/bin/pipelog.pl
root 29379 0.0 0.2 3312 1096 ? S 00:47 0:00 /usr/bin/perl /root/confixx/pipelog.pl
root 9239 0.0 0.4 5576 2188 ? S 15:39 0:01 sshd: root@pts/0
root 9243 0.0 0.4 5576 2188 ? S 15:39 0:00 sshd: root@pts/0
root 9245 0.0 0.3 2836 1684 pts/0 S 15:39 0:00 -bash
root 11893 0.0 0.2 2704 1204 pts/0 S 16:00 0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --socket=/var/lib/mysql/mysql.sock --datadir=/var/lib/mysql
mysql 11925 0.0 7.2 133052 37416 pts/0 S 16:00 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 11926 0.0 7.2 133052 37416 pts/0 S 16:00 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 11927 0.0 7.2 133052 37416 pts/0 S 16:00 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 11942 1.5 7.2 133052 37416 pts/0 R 16:00 0:27 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 11946 1.3 7.2 133052 37416 pts/0 S 16:00 0:22 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12002 1.5 7.2 133052 37416 pts/0 R 16:01 0:26 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12003 1.6 7.2 133052 37416 pts/0 S 16:01 0:27 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
root 12088 0.0 2.2 44420 11492 ? S 16:01 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
root 12089 0.0 0.2 3312 1404 ? S 16:01 0:00 /usr/bin/perl /root/confixx/pipelog.pl
root 12090 0.0 0.2 3312 1376 ? S 16:01 0:00 /usr/bin/perl /root/srvreport-0.70/bin/pipelog.pl
wwwrun 12100 0.0 2.3 44884 12272 ? S 16:01 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12103 0.0 2.6 45020 13820 ? S 16:01 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12110 0.0 2.7 45188 14008 ? S 16:01 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12115 0.0 2.4 45020 12792 ? S 16:02 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12116 0.0 2.6 45016 13636 ? S 16:02 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12122 0.0 2.4 44884 12460 ? S 16:02 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12134 0.0 2.7 45020 13956 ? S 16:02 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12137 0.0 2.3 44884 12316 ? S 16:02 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12144 1.4 7.0 132024 36388 pts/0 R 16:03 0:23 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12152 1.2 7.0 132024 36388 pts/0 S 16:03 0:20 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12153 1.1 7.0 132024 36388 pts/0 S 16:03 0:18 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12181 1.3 7.0 132024 36388 pts/0 R 16:03 0:20 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12185 0.0 2.4 44884 12408 ? S 16:03 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12187 0.9 7.0 132024 36388 pts/0 S 16:03 0:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12200 1.2 7.0 132024 36388 pts/0 R 16:03 0:18 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12202 1.0 7.0 132024 36388 pts/0 S 16:03 0:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12211 0.9 7.0 132024 36388 pts/0 S 16:03 0:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12217 1.4 7.0 132024 36388 pts/0 S 16:03 0:22 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12222 0.0 2.4 44884 12428 ? S 16:03 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12223 0.0 2.4 44884 12668 ? S 16:03 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12231 0.0 2.3 44884 12264 ? S 16:03 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12236 1.3 7.0 132024 36388 pts/0 S 16:04 0:20 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12237 0.0 2.3 44884 12268 ? S 16:04 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12249 0.0 2.6 45148 13840 ? S 16:04 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12252 0.9 7.0 132024 36388 pts/0 S 16:04 0:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12254 1.2 7.0 132024 36388 pts/0 S 16:04 0:18 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12261 1.2 7.0 132024 36388 pts/0 S 16:04 0:19 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12282 1.1 7.0 132024 36388 pts/0 S 16:04 0:18 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12284 1.1 7.0 132024 36388 pts/0 S 16:04 0:17 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12285 1.2 7.0 132024 36388 pts/0 S 16:04 0:19 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12306 1.2 7.0 132024 36388 pts/0 S 16:04 0:19 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12326 0.0 2.7 45120 14008 ? S 16:05 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12336 1.4 7.0 132024 36388 pts/0 R 16:06 0:20 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12341 0.0 2.3 44884 12276 ? S 16:06 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12357 1.3 7.0 132024 36388 pts/0 R 16:06 0:18 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12360 0.0 2.3 44884 12300 ? S 16:06 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12415 1.1 7.0 132024 36388 pts/0 S 16:10 0:13 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12420 0.0 2.5 45096 13096 ? S 16:10 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12423 1.3 7.0 132024 36388 pts/0 S 16:10 0:14 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12426 1.1 7.0 132024 36388 pts/0 S 16:10 0:12 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12429 1.1 7.0 132024 36388 pts/0 R 16:11 0:13 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12430 0.9 7.0 132024 36388 pts/0 S 16:11 0:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12439 0.0 2.6 45016 13636 ? S 16:11 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12451 0.0 2.4 44884 12424 ? S 16:11 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12460 0.0 2.3 44884 12268 ? S 16:13 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12464 1.1 7.0 132024 36388 pts/0 R 16:13 0:11 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12465 1.0 7.0 132024 36388 pts/0 R 16:13 0:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12533 0.0 2.3 44884 12264 ? S 16:15 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12544 0.0 2.7 45096 14104 ? S 16:16 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12545 0.0 2.4 44884 12472 ? S 16:16 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12547 0.0 2.3 44884 12264 ? S 16:16 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12549 1.2 7.0 132024 36388 pts/0 S 16:16 0:09 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12553 1.2 7.0 132024 36388 pts/0 R 16:16 0:09 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12555 1.3 7.0 132024 36388 pts/0 R 16:16 0:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12556 1.2 7.0 132024 36388 pts/0 S 16:16 0:09 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12557 1.2 7.0 132024 36388 pts/0 R 16:16 0:09 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12559 0.0 2.4 45016 12724 ? S 16:16 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12562 1.4 7.0 132024 36388 pts/0 R 16:16 0:10 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12571 0.0 2.4 44884 12392 ? S 16:17 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12582 0.0 2.6 45016 13744 ? S 16:19 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
postfix 12590 0.0 0.2 4204 1344 ? S 16:19 0:00 pickup -l -t fifo -u
mysql 12595 0.9 7.0 132024 36388 pts/0 S 16:19 0:05 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12612 0.0 2.3 44884 12264 ? S 16:20 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12614 0.0 2.3 44884 12264 ? S 16:20 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12615 1.1 7.0 132024 36388 pts/0 R 16:20 0:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12616 1.1 7.0 132024 36388 pts/0 R 16:20 0:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12621 1.5 7.0 132024 36388 pts/0 R 16:20 0:09 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12625 0.0 2.4 44884 12392 ? S 16:20 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12628 0.0 2.3 44884 12296 ? S 16:20 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12631 0.0 2.3 44884 12260 ? S 16:20 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12634 0.0 2.3 44884 12256 ? S 16:20 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12636 1.1 7.0 132288 36404 pts/0 S 16:20 0:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12637 1.1 7.0 132288 36404 pts/0 S 16:20 0:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12645 0.8 7.0 132288 36404 pts/0 S 16:21 0:04 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12648 0.0 2.3 44884 12256 ? S 16:21 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12649 1.2 7.0 132288 36404 pts/0 S 16:21 0:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12653 0.0 2.3 44884 12292 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12654 0.0 2.3 44884 12268 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12657 0.0 2.5 45004 13032 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12660 0.0 2.3 44884 12252 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12661 1.1 7.0 132288 36404 pts/0 S 16:22 0:05 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12662 0.0 2.4 44884 12388 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12666 0.0 2.3 44884 12240 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12668 0.6 7.0 132288 36404 pts/0 S 16:22 0:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12669 0.8 7.0 132288 36404 pts/0 S 16:22 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12670 0.0 2.3 44884 12256 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12671 1.1 7.0 132288 36404 pts/0 S 16:22 0:04 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12675 0.8 7.0 132288 36404 pts/0 S 16:22 0:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12678 0.0 2.3 44884 12232 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12682 0.0 2.3 44884 12252 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12684 1.4 7.0 132288 36404 pts/0 S 16:22 0:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12685 1.1 7.0 132288 36404 pts/0 S 16:22 0:05 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12688 0.0 2.3 44884 12252 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12689 1.3 7.0 132288 36404 pts/0 S 16:22 0:05 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12690 0.0 2.4 44896 12584 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12691 0.0 2.3 44884 12268 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12697 0.0 2.3 44884 12260 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12700 0.0 2.3 44884 12244 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12701 0.0 2.3 44884 12252 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12702 0.0 2.3 44884 12240 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12703 0.1 2.7 45240 14308 ? S 16:22 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12706 1.4 7.0 132288 36404 pts/0 S 16:22 0:06 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12707 1.1 7.0 132288 36404 pts/0 R 16:22 0:04 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12712 1.1 7.0 132288 36404 pts/0 R 16:22 0:05 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12713 0.9 7.0 132288 36404 pts/0 S 16:22 0:04 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12716 0.0 2.3 44884 12264 ? S 16:23 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12745 0.0 2.3 44884 12252 ? S 16:25 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12746 0.0 2.3 44884 12244 ? S 16:25 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12747 0.0 2.3 44884 12252 ? S 16:25 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12748 0.0 2.3 44884 12244 ? S 16:25 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12749 0.0 2.3 44884 12244 ? S 16:25 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12755 1.0 7.0 132288 36404 pts/0 R 16:26 0:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12757 0.0 2.3 44884 12232 ? S 16:26 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12758 0.0 2.3 44884 12228 ? S 16:26 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12759 0.0 2.3 44884 12224 ? S 16:26 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12760 0.1 2.7 45136 14112 ? S 16:26 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12762 1.0 7.0 132288 36404 pts/0 R 16:26 0:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12763 1.0 7.0 132288 36404 pts/0 R 16:26 0:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12766 1.0 7.0 132288 36404 pts/0 S 16:26 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12767 1.5 7.0 132288 36404 pts/0 S 16:26 0:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12768 0.0 2.3 44884 12240 ? S 16:26 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12770 1.0 2.8 110700 14852 pts/0 S 16:26 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12771 0.9 2.8 110700 14852 pts/0 S 16:26 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12773 0.0 2.3 44884 12224 ? S 16:26 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12774 0.0 2.3 44884 12236 ? S 16:26 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12778 0.0 2.3 44884 12232 ? S 16:27 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12780 0.0 2.3 44884 12240 ? S 16:27 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12781 0.0 2.4 44900 12644 ? S 16:27 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12782 0.0 2.8 110700 14852 pts/0 S 16:27 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12783 1.1 2.8 110700 14852 pts/0 S 16:27 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12784 0.0 2.3 44884 12236 ? S 16:27 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12785 0.0 2.3 44884 12224 ? S 16:27 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12786 0.0 2.3 44884 12288 ? S 16:27 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12787 0.0 2.3 44884 12244 ? S 16:27 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12788 1.2 2.8 110700 14852 pts/0 S 16:27 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12789 1.4 2.8 110700 14852 pts/0 S 16:27 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12790 1.4 2.8 110700 14852 pts/0 S 16:27 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12794 0.0 2.3 44884 12228 ? S 16:27 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12799 0.0 2.3 44752 12192 ? S 16:28 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12804 0.0 2.3 44752 12196 ? S 16:28 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12805 0.7 2.8 110700 14852 pts/0 S 16:28 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12806 0.6 2.8 110700 14852 pts/0 S 16:28 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12807 0.7 2.8 110700 14852 pts/0 S 16:28 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12808 0.0 2.3 44752 12196 ? S 16:28 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12809 0.0 2.3 44752 12180 ? S 16:28 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12810 0.0 2.3 44752 12180 ? S 16:28 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
root 12811 0.0 0.0 0 0 ? Z 16:29 0:00 [cron] <defunct>
wwwrun 12813 0.0 2.3 44752 12180 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12814 0.8 2.8 110700 14852 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12816 0.0 2.3 44752 12188 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12817 0.0 2.3 44752 12180 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12818 0.0 2.3 44752 12208 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12819 0.0 2.3 44752 12192 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12820 0.0 2.3 44752 12196 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12821 0.0 2.3 44752 12196 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12822 0.8 2.8 110700 14852 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12823 0.8 2.8 110700 14852 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12824 0.9 2.8 110700 14852 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12825 1.0 2.8 110700 14852 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12826 0.0 2.3 44888 12248 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12827 0.0 2.3 44752 12180 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12828 0.0 2.3 44752 12180 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12829 1.0 2.8 110700 14852 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12830 0.0 2.3 44888 12248 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12831 1.2 2.8 110700 14852 pts/0 R 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12832 1.1 2.8 110700 14852 pts/0 R 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12833 1.1 2.8 110700 14852 pts/0 R 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12834 1.1 2.8 110700 14852 pts/0 R 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12835 0.0 2.3 44752 12196 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12836 1.0 2.8 110700 14852 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12837 0.0 2.3 44752 12192 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12838 0.0 2.3 44752 12196 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
nobody 12839 0.0 0.1 2220 928 ? S 16:29 0:00 vsftpd
web2 12841 0.0 0.1 2244 984 ? S 16:29 0:00 vsftpd
wwwrun 12842 0.1 2.4 44908 12444 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
postfix 12845 0.0 0.3 5224 1800 ? S 16:29 0:00 cleanup -z -t unix -u
postfix 12846 0.0 0.3 5068 1692 ? S 16:29 0:00 trivial-rewrite -n rewrite -t unix -u
postfix 12847 0.0 0.3 4352 1640 ? S 16:29 0:00 local -t unix
mysql 12848 2.1 2.6 109672 13824 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12850 0.0 2.3 44752 12168 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
wwwrun 12851 0.1 2.3 44752 12168 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12852 0.0 2.6 109672 13824 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12853 0.0 2.6 109672 13824 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12854 0.0 2.6 109672 13824 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
wwwrun 12855 0.0 2.2 44488 11560 ? S 16:29 0:00 /usr/sbin/httpd2-prefork -f /etc/apache2/httpd.conf -DSSL
mysql 12856 0.0 2.6 109672 13824 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
root 12857 0.0 0.1 2668 724 pts/0 R 16:29 0:00 ps aux
mysql 12858 0.0 2.6 109672 13824 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
mysql 12859 0.0 2.6 109672 13824 pts/0 S 16:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking

tobias1985
Posts: 68
Joined: 2004-04-15 11:01

Re: Geschwindigkeit optimieren

Post by tobias1985 » 2005-08-15 18:02

So ich hab den Server mal neugestartet weils unerträglich war mit der Geschwindigkeit. Hat aber nichts gebracht.
Also bin ich nun mal in die Datenbanken und hab Sachen rausgelöscht die ich löschen konnte. (IPs, Logs etc...)
Dadurch hab ich bei allen 7 DBs zusammen fast 100 MB gelöscht.

Und jetzt ist plötzlich alles wieder schnell. Kommt MySQL mit großen Datenbanken nicht zurecht?
Die größten Datenbanken haben nun ca. 1 MB, 2 MB, 6 MB und 185 MB.
Und damit läuft nun alles wieder richtig schnell.
Langsam lief es als die 6MB-DB fast 40MB hatte und die 185MB-DB ca. 250 MB hatte. War das etwa schon zuviel für den Server?

Es ist so dass ich ein paar Tabellen in jeder DB habe in denen sehr viele Selects, Inserts, Updates gemacht werden. Während ich hier schreibe hat zum Beispiel eine der Tabellen schon wieder 482 Einträge und 39,5KB. Und das innerhalb diesen 2-3 Minuten in denen ich diesen Beitrag schreibe.
Generell haben alle Tabellen bei mir den Typ MyISAM. Wäre da ein anderer Tabellen-Typ sinnvoller der nicht gleich den ganzen Server lahm legt nur weil massig Daten drinstecken?
Klar wenn ich nen Select mache und dort ein paar hunderttausend Einträge drin sind und diese Selects ständig passieren (tausende male am Tag) dann kostet das wohl zuviel Performance. Aber gibts sonst ne Lösung?

User avatar
Joe User
Project Manager
Project Manager
Posts: 11139
Joined: 2003-02-27 01:00
Location: Hamburg

Re: Geschwindigkeit optimieren

Post by Joe User » 2005-08-15 19:53

tobias1985 wrote:Aber gibts sonst ne Lösung?
Ja: Queries optimieren und meine Configs, abgesehen von den Pfaden, unverändert übernehmen (insbesondere die Ã?nderung der php.ini).
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.

tobias1985
Posts: 68
Joined: 2004-04-15 11:01

Re: Geschwindigkeit optimieren

Post by tobias1985 » 2005-08-15 19:58

Joe User wrote:
tobias1985 wrote:Aber gibts sonst ne Lösung?
Ja: Queries optimieren und meine Configs, abgesehen von den Pfaden, unverändert übernehmen (insbesondere die Ã?nderung der php.ini).
Ok. Deine Configs hab ich bereits übernommen. Für die PHP.ini hab ich deinen Befehl ausgeführt:

Code: Select all

sed 's/allow_persistent = On/allow_persistent = Off/g' -i /etc/php.ini
Queries optimieren werde ich noch machen, falls noch möglich.
Danke!!!

alexander newald
Posts: 1117
Joined: 2002-09-27 00:54
Location: Hannover

Re: Geschwindigkeit optimieren

Post by alexander newald » 2005-08-16 04:03

Noch ein paar Hints von mir:

wenns langsam wird, öfter mal ein ps xauwr machen, und schauen, welche Prozesse immer wieder in der Liste sind.

Bei den Datenbank(en) und hier bei den Tabellen sinnvolle Indexes verwendet?

mysql> show full processlist;

und dann aus der Spate Info die Abfrage kopieren und ein

mysql> explain ABFRAGE

posten

rudi
Posts: 69
Joined: 2004-12-08 19:10

Re: Geschwindigkeit optimieren

Post by rudi » 2005-08-17 07:00

tobias1985 wrote:
Joe User wrote:
tobias1985 wrote:Aber gibts sonst ne Lösung?
Ja: Queries optimieren und meine Configs, abgesehen von den Pfaden, unverändert übernehmen (insbesondere die Ã?nderung der php.ini).
Ok. Deine Configs hab ich bereits übernommen. Für die PHP.ini hab ich deinen Befehl ausgeführt:

Code: Select all

sed 's/allow_persistent = On/allow_persistent = Off/g' -i /etc/php.ini
Queries optimieren werde ich noch machen, falls noch möglich.
Danke!!!
Was bewirkt "allow_persistent = off" genau? Ist das jedem zu empfehlen?

User avatar
Joe User
Project Manager
Project Manager
Posts: 11139
Joined: 2003-02-27 01:00
Location: Hamburg

Re: Geschwindigkeit optimieren

Post by Joe User » 2005-08-17 09:35

rudi wrote:Was bewirkt "allow_persistent = off" genau?
http://www.php.net/manual/en/features.p ... ctions.php
rudi wrote:Ist das jedem zu empfehlen?
Ja.
PayPal.Me/JoeUserFreeBSD Remote Installation
Wings for LifeWings for Life World Run

„If there’s more than one possible outcome of a job or task, and one
of those outcomes will result in disaster or an undesirable consequence,
then somebody will do it that way.“ -- Edward Aloysius Murphy Jr.