Now I'd like to update my SQL memory settings for improved performance. I'm adding sonnb's XenGallery, and I want to make sure that everything functions well.
My old my.cnf was set as follows:
[mysqld] local-infile=0 #skip-innodb set-variable = max_connections=300 safe-show-database max_tmp_tables=1 query_cache_type=1 query_cache_limit=4M query_cache_size=32M thread_cache_size=6 table_cache=475 tmp_table_size=256M max_heap_table_size=256M innodb_buffer_pool_size=384M interactive_timeout=60 wait_timeout=60 #key_buffer = 32M key_buffer_size=48M slow_query_log=1 # (1 = on, 0 = off) slow_query_log_file=slow_query_log.log # (optinal, file name, not full path) long_query_time=5 # (in seconds)
I think that's a fairly safe change (but I'm not an expert!), does this seem ok? What other changes should I make?