OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Innodb_buffer_pool_pages_free heading towards 0

From: Baron Schwartz (baronxaprb.com)
Date: Fri Jan 04 2008 - 06:22:42 CST

Hi,

On Jan 4, 2008 1:04 AM, Krishna Chandra Prajapati <prajapatikcgmail.com> wrote:
> Hi All,
>
> On mysql production server one of the innodb component
> Innodb_buffer_pool_pages_free =1 . Although there are no issue with the
> performance with the server. What should be the optimum value of
> Innodb_buffer_pool_pages_free.

There's nothing wrong with that. If you have more data than the
buffer pool size, InnoDB will generally use all of it. Having many
pages free means you don't have enough data to use the buffer pool,
and you've allocated too much memory to it, which is a waste.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql