Mike Matrigali wrote:
Also I was wondering if you had any idea where the invalid pages were coming from? The original problem with invalid pages was from drop tables, where applications didn't like it that we used all the pages in the cache when they were growing a single table to 1/2 the cache size and then dropping it. So the invalid case was sort of special and wasn't expected to happen very often. The usual case should be the cache growing to full and then LRU'ing old pages to make for way for new ones.
I thought that when new cache items were added, the new pages will be invalid until they are used for the first time. This is why this is only a problem while the cache is growing.
-- Øystein
