diff options
Diffstat (limited to 'support-files/my-large.cnf.sh')
| -rw-r--r-- | support-files/my-large.cnf.sh | 17 |
1 files changed, 8 insertions, 9 deletions
diff --git a/support-files/my-large.cnf.sh b/support-files/my-large.cnf.sh index 0602921abc1..3c388d611d8 100644 --- a/support-files/my-large.cnf.sh +++ b/support-files/my-large.cnf.sh @@ -42,20 +42,19 @@ server-id = 1 #set-variable = bdb_cache_size=64M #set-variable = bdb_max_lock=100000 -# Uncomment the following if you are using Innobase tables -#innodb_data_file_path = ibdata1:1000M +# Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = @localstatedir@/ +#innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = @localstatedir@/ #innodb_log_arch_dir = @localstatedir@/ -#set-variable = innodb_mirrored_log_groups=1 -#set-variable = innodb_log_files_in_group=3 -#set-variable = innodb_log_file_size=5M +# You can set .._buffer_pool_size up to 50 - 80 % +# of RAM but beware of setting memory usage too high +#set-variable = innodb_buffer_pool_size=256M +#set-variable = innodb_additional_mem_pool_size=20M +# Set .._log_file_size to 25 % of buffer pool size +#set-variable = innodb_log_file_size=64M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 -#innodb_log_archive=0 -#set-variable = innodb_buffer_pool_size=16M -#set-variable = innodb_additional_mem_pool_size=2M -#set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 # Point the following paths to different dedicated disks |