Please guys help me. I have a site with high traffic. Sometimes over 1k people online. I just got this brand new server because my other server was crashing all the time.
I need to configure my.cnf and appache to handle the traffic without issues.
Server stats.
Dual Intel Xeon 5639 2.13Ghz - 2 Processors
12 Cores / 24 Threads
24GB DDR3 RAM
Current My.cnf config:
[mysqld]
key_buffer=32M
myisam_sort_buffer_size=64M
join_buffer=2M
sort_buffer=2M
table_cache=2048
thread_cache_size=512
connect_timeout=60
wait_timeout=500
interactive_timeout=500
max_allowed_packet=16M
tmp_table_size=128M
max_heap_table_size=128M
query_cache_limit = 2M
query_cache_size = 512M
query_cache_type = 1
#open_files_limit = 20000
thread_concurrency=16
max_connections=1000
log-slow-queries
local-infile=0
connect_timeout = 60
Current httpd.conf config
<IfModule prefork.c>
StartServers 20
MinSpareServers 15
MaxSpareServers 35
ServerLimit 2000
MaxClients 2000
MaxRequestsPerChild 10000
</IfModule>
<IfModule worker.c>
StartServers 20
MaxClients 2000
ServerLimit 2000
MinSpareThreads 30
MaxSpareThreads 305
ThreadsPerChild 355
MaxRequestsPerChild 10000
</IfModule>
Thanks in advance for the help.