PAGE_LISTS

Page lists system view

❗️

This is a legacy Apache Ignite documentation

The new documentation is hosted here: https://ignite.apache.org/docs/latest/

Page list is a data structure used to store a list of partially free data pages (free-lists) and fully free allocated pages (reuse-lists). The purpose of free lists and reuse lists is to quickly locate a page with enough free space to save an entry or to determine that no such page exists and a new page should be allocated.
Page lists organized in buckets. Each bucket group pages with about the same size of free space.
If persistence is enabled page lists are created for each partition of each cache group, to view such page lists cacheGroupPageLists system view (SQL name CACHE_GROUP_PAGE_LISTS) can be used. If persistence is disabled page lists are created for each data region, in this case, dataRegionPageLists system view (SQL name DATA_REGION_PAGE_LISTS) can be used. These views contain information about each bucket of each page list what is useful to understand how much data can be inserted into the cache without allocating new pages and also helps to detect skews in page lists utilization.

Columns of cacheGroupPageLists

NAME

SQL NAME

TYPE

DESCRIPTION

cacheGroupId

CACHE_GROUP_ID

int

Cache group ID

partitionId

PARTITION_ID

int

Partition ID

name

NAME

String

Page list name

bucketNumber

BUCKET_NUMBER

int

Bucket number

bucketSize

BUCKET_SIZE

long

Count of pages in the bucket

stripesCount

STRIPES_COUNT

int

Count of stripes used by this bucket. Stripes are used to avoid contention.

cachedPagesCount

CACHED_PAGES_COUNT

int

Count of pages in onheap page list cache for this bucket

Columns of dataRegionPageLists

NAME

SQL NAME

TYPE

DESCRIPTION

name

NAME

String

Page list name

bucketNumber

BUCKET_NUMBER

int

Bucket number

bucketSize

BUCKET_SIZE

long

Count of pages in the bucket

stripesCount

STRIPES_COUNT

int

Count of stripes used by this bucket. Stripes are used to avoid contention.

cachedPagesCount

CACHED_PAGES_COUNT

int

Count of pages in onheap page list cache for this bucket