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 > 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
