MySQL Forums
Forum List  »  InnoDB

Innodb_buffer_pool_pages_free = 0
Posted by: Douglas Nelson
Date: September 24, 2012 10:31AM

I am reviewing a server's Innodb stats. and I see this:

Innodb_buffer_pool_pages_free = 0;

I've google and found every about this setting but I still have a few questions.

I would like to get some opions on my quandarys here.

What happens next:

If there is not enough memory to hold all the indexes in memory does the MySQL query optimiser do a full table scan acting like not index exist?

How does MySQL decide which table's indexes get loaded into memory? Do they rotate out?

Is there any way to tell which indexes are in the pool and which are not?

Thanks Doug

Options: ReplyQuote

Written By
Innodb_buffer_pool_pages_free = 0
September 24, 2012 10:31AM
September 25, 2012 10:44AM
September 26, 2012 03:21PM
September 26, 2012 06:06PM
September 27, 2012 01:49AM
September 27, 2012 02:48AM
September 27, 2012 03:57AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.