 | | | Apache Mysql Optimization ? | Apache Mysql Optimization ? 2004-01-06 - By vishal@(protected)
Back
Hello All,
Redhat 9 (shrike)
Mysql 4.0.15
Apache 1.3.29
PHP 4.3.3
Server Conf
============
[4 CPUs] Dual Xeon 2.4 1GB RAM 73GB SCSI, 80GB IDE HD
No of Sites : only 2 (which are very Busy and mysql intensive )
Http.conf
=========
Timeout 300
KeepAlive On
MaxKeepAliveRequests 120
KeepAliveTimeout 10
MinSpareServers 10
MaxSpareServers 20
StartServers 5
MaxClients 512
MaxRequestsPerChild 1000
my.cnf
======
[mysqld]
set-variable = max_connections=700
safe-show-database
key_buffer = 200M
myisam_sort_buffer_size = 64M
join_buffer_size = 8M
read_buffer_size = 8M
sort_buffer_size = 12M
table_cache = 1028
thread_cache_size = 800
wait_timeout = 10
interactive_timeout=10
connect_timeout = 10
max_allowed_packet = 32M
max_connect_errors = 10
thread_concurrency=4
query_cache_limit = 2M
query_cache_size = 45M
query_cache_type = 1
skip-innodb
log-slow-queries = /var/log/mysql_slow_query_log
long_query_time = 5
[mysqld_safe]
err-log=/var/log/mysqld.log
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[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
Turck-MMCache Enabled (Zend Extension)
top
====
05:46:25 up 12 days, 17:35, 3 users, load average: 7.46, 9.02, 10.76
509 processes: 501 sleeping, 6 running, 1 zombie, 1 stopped
CPU0 states: 64.2% user 19.1% system 0.1% nice 0.0% iowait 16.0%
idle
CPU1 states: 64.0% user 19.1% system 0.0% nice 0.0% iowait 16.3%
idle
CPU2 states: 60.3% user 23.1% system 0.0% nice 0.0% iowait 16.0%
idle
CPU3 states: 60.2% user 20.5% system 0.0% nice 0.0% iowait 18.3%
idle
Mem: 1030244k av, 912116k used, 118128k free, 0k shrd, 187872k
buff
534216k actv, 49792k in_d, 18180k in_c
Swap: 2096440k av, 132220k used, 1964220k free 441464k
cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
12228 mysql 15 0 23588 20M 1444 S 99.9 2.0 56:42 3 mysqld
3419 root 15 0 2676 1684 1616 S 7.0 0.1 13:57 1 httpd
Can Anyone please tell me why I am not able to get the Load Down and the
site Load Faster.The server load is always above 5.00
Thanks in Advance.
Earn $52 per hosting referral at Lunarpages.
|
|
|