xp240032bit to amd64bit, server loads shot up
i run a php/mysql driven site.on an xp2400 512mb freebsd 32bit system my loads were 1-2, cpu 70-90%
i moved to a amd64 2800 1gm ram 64bit centos (running xampp) and loads when up to 30, i tweaked and got them to around 3 right now.
------------------------------------------------------------
here is my webmin running processes list
PU load averages: 3.04 (1 mins) , 2.83 (5 mins) , 4.69 (15 mins)
Process ID Owner CPU Command
6824 nobody 83.5 % /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql --use ...
7166 nobody 0.2 % /opt/lampp/bin/httpd -k start -DSSL -DPHP5
7168 nobody 0.2 % /opt/lampp/bin/httpd -k start -DSSL -DPHP5
3687 nobody 0.1 % thttpd -r -d /home/quizfarm/images/ -h 65.98.38.219
6257 root 0.1 % top
6957 nobody 0.1 % /opt/lampp/bin/httpd -k start -DSSL -DPHP5
... etc. lots more /opt/lampp/bin/httpd -k start -DSSL -DPHP5 entries
------------------------------------------------------------------
here is top
21:55:01 up 7:28, 2 users, load average: 5.85, 25.97, 29.51
162 processes: 158 sleeping, 4 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 88.4% 0.0% 11.1% 0.0% 0.3% 0.0% 0.0%
Mem: 1009868k av, 576260k used, 433608k free, 0k shrd, 103888k buff
436792k active, 80836k inactive
Swap: 2096440k av, 0k used, 2096440k free 171444k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
2332 nobody 15 0 385M 61M 3480 S 93.9 6.2 115:22 0 mysqld
6089 nobody 16 0 41040 15M 5748 S 0.5 1.5 0:00 0 httpd
6155 nobody 16 0 40984 15M 5800 S 0.5 1.5 0:00 0 httpd
6126 nobody 15 0 40916 15M 5736 S 0.3 1.5 0:00 0 httpd
3687 nobody 15 0 26464 21M 19960 S 0.1 2.1 0:06 0 thttpd
6021 nobody 15 0 39364 13M 5780 S 0.1 1.4 0:00 0 httpd
6071 nobody 16 0 39512 14M 5776 S 0.1 1.4 0:00 0 httpd
6107 nobody 16 0 40840 15M 5680 S 0.1 1.5 0:00 0 httpd
6162 nobody 17 0 39408 13M 5800 S 0.1 1.4 0:00 0 httpd
6257 root 16 0 38840 1336 984 R 0.1 0.1 0:00 0 top
1 root 16 0 2668 524 452 S 0.0 0.0 0:00 0 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
4 root 10 -5 0 0 0 SW< 0.0 0.0 0:00 0 events/0
5 root 10 -5 0 0 0 SW< 0.0 0.0 0:00 0 khelper
------------------------------------------
my.cnf settings
[mysqld]
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-locking
key_buffer=16M
max_allowed_packet=1M
table_cache=1024
sort_buffer=1M
read_buffer=1M
record_buffer=1M
connect_timeout=10
myisam_sort_buffer_size=64M
thread_cache=128
max_connections=1000
wait_timeout=100
join_buffer=1M
thread_concurrency=2
max_connect_errors=10
set-variable = interactive_timeout=100
query-cache-size = 32M
query-cache-type = 2
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin
server-id = 1
# Point the following paths to different dedicated disks
tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
open_files_limit=8192
[isamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
[mysqlhotcopy]
interactive-timeout
-------------------------------------
httpd.conf settings
Timeout 30
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
<IfModule prefork.c>
StartServers 7
MinSpareServers 5
MaxSpareServers 30
MaxClients 180
MaxRequestsPerChild 1000
</IfModule>
<IfModule worker.c>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
<IfModule perchild.c>
NumServers 5
StartThreads 5
MinSpareThreads 5
MaxSpareThreads 10
MaxThreadsPerChild 20
MaxRequestsPerChild 0
</IfModule>
also, what is the deal with the three different MPMs, ie. # prefork MPM, worker MPM, and perchild MPM
----------------------------------------------------
i am also running eaccellerator (but i don't have much repetitive content so i don't know how useful it is)
--------------
any advice?