Yuksek Load

[root@server2 ~]# cat /etc/my.cnf
[mysqld]
safe-show-database

skip-locking
safe-show-database
#old-passwords

interactive_timeout=100
wait_timeout=100
connect_timeout=10
max_user_connections=500
max_connections=500

key_buffer=64M
join_buffer=2M
record_buffer=2M
sort_buffer=4M
max_allowed_packet=24M

query_cache_limit = 2M
query_cache_size = 64M
query_cache_type = 1

table_cache=2048
thread_cache=256
thread_concurrency=2

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

#log_slow_queries=/var/log/slow-queries.log
#log-long-format
#long_query_time=6
[root@server2 ~]#

[root@server2 ~]# uname -a
Linux server2.fileskd.com 2.6.19.1.SM #5 SMP Sun Dec 31 19:30:51 CET 2006 i686 i686 i386 GNU/Linux
[root@server2 ~]#

[root@server2 ~]# ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 81920
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
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 81920
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@server2 ~]#

top - 18:10:43 up 1 day, 8:23, 1 user, load average: 2.26, 4.55, 5.06
Tasks: 261 total, 4 running, 257 sleeping, 0 stopped, 0 zombie
Cpu(s): 21.8% us, 2.7% sy, 0.0% ni, 72.1% id, 1.2% wa, 0.1% hi, 2.1% si
Mem: 4128176k total, 3966684k used, 161492k free, 18932k buffers
Swap: 2096472k total, 128k used, 2096344k free, 3107388k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
30703 apache 16 0 30276 11m 3752 S 8 0.3 0:01.30 httpd
31105 apache 16 0 30236 11m 3740 S 8 0.3 0:00.06 httpd
30696 apache 16 0 30276 11m 3780 S 6 0.3 0:01.19 httpd
31087 apache 15 0 30316 11m 3748 S 6 0.3 0:01.05 httpd
31104 apache 16 0 30140 11m 3760 S 6 0.3 0:00.14 httpd
31106 apache 15 0 30112 11m 3728 S 6 0.3 0:00.03 httpd
31107 apache 16 0 30112 11m 3728 S 6 0.3 0:00.03 httpd
31089 apache 15 0 30292 11m 3828 R 4 0.3 0:00.86 httpd
31095 apache 16 0 30500 11m 3792 R 4 0.3 0:00.51 httpd
25324 apache 18 0 30760 12m 4296 S 2 0.3 0:01.91 httpd
28629 apache 15 0 30292 11m 3868 S 2 0.3 0:02.13 httpd
31092 apache 16 0 30336 12m 4276 S 2 0.3 0:00.60 httpd
31094 apache 15 0 30276 11m 3780 S 2 0.3 0:00.43 httpd
1 root 15 0 1692 552 476 S 0 0.0 0:00.65 init
2 root RT 0 0 0 0 S 0 0.0 0:00.02 migration/0
3 root 39 19 0 0 0 S 0 0.0 0:00.05 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.00 watchdog/0

[root@server2 ~]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 CPU 6600 @ 2.40GHz
stepping : 6
cpu MHz : 2400.000
cache size : 4096 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr lahf_lm
bogomips : 4791.50

processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 15
model name : Intel(R) Core(TM)2 CPU 6600 @ 2.40GHz
stepping : 6
cpu MHz : 2400.000
cache size : 4096 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr lahf_lm
bogomips : 4788.13

[root@server2 ~]#

[root@server2 ~]# free
total used free shared buffers cached
Mem: 4128176 3970276 157900 0 18808 3124020
-/+ buffers/cache: 827448 3300728
Swap: 2096472 128 2096344
[root@server2 ~]#

Timeout 300
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 8
StartServers 15
MinSpareServers 15
MaxSpareServers 13
ServerLimit 1500
MaxClients 1250

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=8M
query_cache_size=256M
query_cache_type=1
max_connections=500
max_user_connections=8
interactive_timeout=10
wait_timeout=10
connect_timeout=3
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=8M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=8
myisam_sort_buffer_size=64M
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M

Timeout 30
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 2
MinSpareServers 8
MaxSpareServers 13
StartServers 18
MaxClients 2048
MaxRequestsPerChild 500