Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

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?