I have quite a beefy machine, did some simple MySQL optimizations, tried caching, etc yet my machine has a high CPU usage and load. I have 700+- members at peaks. 25k registered and 880k posts. I do have elasticsearch enabled.
So yeah, quite a machine yet I'm getting slow loading times and high CPU usage. I use MaxCDN which does a great job so far. See blow all my configuration files involved.
[mysqld] skip-external-locking query_cache_type = 0 query_cache_size = 0 query_cache_limit = 1M query_cache_strip_comments = 0 thread_cache_size = 256 max_heap_table_size = 128M tmp_table_size = 128M connect_timeout = 10 max_connections = 500 interactive_timeout = 300 wait_timeout = 300 thread_stack = 256k table_open_cache = 24000 open_files_limit = 24000 key_buffer_size = 768M max_allowed_packet = 4M sort_buffer_size = 1M join_buffer_size = 512k #net_buffer_length = 64K read_buffer_size = 512K #read_rnd_buffer_size = 512K myisam_sort_buffer_size = 128M innodb_buffer_pool_size = 8G innodb_thread_concurrency = 7 innodb_buffer_pool_instances = 4 innodb_flush_method=O_DIRECT innodb_file_per_table=1 innodb_log_buffer_size=8M
This is a configuration I've assembled from several threads on here and tweaked it to my server specifications.
[site] listen = 127.0.0.1:9001 listen.allowed_clients = 127.0.0.1 user = admin group = admin pm = dynamic pm.max_children = 2000 pm.start_servers = 50 pm.min_spare_servers = 50 pm.max_spare_servers = 90 env[HOSTNAME] = $HOSTNAME env[PATH] = /usr/local/bin:/usr/bin:/bin env[TMP] = /tmp env[TMPDIR] = /tmp env[TEMP] = /tmp
Let me know if you guys need any other configuration files.
The setup is a VestaCP installation. As stated above, i've tried caching systems and none really improved load significantly so I removed them temporarily until someone can help me to get it configured and setup properly.