Chris Hughes
ProgressTalk.com Sponsor
Hi all
I've read a lot about LRU skips and the benefits that setting it can bring, and I'm not going to argue with the slides that also show the benefits.
I'd like to increase my understanding and identify if their are downsides to it.
An example
I have 10,000 primary database buffers, and LRUskips is set to 10
I read the same 10,000 blocks from the database 10 times - I understand the LRU chain will contain these records.
If I now read 10,000 different blocks from disk, I understand they need to get into the chain first, so question is what would the chain look like during this process and what will it look like when it is finished?
Where I get confused is where new blocks that don't hit the skip number actually go, and which blocks get rejected out of the chain first in a real world database.
Thanks
Chris.
I've read a lot about LRU skips and the benefits that setting it can bring, and I'm not going to argue with the slides that also show the benefits.
I'd like to increase my understanding and identify if their are downsides to it.
An example
I have 10,000 primary database buffers, and LRUskips is set to 10
I read the same 10,000 blocks from the database 10 times - I understand the LRU chain will contain these records.
If I now read 10,000 different blocks from disk, I understand they need to get into the chain first, so question is what would the chain look like during this process and what will it look like when it is finished?
Where I get confused is where new blocks that don't hit the skip number actually go, and which blocks get rejected out of the chain first in a real world database.
Thanks
Chris.