Server Optimizing Request
 

Hi,,
I have dedicated server has only main site
but I get load in the server

top
Code:
top - 20:50:16 up 1:29, 1 user, load average: 1.66, 1.14, 0.64
Tasks: 139 total, 2 running, 137 sleeping, 0 stopped, 0 zombie
Cpu(s): 53.5%us, 2.0%sy, 0.0%ni, 42.3%id, 1.5%wa, 0.2%hi, 0.5%si, 0.0%st
Mem: 2042576k total, 1248764k used, 793812k free, 4036k buffers
Swap: 3919840k total, 0k used, 3919840k free, 408432k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21673 apache 20 0 295m 22m 4156 R 30 1.2 0:09.62 httpd
21829 apache 20 0 292m 19m 4132 S 12 1.0 0:04.52 httpd
Code:
after hitting 1
top - 20:51:06 up 1:30, 1 user, load average: 1.45, 1.17, 0.67
Tasks: 138 total, 1 running, 137 sleeping, 0 stopped, 0 zombie
Cpu0 : 9.7%us, 0.0%sy, 0.0%ni, 90.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 16.3%us, 0.3%sy, 0.0%ni, 81.0%id, 0.0%wa, 0.3%hi, 2.0%si, 0.0%st
Mem: 2042576k total, 1280188k used, 762388k free, 4092k buffers
Swap: 3919840k total, 0k used, 3919840k free, 434060k cached
my.cnf
Code:
safe-show-database
query_cache_limit=1M
query_cache_size=128M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=300
max_connections=500
interactive_timeout=300
wait_timeout=300
connect_timeout=20
thread_cache_size=40
key_buffer=512M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=45M
table_cache=1024
record_buffer=1M
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
collation-server=latin1_general_ci
[mysql.server]
user=mysql
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=45M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=94M
sort_buffer=94M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
Code:
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15

StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 400
MaxClients 400
MaxRequestsPerChild 4000


Code:
uname -a
Linux educbh.com 2.6.27.21rootserver-20090324a #1 SMP Tue Mar 24 04:59:16 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
Code:
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 16248
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 16248
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
Code:
[root@educbh etc]# cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 75
model name : AMD Athlon(tm) 64 X2 Dual Core Processor 4200+
stepping : 2
cpu MHz : 1800.000
cache size : 512 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt rdtscp lm 3dnowext 3dnow rep_good nopl pni cx16 lahf_lm cmp_legacy svm extapic cr8_legacy
bogomips : 3616.40
TLB size : 1024 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp tm stc
processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 75
model name : AMD Athlon(tm) 64 X2 Dual Core Processor 4200+
stepping : 2
cpu MHz : 1800.000
cache size : 512 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
apicid : 1
initial apicid : 1
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt rdtscp lm 3dnowext 3dnow rep_good nopl pni cx16 lahf_lm cmp_legacy svm extapic cr8_legacy
bogomips : 3616.40
TLB size : 1024 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp tm stc
Code:
dmesg | grep -i CPU
[ 0.000000] Initializing cgroup subsys cpuset
[ 0.000000] Initializing cgroup subsys cpu
[ 0.000000] KERNEL supported cpus:
[ 0.000000] SMP: Allowing 2 CPUs, 0 hotplug CPUs
[ 0.000000] PERCPU: Allocating 48544 bytes of per cpu data
[ 0.000000] NR_CPUS: 8, nr_cpu_ids: 2, nr_node_ids 1
[ 0.000000] Initializing CPU#0
[ 0.080003] Initializing cgroup subsys cpuacct
[ 0.100009] CPU: L1 I Cache: 64K (64 bytes/line), D cache 64K (64 bytes/line)
[ 0.110002] CPU: L2 Cache: 512K (64 bytes/line)
[ 0.120002] CPU 0/0 -> Node 0
[ 0.130004] CPU: Physical Processor ID: 0
[ 0.140001] CPU: Processor Core ID: 0
[ 0.285678] CPU0: AMD Athlon(tm) 64 X2 Dual Core Processor 4200+ stepping 02
[ 0.010000] Initializing CPU#1
[ 0.010000] CPU: L1 I Cache: 64K (64 bytes/line), D cache 64K (64 bytes/line)
[ 0.010000] CPU: L2 Cache: 512K (64 bytes/line)
[ 0.010000] CPU 1/1 -> Node 0
[ 0.010000] CPU: Physical Processor ID: 0
[ 0.010000] CPU: Processor Core ID: 1
[ 0.480171] CPU1: AMD Athlon(tm) 64 X2 Dual Core Processor 4200+ stepping 02
[ 0.500011] Brought up 2 CPUs
[ 0.510092] CPU0 attaching sched-domain:
[ 0.510094] domain 0: span 0-1 level CPU
[ 0.510106] CPU1 attaching sched-domain:
[ 0.510108] domain 0: span 0-1 level CPU
[ 1.780616] microcode: CPU0 not a capable Intel processor
[ 1.791418] microcode: CPU1 not a capable Intel processor
[ 8.855751] powernow-k8: Found 1 AMD Athlon(tm) 64 X2 Dual Core Processor 4200+ processors (2 cpu cores) (version 2.20.00)