MySQL Forums :: InnoDB :: Innodb_buffer_pool_pages_free = 0


Advanced Search

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


Subject Views Written By Posted
Innodb_buffer_pool_pages_free = 0 2722 Douglas Nelson 09/24/2012 10:31AM
Re: Innodb_buffer_pool_pages_free = 0 1156 Rick James 09/25/2012 10:44AM
Re: Innodb_buffer_pool_pages_free = 0 1189 Aftab Khan 09/26/2012 03:21PM
Re: Innodb_buffer_pool_pages_free = 0 965 Douglas Nelson 09/26/2012 06:06PM
Re: Innodb_buffer_pool_pages_free = 0 762 Aftab Khan 09/27/2012 01:49AM
Re: Innodb_buffer_pool_pages_free = 0 2558 Douglas Nelson 09/27/2012 02:48AM
Re: Innodb_buffer_pool_pages_free = 0 1166 Aftab Khan 09/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.