Hi Guys,
Some people have complained about not being able to access my site and I believe it's probably to do with the configuration of Apache.
Here are some details on the server:
- Website utilizes WordPress and has various different plug-ins.
- Daily traffic is around 12,000 uniques and 80,000 + page views with around 100-400 visitors trying to access the Website at any one time.
- Heavy use of PHP/mySQL
Below are my.cnf stats:
[mysqld]
skip-external-locking
skip-slave-start
skip-bdb
skip-innodb
skip-name-resolve
# Global mem settings
key_buffer = 24M
max_connections = 200
# Per client mem settings
sort_buffer_size = 4M
read_buffer_size = 4M
binlog_cache_size = 2M
max_allowed_packet = 12M
thread_stack = 128K
table_cache = 128
thread_cache = 256
thread_concurrency = 4
myisam_sort_buffer_size = 1M
tmp_table_size = 12M
max_heap_table_size = 12M
wait_timeout = 200
interactive_timeout = 300
max_connect_errors = 10000
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 16M
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
Below are my http.conf stats:
ErrorLog "logs/error_log"
DefaultType text/plain
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 2
MinSpareServers 10
MaxSpareServers 40
MaxRequestsPerChild 100
MaxClients 150
StartServers 40
Thanks guys, just looking for some advice as I really don't have any idea if these are optimum settings. Here are some real-time TOP statistics:
top - 15:58:12 up 1 day, 7:04, 2 users, load average: 0.96, 0.99, 1.09
Tasks: 179 total, 1 running, 160 sleeping, 18 stopped, 0 zombie
Cpu(s): 18.5% us, 3.5% sy, 0.0% ni, 77.1% id, 0.9% wa, 0.0% hi, 0.0% si
Mem: 4147160k total, 2849924k used, 1297236k free, 303488k buffers
Swap: 2040212k total, 208k used, 2040004k free, 1811064k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
9338 nobody 16 0 47148 20m 12m S 19.9 0.5 0:02.98 httpd
9375 nobody 16 0 47468 21m 12m S 16.3 0.5 0:02.23 httpd
5771 mysql 15 0 73640 44m 2620 S 14.0 1.1 215:27.03 mysqld
9297 nobody 15 0 47460 21m 12m S 8.6 0.5 0:03.80 httpd
9372 nobody 17 0 47396 21m 11m S 7.6 0.5 0:00.62 httpd
9346 nobody 16 0 47104 20m 12m S 4.7 0.5 0:03.55 httpd
9317 nobody 15 0 47420 22m 13m S 4.0 0.6 0:02.83 httpd
9306 nobody 16 0 47424 21m 12m S 3.0 0.5 0:04.44 httpd
9319 nobody 16 0 47412 21m 12m S 3.0 0.5 0:04.79 httpd
9295 nobody 16 0 47472 21m 12m S 2.3 0.5 0:03.45 httpd
9301 nobody 15 0 47476 22m 13m S 1.0 0.6 0:05.86 httpd
9322 nobody 15 0 47436 22m 13m S 1.0 0.6 0:04.41 httpd
8372 root 16 0 3432 1080 772 R 0.7 0.0 0:13.71 top
9327 nobody 15 0 47144 20m 12m S 0.7 0.5 0:02.02 httpd
9384 nobody 15 0 45888 10m 3256 S 0.7 0.3 0:00.02 httpd
9383 nobody 16 0 46428 18m 10m S 0.3 0.5 0:00.09 httpd