Re: innodb buffer pool allocation question

2011-02-23 Thread petya
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

innodb buffer pool allocation question

2011-02-22 Thread Kyong Kim
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: