SingleStore DB

information_schema.MV_BLOB_CACHE_EVENTS

This table stores information about events pertaining to cached blobs.

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

Column Name

Description

NODE_ID

ID of the related node.

EVENT_TYPE

Either fetch or eviction:

  • fetch - downloading a columnar blob file from S3.

  • eviction - deleting the blob file because it can be retrieved again from S3 later if necessary.

DATABASE_NAME

The name of the related database.

ORDINAL

The partition ordinal of the database, if relevant.

FILE_NAME

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

FILE_SIZE

The size of the blob, in bytes.

UNIX_TIMESTAMP

Timestamp of the event.

FETCH_TIME_TAKEN_MS

Only applies for fetches. The time in milliseconds spent waiting on network for the blob fetch. This does not track time spent waiting for other fetches to complete before submitting the fetch for this blob.