SMF Support > Server Performance and Configuration
corrupt smf_sessions table and slow forum
bjp:
Sorry, anglish is not my native language.
I do not understand what you mean here :
--- Code: ---You might be able to get away with the higher number if you have a gigabyte of ram (I assume that's what you meant because the thought of a server in production with a single megabyte scares the goodness out of me.) How much of it is generally used at a time? Without context, it's hard to make recommendations.
--- End code ---
bjp:
For the moment it' a test forum. On my main forum phpbb that will be convert in a few days, I have 100 000 new messages every 6 month.
bjp:
Sorry to ask again, but what must I do with this ?
Whitch line i must uncomment, and what are the goods values ?
Thank you !
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /usr/keopanel/mysql/var/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/keopanel/mysql/var/
#innodb_log_arch_dir = /usr/keopanel/mysql/var/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 256M
#innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 64M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
Navigation
[0] Message Index
[*] Previous page
Go to full version