Jump to content


Photo

MySQL My.cnf Config Help

my.cnf mysql config

  • Please log in to reply
2 replies to this topic

#1 replies

replies

    Newbie

  • New Members
  • Pip
  • 1 posts

Posted 03 October 2013 - 10:15 PM

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. 

 

 



#2 vinny42

vinny42

    Advanced Member

  • Members
  • PipPipPip
  • 414 posts

Posted 05 October 2013 - 11:44 AM

There is no magical set of numbers to put in your config, because the requirements depend entirely on what kind of workload you have, what does the database do, etc.

 

Having 1k people online doesn't say anything about how many pageviews you are getting what kind of work you do per pageview, etc.

How big is your database? are you using InnoDB or MyISAM, what kind of disks does the server have

 

Did you run a load test to see where your server is currently struggling?

 

Anyway, you should read some articles about tuning MySQL, there is a lot of good information in http://www.mysqlperformanceblog.com/



#3 jazzman1

jazzman1

    Advanced Member

  • Gurus
  • 2,256 posts
  • LocationMississauga, Canada

Posted 05 October 2013 - 07:05 PM

This is not just a good machine it's a beast :)

 

These confs look good for me. However, be careful b/s sometimes the problems aren't on the db and apache conf files but comes from bad scripts wrote by someone!

 

Check out the log files (every day or more) and look carefully if you see something wrong or bad.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com