Does innodb buffer pool cache indexes and data in sub sets or in entirety?
I've heard people mention the buffer pool allocation is dependent on
the size of your tables and indexes.
Kyong
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Hi,
This is far more complicated than that. The buffer pool caches innodb
pages. Not only data and indexes are stored on innodb pages. For example
the undo log or the insert buffer are stored in innodb pages, therefore
they are cached by the buffer pool. The simple answer is: in the buffer
pool, the data, the indexes, and some other stuff are cached:). Since it
caches innodb pages, it can cache subsets, it uses LRU toremove certain
pages from the cache.
Peter Boros
On 02/23/2011 05:49 AM, Kyong Kim wrote:
> Does innodb buffer pool cache indexes and data in sub sets or in entirety?
> I've heard people mention the buffer pool allocation is dependent on
> the size of your tables and indexes.
> Kyong
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org