System Information
===================
Fedora Core 4
Plesk 8.01
Intel® Pentium 4 CPU 3.00GHz HTT
120 GB Drive
2GB RAM
mysql-4.1.2
apache-2.0.54
php 5.04
eAccelerator
zend
mod security installed

ps -aux | grep -c http
75
ps -aux | grep -c mysql
3


http.conf

Timeout 12
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 25
MaxSpareServers 45
StartServers 15
Serverlimit 256
MaxClients 256
MaxRequestsPerChild 1000


uname -a
Linux ip-server.net 2.6.17-1.2142_FC4smp #1 SMP Tue Jul 11 22:57:
02 EDT 2006 i686 i686 i386 GNU/Linux


# hdparm -Tt /dev/sda

/dev/sda:
Timing cached reads: 3092 MB in 2.00 seconds = 1547.45 MB/sec
Timing buffered disk reads: 148 MB in 3.01 seconds = 49.23 MB/sec



my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 8
query_cache_limit = 1M
query_cache_size = 128M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

free -m
total used free shared buffers cached
Mem: 2018 1961 57 0 37 680
-/+ buffers/cache: 1244 774
Swap: 2000 23 1976

vmstat 1
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
0 0 24536 54264 38296 692612 0 0 16 80 348 271 4 1 94 2
0 0 24536 53716 38308 692860 0 0 224 852 474 116 0 1 92 7
0 0 24536 53624 38308 692860 0 0 0 436 349 4602 9 3 88 0
0 0 24536 53624 38308 692860 0 0 0 0 352 126 1 0 99 0
0 0 24536 53624 38308 692860 0 0 0 0 274 45 0 0 100 0
0 0 24536 53500 38312 692856 0 0 0 288 335 62 0 1 100 0
0 0 24536 53548 38320 693108 0 0 0 68 288 62 0 0 100 0
0 0 24536 53548 38320 693108 0 0 0 0 299 38 0 0 100 0
0 0 24536 53548 38320 693108 0 0 0 132 340 78 0 0 100 0
1 0 24536 54244 38324 690504 0 0 128 272 346 1131 15 42 44 0
2 0 24536 54044 38332 690496 0 0 0 352 323 2185 11 41 48 0
0 0 24536 55408 38340 690488 0 0 0 280 333 771 4 10 87 0
0 0 24536 55408 38340 690488 0 0 0 0 320 175 0 1 98 0
0 0 24536 57912 38332 687376 0 0 84 0 397 222 6 3 87 5
0 1 24536 58052 38348 687360 0 0 32 0 399 380 7 4 85 4
0 0 24536 58116 38364 687344 0 0 164 724 476 453 8 4 85 2
0 0 24536 57992 38368 687340 0 0 0 16 325 85 0 0 100 0
0 0 24536 58240 38368 687340 0 0 0 0 355 172 0 1 99 0
0 0 24536 58256 38372 687336 0 0 0 188 285 65 0 0 100 0
0 0 24536 58132 38376 687332 0 0 0 80 368 200 0 1 99 0
0 0 24536 57560 38380 687588 0 0 100 0 367 564 4 2 90 4


top
0 0 24536 58776 38860 685808 0 0 0 512 502 77 0 0 99 0
top - 01:26:20 up 12 days, 14:17, 1 user, load average: 0.23, 0.17, 0.18
Tasks: 199 total, 1 running, 198 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0% us, 3.3% sy, 4.5% ni, 91.9% id, 0.2% wa, 0.0% hi, 0.2% si
Mem: 2066976k total, 2009572k used, 57404k free, 39208k buffers
Swap: 2048276k total, 24536k used, 2023740k free, 687280k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6799 apache 19 4 68656 40m 17m S 6.0 2.0 2:33.23 httpd
2246 mysql 21 6 273m 179m 5328 S 5.0 8.9 178:19.39 mysqld
26936 apache 19 4 65572 35m 15m S 2.3 1.7 0:17.24 httpd
18110 apache 19 4 68888 40m 18m S 0.7 2.0 2:09.29 httpd
18100 root 16 0 2172 1108 820 R 0.7 0.1 0:00.05 top
6785 apache 19 4 69592 41m 18m S 0.3 2.0 2:30.68 httpd
6790 apache 19 4 68900 40m 17m S 0.3 2.0 2:18.58 httpd
6812 apache 19 4 76808 48m 17m S 0.3 2.4 2:32.75 httpd
26932 apache 19 4 65176 34m 15m S 0.3 1.7 0:17.98 httpd
1 root 16 0 1780 644 548 S 0.0 0.0 0:01.59 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.04 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.65 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:01.10 ksoftirqd/1
7 root RT 0 0 0 0 S 0.0 0.0 0:00.00 watchdog/1

This post was last modified: 10-05-2006 06:51 AM by spicegirl.

What's the problem you're having here because the loads seems pretty alright to me. And also what kind of websites this server has hosted?

Right now there's about 10 sites on the server with one having heavy traffic utilizing php, mysql and a few cgi scripts not using mysql. The site has streaming music/video files, forum, news, etc.

The majority of the sites are mostly small entertainment sites running php scripts and mysql (forum/store)

However this wasn't the peak time. I'll try to get stats posted during peak time for you to look at.

Thanks for reviewing what I posted.

Statistics at a peak time will be helpful .. Now there you have 'variety in a box', so it will be a difficult optimization. Have to keep balance between both static content and dynamic content optimizations.