AnsweredAssumed Answered

MySQl my.cnf performance tweaks or more cores?

Question asked by Jeff C on Nov 18, 2015
Latest reply on Nov 18, 2015 by Jeff C

Running SugarCRM 6.5 Community on VPS with 1.8 cores (Xeon) and 7.5GB RAM. Is this my.cnf optimal for getting best performance out of SugarCRM. Only 1 or 2 concurrent users using the system, but it seems some of the workflows take pretty long. Not sure if I need to just tweak my.cnf or buy more cores.

top is showing cpu load average for all three time frames in the 0.5-0.6 range. Server uses SSDs but I suppose that could be a bottleneck depending on if there are a lot of other disk instensive hosts running on the box.

my.cnf is:

max_connections=400

table_open_cache=1024

max_delayed_threads=20

max_tmp_tables=32

query_cache_type=1

query_cache_size=64M

thread_cache_size=256

innodb_file_per_table=1

innodb_use_native_aio=0

max_allowed_packet=268435456

open_files_limit=10000

join_buffer_size = 1M

key_buffer = 64M

myisam_sort_buffer_size = 64M

join_buffer_size = 2M

read_buffer_size = 2M

max_heap_table_size = 32M

table_cache = 5000

query_cache_limit = 4M

innodb_buffer_pool_size = 2GB

innodb_log_buffer_size=16M

#innodb_buffer_pool_instances=2

 

Outcomes