Allows users to set certain tables to stick in the Buffer pool

Registered by MadMatt on 2009-06-24

This patch would allow users to specify a table as less likely to get LRU'd from the buffer pool. The easiest implimentation of this is actually using innodb file per table. Internally the space ID's can be checked against a list ( array would be faster ) of high priority ID's. If the ID is listed, call make young on the page. This code can exist in two places. #1 the LRU code itself, maybe set it so after calling make_young on 10 pages it will give up and LRU a high priority page and #2 in the main server thread, walking 100 nodes on the LRU and calling make_young on them every 1 or 10 seconds...

Blueprint information

Status:
Not started
Approver:
None
Priority:
Low
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.