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 | +-------------------------+-----------+ 1 row in set (0.00 sec) mysql> I only got one parameter. On Jan 4, 2008 8:22 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > 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] > > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
