replies Posted October 4, 2013 Share Posted October 4, 2013 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 56392.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. Quote Link to comment https://forums.phpfreaks.com/topic/282695-mysql-mycnf-config-help/ Share on other sites More sharing options...
vinny42 Posted October 5, 2013 Share Posted October 5, 2013 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/ Quote Link to comment https://forums.phpfreaks.com/topic/282695-mysql-mycnf-config-help/#findComment-1452716 Share on other sites More sharing options...
jazzman1 Posted October 6, 2013 Share Posted October 6, 2013 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. Quote Link to comment https://forums.phpfreaks.com/topic/282695-mysql-mycnf-config-help/#findComment-1452747 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.