Sunucu bu aralar çok kasıyor, top aşağıdaki gibi; my.cnf ayarı
[mysqld]
local-infile=0
max_connections=100
query_cache_size=512M
table_cache=320
tmp_table_size=103M
thread_cache_size=8
myisam_sort_buffer_size=256M
key_buffer_size=768M
sort_buffer_size=1M
wait_timeout = 10
connect_timeout = 10
mysql iyi görünüyor ama apache bağlantıları için httpconf ayarlamak gerekiyor sanırım onda nasıl bir optimizasyon yapabilirim acaba???? 271 sleeping durumunda bağlantı var bunlarda sanırım cpu yiyordur...
server:~# top
top - 15:34:40 up 100 days, 14:26, 1 user, load average: 45.10, 42.63, 40.90
Tasks: 304 total, 33 running, 271 sleeping, 0 stopped, 0 zombie
Cpu(s): 93.7%us, 5.7%sy, 0.0%ni, 0.3%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 3360988k total, 2389316k used, 971672k free, 355988k buffers
Swap: 2650684k total, 0k used, 2650684k free, 1196724k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
16851 mysql 16 0 1346m 311m 3832 R 4 9.5 0:00.25 mysqld
12685 apache 16 0 27864 13m 4012 R 4 0.4 0:04.72 httpd
14226 apache 15 0 27192 13m 4004 S 4 0.4 0:03.15 httpd
16924 mysql 16 0 1346m 311m 3832 R 4 9.5 0:00.11 mysqld
14262 apache 16 0 27164 13m 4008 R 3 0.4 0:02.39 httpd
16586 apache 15 0 26900 13m 3976 S 3 0.4 0:00.48 httpd
2165 apache 15 0 26932 13m 4192 S 3 0.4 0:16.91 httpd
13502 apache 15 0 26932 13m 4188 S 3 0.4 0:03.73 httpd
13601 apache 16 0 27208 13m 4188 R 3 0.4 0:04.16 httpd
15298 apache 15 0 26920 13m 4180 R 3 0.4 0:02.00 httpd
15325 apache 15 0 26924 13m 3988 S 3 0.4 0:02.38 httpd
15892 apache 15 0 26912 13m 4012 S 3 0.4 0:01.38 httpd
12985 apache 15 0 26956 13m 4008 S 3 0.4 0:04.06 httpd
14228 apache 15 0 27872 13m 4284 S 3 0.4 0:03.11 httpd
14698 apache 15 0 26948 13m 4008 S 3 0.4 0:02.62 httpd
15895 apache 15 0 27872 13m 4456 S 3 0.4 0:00.95 httpd
16896 mysql 16 0 1346m 311m 3832 R 3 9.5 0:00.23 mysqld
10160 apache 16 0 26940 13m 4188 S 2 0.4 0:06.68 httpd
12905 apache 15 0 27476 13m 4008 S 2 0.4 0:03.77 httpd
13409 apache 15 0 26928 13m 4184 S 2 0.4 0:03.81 httpd
13503 apache 15 0 26956 13m 4192 S 2 0.4 0:03.85 httpd
13606 apache 15 0 26956 13m 4008 S 2 0.4 0:03.41 httpd
16561 apache 15 0 27844 13m 3980 S 2 0.4 0:00.33 httpd
4223 apache 15 0 26952 13m 4192 S 2 0.4 0:14.52 httpd
6115 apache 15 0 26944 13m 4408 S 2 0.4 0:12.88 httpd
6148 apache 15 0 26932 13m 4472 S 2 0.4 0:12.56 httpd
8974 apache 15 0 26956 13m 4192 S 2 0.4 0:10.56 httpd
12811 apache 15 0 27736 13m 4012 S 2 0.4 0:04.57 httpd
12968 apache 15 0 27208 13m 4012 S 2 0.4 0:04.11 httpd
14169 apache 15 0 26948 13m 4408 S 2 0.4 0:02.52 httpd
15396 apache 15 0 26956 13m 4008 S 2 0.4 0:01.82 httpd
16560 apache 16 0 26924 13m 4004 S 2 0.4 0:00.64 httpd
16570 apache 15 0 26896 12m 3976 S 2 0.4 0:00.52 httpd
6014 apache 15 0 26948 13m 4464 S 2 0.4 0:12.01 httpd
6791 apache 15 0 26944 13m 4200 S 2 0.4 0:11.56 httpd
7715 apache 15 0 27256 13m 4260 S 2 0.4 0:10.57 httpd
10158 apache 15 0 26996 13m 4068 S 2 0.4 0:08.31 httpd
10889 apache 15 0 26924 13m 4468 S 2 0.4 0:06.37 httpd
11420 apache 15 0 26952 13m 4188 S 2 0.4 0:06.26 httpd
12918 apache 15 0 26956 13m 4184 S 2 0.4 0:04.10 httpd
12960 apache 15 0 26948 13m 4184 S 2 0.4 0:03.41 httpd
12965 apache 15 0 26932 13m 4464 S 2 0.4 0:04.07 httpd
13537 apache 15 0 26932 13m 4008 S 2 0.4 0:04.38 httpd
14198 apache 15 0 27036 13m 4084 S 2 0.4 0:02.40 httpd
14263 apache 15 0 26932 13m 4016 S 2 0.4 0:02.66 httpd
14703 apache 15 0 26948 13m 4004 S 2 0.4 0:02.62 httpd
15309 apache 15 0 27164 13m 4000 S 2 0.4 0:01.82 httpd
15393 apache 15 0 26956 13m 4004 S 2 0.4 0:01.52 httpd
15897 apache 15 0 26948 13m 4008 S 2 0.4 0:00.88 httpd
15898 apache 15 0 26948 13m 4004 S 2 0.4 0:00.94 httpd
16458 apache 15 0 27584 13m 3944 S 2 0.4 0:00.73 httpd
2761 apache 15 0 26948 13m 4476 S 1 0.4 0:16.77 httpd
3485 apache 15 0 26912 13m 4196 S 1 0.4 0:14.34 httpd
4245 apache 15 0 26944 13m 4192 S 1 0.4 0:14.76 httpd
6130 apache 15 0 26928 13m 4460 S 1 0.4 0:12.58 httpd
[mysqld]
local-infile=0
max_connections=100
query_cache_size=512M
table_cache=320
tmp_table_size=103M
thread_cache_size=8
myisam_sort_buffer_size=256M
key_buffer_size=768M
sort_buffer_size=1M
wait_timeout = 10
connect_timeout = 10
mysql iyi görünüyor ama apache bağlantıları için httpconf ayarlamak gerekiyor sanırım onda nasıl bir optimizasyon yapabilirim acaba???? 271 sleeping durumunda bağlantı var bunlarda sanırım cpu yiyordur...
server:~# top
top - 15:34:40 up 100 days, 14:26, 1 user, load average: 45.10, 42.63, 40.90
Tasks: 304 total, 33 running, 271 sleeping, 0 stopped, 0 zombie
Cpu(s): 93.7%us, 5.7%sy, 0.0%ni, 0.3%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 3360988k total, 2389316k used, 971672k free, 355988k buffers
Swap: 2650684k total, 0k used, 2650684k free, 1196724k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
16851 mysql 16 0 1346m 311m 3832 R 4 9.5 0:00.25 mysqld
12685 apache 16 0 27864 13m 4012 R 4 0.4 0:04.72 httpd
14226 apache 15 0 27192 13m 4004 S 4 0.4 0:03.15 httpd
16924 mysql 16 0 1346m 311m 3832 R 4 9.5 0:00.11 mysqld
14262 apache 16 0 27164 13m 4008 R 3 0.4 0:02.39 httpd
16586 apache 15 0 26900 13m 3976 S 3 0.4 0:00.48 httpd
2165 apache 15 0 26932 13m 4192 S 3 0.4 0:16.91 httpd
13502 apache 15 0 26932 13m 4188 S 3 0.4 0:03.73 httpd
13601 apache 16 0 27208 13m 4188 R 3 0.4 0:04.16 httpd
15298 apache 15 0 26920 13m 4180 R 3 0.4 0:02.00 httpd
15325 apache 15 0 26924 13m 3988 S 3 0.4 0:02.38 httpd
15892 apache 15 0 26912 13m 4012 S 3 0.4 0:01.38 httpd
12985 apache 15 0 26956 13m 4008 S 3 0.4 0:04.06 httpd
14228 apache 15 0 27872 13m 4284 S 3 0.4 0:03.11 httpd
14698 apache 15 0 26948 13m 4008 S 3 0.4 0:02.62 httpd
15895 apache 15 0 27872 13m 4456 S 3 0.4 0:00.95 httpd
16896 mysql 16 0 1346m 311m 3832 R 3 9.5 0:00.23 mysqld
10160 apache 16 0 26940 13m 4188 S 2 0.4 0:06.68 httpd
12905 apache 15 0 27476 13m 4008 S 2 0.4 0:03.77 httpd
13409 apache 15 0 26928 13m 4184 S 2 0.4 0:03.81 httpd
13503 apache 15 0 26956 13m 4192 S 2 0.4 0:03.85 httpd
13606 apache 15 0 26956 13m 4008 S 2 0.4 0:03.41 httpd
16561 apache 15 0 27844 13m 3980 S 2 0.4 0:00.33 httpd
4223 apache 15 0 26952 13m 4192 S 2 0.4 0:14.52 httpd
6115 apache 15 0 26944 13m 4408 S 2 0.4 0:12.88 httpd
6148 apache 15 0 26932 13m 4472 S 2 0.4 0:12.56 httpd
8974 apache 15 0 26956 13m 4192 S 2 0.4 0:10.56 httpd
12811 apache 15 0 27736 13m 4012 S 2 0.4 0:04.57 httpd
12968 apache 15 0 27208 13m 4012 S 2 0.4 0:04.11 httpd
14169 apache 15 0 26948 13m 4408 S 2 0.4 0:02.52 httpd
15396 apache 15 0 26956 13m 4008 S 2 0.4 0:01.82 httpd
16560 apache 16 0 26924 13m 4004 S 2 0.4 0:00.64 httpd
16570 apache 15 0 26896 12m 3976 S 2 0.4 0:00.52 httpd
6014 apache 15 0 26948 13m 4464 S 2 0.4 0:12.01 httpd
6791 apache 15 0 26944 13m 4200 S 2 0.4 0:11.56 httpd
7715 apache 15 0 27256 13m 4260 S 2 0.4 0:10.57 httpd
10158 apache 15 0 26996 13m 4068 S 2 0.4 0:08.31 httpd
10889 apache 15 0 26924 13m 4468 S 2 0.4 0:06.37 httpd
11420 apache 15 0 26952 13m 4188 S 2 0.4 0:06.26 httpd
12918 apache 15 0 26956 13m 4184 S 2 0.4 0:04.10 httpd
12960 apache 15 0 26948 13m 4184 S 2 0.4 0:03.41 httpd
12965 apache 15 0 26932 13m 4464 S 2 0.4 0:04.07 httpd
13537 apache 15 0 26932 13m 4008 S 2 0.4 0:04.38 httpd
14198 apache 15 0 27036 13m 4084 S 2 0.4 0:02.40 httpd
14263 apache 15 0 26932 13m 4016 S 2 0.4 0:02.66 httpd
14703 apache 15 0 26948 13m 4004 S 2 0.4 0:02.62 httpd
15309 apache 15 0 27164 13m 4000 S 2 0.4 0:01.82 httpd
15393 apache 15 0 26956 13m 4004 S 2 0.4 0:01.52 httpd
15897 apache 15 0 26948 13m 4008 S 2 0.4 0:00.88 httpd
15898 apache 15 0 26948 13m 4004 S 2 0.4 0:00.94 httpd
16458 apache 15 0 27584 13m 3944 S 2 0.4 0:00.73 httpd
2761 apache 15 0 26948 13m 4476 S 1 0.4 0:16.77 httpd
3485 apache 15 0 26912 13m 4196 S 1 0.4 0:14.34 httpd
4245 apache 15 0 26944 13m 4192 S 1 0.4 0:14.76 httpd
6130 apache 15 0 26928 13m 4460 S 1 0.4 0:12.58 httpd