Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

docmd.close 2585, WWWXXXAPC, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text, WWWXXXAPC., XXXCNZZZ

Links

XODOX
Impressum

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

Posted on 2006-12-12 10:52:25 by 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--

Report this message

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

Posted on 2006-12-18 10:03:01 by 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 <rems@wp-sa.pl>
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

Report this message

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

Posted on 2006-12-18 11:09:56 by 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 <rems@wp-sa.pl> 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 <rems@wp-sa.pl>
> WP/PTI/DIP/ZAB (+04858) 52 15 770
> MySQL v. 4.x
> Oracle v. 10.x
> ---------------------------------------
>
>

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

Report this message