• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Server Upgrade, New my.cnf settings

#1
Just upgraded my KnownHost VPS2 to an SSD2, and for just an additional $15 per month I've doubled my available memory, going from 1024mb to 2048mb

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:

Code:
[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've already made one change:
innodb_buffer_pool_size=1152M

I think that's a fairly safe change (but I'm not an expert!), does this seem ok? What other changes should I make?
 

Slavik

XenForo moderator
Staff member
#2
How large are your tables?

For the most part, giving innodb more to munch is probably all you'll need to do.