SingleStore DB

mv_row_change_counts

The mv_row_change_counts view in the information_schema database returns a row for each partition of each table with autostats (automatic statistics) hosted in the cluster, along with a change count. These statistics are in-memory and show the number of changes (inserts, updates, and deletes) that have been applied to the table partition since it became online on the host.

Column name

Description

table_name

The name of the table in the database.

database_name

The name of the database associated with the activity.

partition

The table partition in the database.

changed

The count of changes (inserts, updates, and deletes) for a table partition.

token

The token associated with the table partition.