Remigiusz, If you work with 32bit OS you need apply hugemem package for work with big memory settings.
I work with 64bit OS and you don`t need apply any package. In order to add more memory for the Innodb using innodb_buffer_pool_size you don`t have any restrictions. You can set 10G, 20G depend of your phisical memory. Now, for the innodb_log_file_size, the combined size of the InnoDB log files must not exceed 4 GB. If you have 2 log files, you can make each at most 2000 MB in size. When you startup your MySQL using innodb, in your my.cnf you can set the variable innodb_log_files_in_group. For example, if your set innodb_log_files_in_group=2 ( ib_log_file001, ib_log_file002 are created) the total size must not exceed 4G. Regards, Juan On 12/18/06, Remigiusz Soko?owski <[EMAIL PROTECTED]> wrote:
Uz.ytkownik Juan Eduardo Moreno napisa?: > Hi everyone!! > > > Normally we can set the .._buffer_pool_size up to 50 - 80 % of RAM > innodb_buffer_pool_size = 50% of phisical memory. > > And > > # Set .._log_file_size to 25 % of buffer pool size > innodb_log_file_size = 25% of buffer pool size > > Now, we installed a machine using Linux Redhat ES with 16G of RAM. > When try > to configure, for example 50% of ram ( 8G) in the > innodb_buffer_pool_size, > the Innodb and MySQL startup but not create the innodb log file size. > > It`s necessary use any special configuration in order to use 50-80% of > 16G > RAM in the Inno_buffer_pool_size?. Hugemem for OS or something for > innodb/mysql?. > > Today we only config 5G in the innodb_buffer_pool_size. did You change settings for log file size, when You added memory? -- --------------------------------------- Remigiusz Sokolowski <[EMAIL PROTECTED]> WP/PTI/DIP/ZAB (+04858) 52 15 770 MySQL v. 4.x Oracle v. 10.x ---------------------------------------
