SingleStore DB

information_schema.MV_CACHED_BLOBS

This table stores information about currently cached blobs.

Learn more about interpreting this table in the SingleStore DB Components to Monitor guide.

Column Name

Description

FILE_NAME

The on-disk filename of the blob (not the S3 path).

DATABASE_NAME

The name of the related database.

ORDINAL

The partition ordinal of the database, if relevant.

STATUS

The status of the blob:

  • Fetch error. Fetch will be retried on next request.

  • Cached

  • Downloading

TIMESTAMP_TICKS

Internal timestamp of last access time for this blob.

EVICTABLE

Either yes or no. Blobs will not be evictable if a query is currently referencing them or if the blob has not yet been uploaded to S3.

SIZE

The size of the blob, in bytes.

TYPE

Whether the blob belongs to a primary or secondary partition of the database (primary, secondary).