prevent table loading in bufer pool
Hoi,
is it possible to disable a certain table from loading in the innodb buffer pool?
The table in question is a > big 1M row compressed blob table.
If i could leave this table out of the buffer pool then all the other tables (data+index) could be fully loaded in memory. More specifically is it possible to ignore data-caching of 1 table so i could leave the index intact.
Subject
Views
Written By
Posted
prevent table loading in bufer pool
1504
May 20, 2011 03:48PM
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.