Re: Innodb_buffer_pool_pages_free heading towards 0

2008-01-04 Thread Moon's Father
But why I have not found this parameter in my version. Something is like this: mysql> show variables like '%innodb_buffer%'; +-+---+ | Variable_name | Value | +-+---+ | innodb_buffer_pool_size | 268435456 | +

Re: Innodb_buffer_pool_pages_free heading towards 0

2008-01-04 Thread Baron Schwartz
Hi, On Jan 4, 2008 1:04 AM, Krishna Chandra Prajapati <[EMAIL PROTECTED]> 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 > Innod

Innodb_buffer_pool_pages_free heading towards 0

2008-01-03 Thread Krishna Chandra Prajapati
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. Thanks, -- Krishna Chandra Prajapati