MV_ROW_CHANGE_COUNTS

This view is primarily for internal use, SingleStore recommends using MV_COLLECTED_ROW_CHANGE_COUNTS instead.

This view 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 row changes (inserts, updates, and deletes) that have been applied to the table partition since it became online on the host. In-memory statistics do not persist across restarts.

The write behavior to the view is controlled via the following engine variables: change_count_write_interval and background_statistics_collection_interval

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.

An example query related to this view:

SQL

SELECT table_name, database_name, SUM(changed) FROM MV_ROW_CHANGE_COUNTS GROUP BY ALL;

+------------+---------------+--------------+
| table_name | database_name | sum(changed) |
+------------+---------------+--------------+
| t          | db1           |            3 |
| t2         | db1           |            0 |
+------------+---------------+--------------+

MV_ROW_CHANGE_COUNTS

Was this article helpful?

Was this article helpful?