Optimizing server running Magento

Obviously the actual value depends on your hardware and website. These settings are for 3g RAM server. Might tweak further with more statistics coming in.

my.cnf of mysql

[mysqld]
key_buffer = 256M
max_allowed_packet = 32M
myisam_sort_buffer_size = 32M
tmp_table_size = 64M
table_cache = 512
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 2M
query_cache_type = 1
query_cache_size = 64M
query_cache_limit = 2M
thread_cache_size = 8
innodb_buffer_pool_size = 128M
innodb_thread_concurrency = 6

apache.conf

KeepAlive on
KeepAliveTimeout 2
MaxKeepAliveRequests 100

Note: setting innodb_buffer_pool_size will cause innodb to fail

Leave a Reply