Bug #12634 load large indexes into cache where indexes are bigger than cache

• Submitted: 18 Aug 2005 3:45
• Modified: 10 Sep 2005 16:39
• Reporter: Mike Connell
• Status: Closed
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 4.1.13
• OS: Sun
• CPU Architecture: Any

[18 Aug 2005 3:45] Mike Connell

Description:
issue: what to evict from the cache when indexes are bigger than cache size

desired result: first flush leaf nodes of index. if this doesn't get the index loaded, then flush
anything else

How to repeat:
setup a small key cache
>load index into cache <table>;
where <table> has indexes bigger than cache

[10 Sep 2005 16:38] Sergei Golubchik

This is usually happens automatically.
Least used pages are removed from the cache first, so this almost always means that leaves are removed before nodes.