Important

New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.

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?