Optimizing Apache and MySQL
I am running two newish xserves for serving websites. I've read lots of conflicting information about how to improve performance in Apache and MySQL and I am hoping someone here can help out.
Machine stats:
Dual 2.66Ghz Dual Core Intel Xeon
8 Gb RAM
2 280Gb drives
Here are the pertinent settings in httpd.conf:
[code]ExtendedStatus Off
Timeout 15
KeepAlive On
MaxKeepAliveRequests 200
KeepAliveTimeout 4
MinSpareServers 15
MaxSpareServers 40
StartServers 20
MaxClients 300
MaxRequestsPerChild 0[/code]
And MySQL's my.cnf:
[code]skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=900
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=128
#key_buffer=16M
key_buffer=200M
join_buffer=1M
max_allowed_packet=16M
table_cache=512M
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=1M
max_connect_errors=10
tmp_table_size = 384M
thread_concurrency=4
myisam_sort_buffer_size=64M
#log-bin
server-id=1
skip-thread-priority[/code]
Please let me know if i can give any more information. I hope someone out there will have also dealt with this, or could at least post the relevant portions of their httpd.conf and my.cnf.
Thank you in advance