From 9ae7aad20fd8ab21173a0ac716686facbb4471bb Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 12 Jul 2002 20:00:15 +0300 Subject: my-huge.cnf.sh, my-small.cnf.sh, my-medium.cnf.sh, my-large.cnf.sh: Update my.cnf example files to reflect InnoDB autoextend and also simplify them for InnoDB support-files/my-large.cnf.sh: Update my.cnf example files to reflect InnoDB autoextend and also simplify them for InnoDB support-files/my-medium.cnf.sh: Update my.cnf example files to reflect InnoDB autoextend and also simplify them for InnoDB support-files/my-small.cnf.sh: Update my.cnf example files to reflect InnoDB autoextend and also simplify them for InnoDB support-files/my-huge.cnf.sh: Update my.cnf example files to reflect InnoDB autoextend and also simplify them for InnoDB --- support-files/my-huge.cnf.sh | 17 ++++++++--------- 1 file changed, 8 insertions(+), 9 deletions(-) (limited to 'support-files/my-huge.cnf.sh') diff --git a/support-files/my-huge.cnf.sh b/support-files/my-huge.cnf.sh index ce9b5b18586..6c204abd4c7 100644 --- a/support-files/my-huge.cnf.sh +++ b/support-files/my-huge.cnf.sh @@ -46,20 +46,19 @@ server-id = 1 #set-variable = bdb_cache_size=384M #set-variable = bdb_max_lock=100000 -# Uncomment the following if you are using Innobase tables -#innodb_data_file_path = ibdata1:2000M;ibdata2:2000M +# Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = @localstatedir@/ +#innodb_data_file_path = ibdata1:2000M;ibdata2: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=384M +#set-variable = innodb_additional_mem_pool_size=20M +# Set .._log_file_size to 25 % of buffer pool size +#set-variable = innodb_log_file_size=100M #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 [mysqldump] -- cgit v1.2.1