The issue with the alternative buffer pool having more entries than assigned space is that, when an entry on LRU2 is dequeued from LRU2 and moved to APW quene for page writer to flush, during that time, another buffers can be added to LRU2. Later when the page writer flush the buffer and put it back on LRU2, the LRU chain might be already full.
This causes LRU2 entries exceeded the allocated numbers. Performance degrades when too many buffers on LRU are moved to LRU2 chain and causes a low buffer hit ratio on the general buffer pool low. The issue found only with object-level B2. |