innodb_buffer_pool_size. How to setup with more than 5G ?

innodb_buffer_pool_size. How to setup with more than 5G ?

am 12.12.2006 10:52:25 von Juan Eduardo Moreno

------=_Part_127132_4827743.1165917145799
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.


Thank you,
Juan

------=_Part_127132_4827743.1165917145799--

Re: innodb_buffer_pool_size. How to setup with more than 5G ?

am 18.12.2006 10:03:01 von rems

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
WP/PTI/DIP/ZAB (+04858) 52 15 770
MySQL v. 4.x
Oracle v. 10.x
---------------------------------------


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Re: innodb_buffer_pool_size. How to setup with more than 5G ?

am 18.12.2006 11:09:56 von Juan Eduardo Moreno

------=_Part_11229_25320065.1166436596807
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 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
> WP/PTI/DIP/ZAB (+04858) 52 15 770
> MySQL v. 4.x
> Oracle v. 10.x
> ---------------------------------------
>
>

------=_Part_11229_25320065.1166436596807--