Newbie here. How do I change my max children?
I see a lot of instructions but nothing tells me how to log in and make the changes. Currently, my settings are: I think they may be too high. My live analytics numbers are not going past 40 concurrent visits… Not sure what command line to use to change the settings.
pm.max_children = 100
pm.start_servers = 30
pm.min_spare_servers = 30
pm.max_spare_servers = 100
pm.max_requests = 750
process_control_timeout =20s +=========+
Nginx worker processed updated to : 3078
Updated Mysql settings as +========+
query_cache_size = 512M
query_cache_type = 1
query_cache_limit = 32M
tmp_table_size = 64M
max_heap_table_size = 64M
thread_pool_size = 24
innodb_buffer_pool_instances = 2
read_buffer_size = 2M
read_rnd_buffer_size = 4M
join_buffer_size = 4M +=========+
If you're asking if there was some sort of GUI/command to change this stuff, the answer is no. You have to log in to your server, probably become the superuser and edit the appropriate configuration files with a text editor like nano(1) or vi(1). After you've made your changes, you'll have to restart the service…and hope you didn't make any mistakes that would prevent the service from starting.
Second, changing pm.max_children will not solve the problem you described unless you are getting messages in your php-fpm log that look like this:
[26-Jul-2012 09:49:59] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 32 children, there are 8 idle, and 58 total children [26-Jul-2012 09:50:00] WARNING: [pool www] server reached pm.max_children setting (50), consider raising it
Just from your brief description, it sounds to me like your throughput is being limited by your web server configuration…not php or mysql. Neither of the snippets you present belong to a web server.
I got the log snippet from here:
Third, web server tuning is a mysterious dark art…and requires detailed knowledge of the workload at hand (IMHO, far more detailed than My live analytics numbers are not going past 40 concurrent visits…). My best advice would be to engage someone more knowledgeable than you (or me) in the subject…or grin & bear it until you can educate yourself.