MySQL Forums
Forum List  »  Optimizer & Parser

MySQL My.cnf Config Help
Posted by: Mathieu Louis
Date: October 03, 2013 09:32PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL My.cnf Config Help
2384
October 03, 2013 09:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.