Hopefully I can keep up mysql server up for 24 and check with mysqltuner for further suggestion. Thanks Shaun for the my.conf values.
Oh, and apologies for stating the obvious but you need to stop and start MySQL for the new values to take effect ...
[mysqld]
general_log
max_allowed_packet=16777216
max_connections=500
slow_query_log
wait_timeout=28800
query_cache_size=8M
join_buffer_size=128
tmp_table_size=16M
max_heap_table_size= 16M
thread_cache_size=4
table_open_cache=64
innodb_buffer_pool_size=728M
If you're not already, I'd consider running a PHP opcode cache like XCache and a backend cache like Memcache for Xenforo.
extension = "xcache.so"
xcache.admin.enable_auth = On
xcache.cacher = On
xcache.count = 1
xcache.gc_interval = 3600
xcache.size = 64M
xcache.slots = 8K
xcache.stat = On
xcache.ttl = 7200
xcache.var_count = 1
xcache.var_gc_interval = 300
xcache.var_maxttl = 3600
xcache.var_size = 4M
xcache.var_slots = 8K
xcache.var_ttl = 7200
Guys, how do should I read these suggestions and what example (to put in my.conf)
Code:join_buffer_size (> 1.0M, or always use indexes with joins) tmp_table_size (> 54M) max_heap_table_size (> 65M) innodb_buffer_pool_size (>= 752M)
If XenForo is not use XCache's variable cache, in php.ini need change. This option disable variable cache in XCache.XCache does not require any configuration on the Xenforo end. It just requires a few settings in your php.ini file. This is what I'm using:
xcache.var_size = 0M
$config['cache'] = array(
'enabled' => true,
'frontend' => 'Core',
'frontendOptions' => array(
'caching' => true,
'automatic_serialization' => false,
'cache_id_prefix' => 'you_prefix_',
'lifetime' => 18000
),
'backend' => 'Xcache',
'backendOptions' => array(),
'cacheSessions' => true
);
We use essential cookies to make this site work, and optional cookies to enhance your experience.