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


Subject
Views
Written By
Posted
Innodb_buffer_pool_pages_free = 0
2797
September 24, 2012 10:31AM
1174
September 25, 2012 10:44AM
1206
September 26, 2012 03:21PM
975
September 26, 2012 06:06PM
778
September 27, 2012 01:49AM
2626
September 27, 2012 02:48AM
1198
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.