الاخوة الاعزاء
السلام عليكم ورحمة الله وبركاته
امل مساعدتي بضبط الاعدادات للــ my.cnf
مواصفات السيرفر :
4 معالجات
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(TM) CPU 3.06GHz
Processor #1 speed: 3067.045 MHz
Processor #1 cache size: 512 KB
الرام : 2 قيقا
وهذه نتائج الاوامر التي قد تساعد
netstat -an | grep :80 |wc -l
top c
كود PHP:
top - 21:14:34 up 8 days, 5:50, 2 users, load average: 0.95, 1.02, 0.99
Tasks: 283 total, 1 running, 275 sleeping, 0 stopped, 7 zombie
Cpu(s): 8.6% us, 2.0% sy, 0.0% ni, 85.7% id, 3.4% wa, 0.1% hi, 0.2% si
Mem: 2075092k total, 2029324k used, 45768k free, 63748k buffers
Swap: 4096564k total, 6376k used, 4090188k free, 979324k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25633 mysql 16 0 184m 101m 1676 S 14.9 5.0 3:21.31 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mys
9804 nobody 15 0 24360 17m 3668 S 11.9 0.8 0:13.16 /usr/local/apache/bin/httpd -DSSL
26717 nobody 15 0 27624 20m 3728 S 5.3 1.0 2:27.91 /usr/local/apache/bin/httpd -DSSL
6406 nobody 15 0 18972 11m 3536 S 2.7 0.6 0:00.09 /usr/local/apache/bin/httpd -DSSL
22111 mysql 15 0 184m 101m 1676 S 2.3 5.0 2:30.30 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mys
21749 nobody 15 0 27048 20m 3712 S 2.3 1.0 1:50.38 /usr/local/apache/bin/httpd -DSSL
25680 mysql 16 0 184m 101m 1676 S 0.7 5.0 3:14.87 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mys
13932 root 16 0 3324 1044 728 R 0.7 0.1 0:00.12 top
26458 root 15 0 0 0 0 S 0.3 0.0 0:07.92 [pdflush]
26320 nobody 15 0 26240 19m 3688 S 0.3 1.0 1:08.05 /usr/local/apache/bin/httpd -DSSL
6212 nobody 15 0 22516 15m 3540 S 0.3 0.8 0:00.41 /usr/local/apache/bin/httpd -DSSL
13815 nobody 15 0 21392 14m 3564 S 0.3 0.7 0:00.36 /usr/local/apache/bin/httpd -DSSL
13830 nobody 16 0 0 0 0 Z 0.3 0.0 0:00.38 [httpd] <defunct>
1 root 16 0 2716 464 392 S 0.0 0.0 0:29.51 init [3]
2 root RT 0 0 0 0 S 0.0 0.0 0:04.79 [migration/0]
3 root 34 19 0 0 0 S 0.0 0.0 0:12.28 [ksoftirqd/0]
4 root RT 0 0 0 0 S 0.0 0.0 0:05.33 [migration/1]
5 root 34 19 0 0 0 S 0.0 0.0 0:07.69 [ksoftirqd/1]
6 root RT 0 0 0 0 S 0.0 0.0 0:09.25 [migration/2]
7 root 34 19 0 0 0 S 0.0 0.0 0:10.85 [ksoftirqd/2]
8 root RT 0 0 0 0 S 0.0 0.0 0:08.32 [migration/3]
9 root 34 19 0 0 0 S 0.0 0.0 0:11.33 [ksoftirqd/3]
10 root 5 -10 0 0 0 S 0.0 0.0 3:52.75 [events/0]
11 root 5 -10 0 0 0 S 0.0 0.0 3:46.73 [events/1]
12 root 5 -10 0 0 0 S 0.0 0.0 4:08.84 [events/2]
13 root 5 -10 0 0 0 S 0.0 0.0 4:15.43 [events/3]
14 root 10 -10 0 0 0 S 0.0 0.0 0:00.01 [khelper]
29 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 [kacpid]
102 root 5 -10 0 0 0 S 0.0 0.0 0:18.86 [kblockd/0]
103 root 5 -10 0 0 0 S 0.0 0.0 2:44.51 [kblockd/1]
104 root 5 -10 0 0 0 S 0.0 0.0 2:44.52 [kblockd/2]
105 root 5 -10 0 0 0 S 0.0 0.0 0:20.96 [kblockd/3]
113 root 15 0 0 0 0 S 0.0 0.0 0:00.00 [khubd]
174 root 14 -10 0 0 0 S 0.0 0.0 0:00.00 [aio/0]
173 root 15 0 0 0 0 S 0.0 0.0 12:15.67 [kswapd0]
175 root 14 -10 0 0 0 S 0.0 0.0 0:00.00 [aio/1]
1470 root 15 0 0 0 0 S 0.0 0.0 0:00.21 [kjournald]
top m
كود PHP:
top - 21:15:32 up 8 days, 5:51, 2 users, load average: 0.94, 1.00, 0.98
Tasks: 277 total, 3 running, 267 sleeping, 0 stopped, 7 zombie
Cpu(s): 7.3% us, 1.7% sy, 0.0% ni, 89.5% id, 1.3% wa, 0.0% hi, 0.2% si
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
22795 mysql 16 0 188m 103m 1676 R 15.9 5.1 2:29.96 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mys
32003 mysql 16 0 188m 103m 1676 S 4.3 5.1 8:15.98 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mys
13991 nobody 16 0 20152 13m 3564 S 3.6 0.6 0:00.19 /usr/local/apache/bin/httpd -DSSL
6390 nobody 15 0 21656 14m 3588 S 2.3 0.7 0:01.54 /usr/local/apache/bin/httpd -DSSL
13819 nobody 15 0 19732 12m 3584 S 2.3 0.6 0:00.16 /usr/local/apache/bin/httpd -DSSL
13988 nobody 15 0 19872 12m 3544 S 2.3 0.6 0:00.22 /usr/local/apache/bin/httpd -DSSL
8585 root 15 0 1636 652 544 S 0.3 0.0 8:58.36 /usr/sbin/portsentry -atcp
6240 nobody 16 0 22540 15m 3592 S 0.3 0.8 0:05.76 /usr/local/apache/bin/httpd -DSSL
6397 nobody 15 0 23396 16m 3648 S 0.3 0.8 0:01.21 /usr/local/apache/bin/httpd -DSSL
6679 nobody 15 0 21496 14m 3592 S 0.3 0.7 0:00.98 /usr/local/apache/bin/httpd -DSSL
13932 root 16 0 3324 1048 728 R 0.3 0.1 0:00.44 top
13987 nobody 15 0 23076 15m 3548 S 0.3 0.8 0:00.18 /usr/local/apache/bin/httpd -DSSL
13993 nobody 15 0 0 0 0 Z 0.3 0.0 0:00.02 [httpd] <defunct>
1 root 16 0 2716 464 392 S 0.0 0.0 0:29.51 init [3]
2 root RT 0 0 0 0 S 0.0 0.0 0:04.79 [migration/0]
3 root 34 19 0 0 0 S 0.0 0.0 0:12.28 [ksoftirqd/0]
4 root RT 0 0 0 0 S 0.0 0.0 0:05.33 [migration/1]
5 root 34 19 0 0 0 S 0.0 0.0 0:07.69 [ksoftirqd/1]
6 root RT 0 0 0 0 S 0.0 0.0 0:09.25 [migration/2]
7 root 34 19 0 0 0 S 0.0 0.0 0:10.85 [ksoftirqd/2]
8 root RT 0 0 0 0 S 0.0 0.0 0:08.32 [migration/3]
9 root 34 19 0 0 0 S 0.0 0.0 0:11.33 [ksoftirqd/3]
10 root 5 -10 0 0 0 S 0.0 0.0 3:52.76 [events/0]
11 root 5 -10 0 0 0 S 0.3 0.8 0:01.20 /usr/local/apache/bin/httpd -DSSL
13818 nobody 15 0 20560 13m 3572 S 0.3 0.7 0:00.53 /usr/local/apache/bin/httpd -DSSL
13991 nobody 15 0 19236 12m 3544 S 0.3 0.6 0:00.08 /usr/local/apache/bin/httpd -DSSL
13996 nobody 15 0 20484 13m 3544 S 0.3 0.7 0:00.25 /usr/local/apache/bin/httpd -DSSL
1 root 16 0 2716 464 392 S 0.0 0.0 0:29.51 init [3]
2 root RT 0 0 0 0 S 0.0 0.0 0:04.79 [migration/0]
3 root 34 19 0 0 0 S 0.0 0.0 0:12.28 [ksoftirqd/0]
4 root RT 0 0 0 0 S 0.0 0.0 0:05.33 [migration/1]
5 root 34 19 0 0 0 S 0.0 0.0 0:07.69 [ksoftirqd/1]
6 root RT 0 0 0 0 S 0.0 0.0 0:09.25 [migration/2]
7 root 34 19 0 0 0 S 0.0 0.0 0:10.85 [ksoftirqd/2]
8 root RT 0 0 0 0 S 0.0 0.0 0:08.32 [migration/3]
9 root 34 19 0 0 0 S 0.0 0.0 0:11.33 [ksoftirqd/3]
10 root 5 -10 0 0 0 S 0.0 0.0 3:52.76 [events/0]
11 root 5 -10 0 0 0 S 0.0 0.0 3:46.73 [events/1]
12 root 5 -10 0 0 0 S 0.0 0.0 4:08.84 [events/2]
cat /etc/my.cnf
كود PHP:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=700
interactive_timeout=100
wait_timeout=3600
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=2
myisam_sort_buffer_size=64M
server-id=1
[mysql.server]
user=mysql
basedir=mysql
[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=20M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
mysqladmin status
كود PHP:
Uptime: 161766 Threads: 12 Questions: 4527452 Slow queries: 300 Opens: 58369 Flush tables: 1 Open tables: 1024 Queries per second avg: 27.988
مالفت انتباهي هي القيمة العالية للــ
wait_timeout=3600
اعتقد انه من سبب ثقل التصفح بالسيرفر واستهلاك الذاكره
فما رايكم
تحياتي