Hello all,
We were just wondering if anyone has any information / experience to share on tweaks made to their apache & mysql configuration file settings in order to achieve better performance for larger user bases.
Some of the settings i'm curious about are:
Apache Config File - httpd.conf
Settings of interest -
Timeout
KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
Which MPM are you using? Prefork, Worker, Other? And with what settings?
Any additional settings not standard?
MySQL Config File - my.conf
Settings of interest -
innodb_buffer_pool_size (But also, what is your total RAM capactiy? Effectively, what % of total memory are you allocating?)
innodb_lock_wait_timeout
wait_timeout
interactive_wait_timeout
max_connections
max_allowed_packet
query_cache_type
query_cache_size
table_cache
max_heap_table_size
tmp_table_size
thread_pool_size
Any additional settings not standard?
Appreciate your time!