MV_COLLECTED_ROW_CHANGE_COUNTS

This view displays the best-effort counter for the number of changes that have been observed for the table partitions over time, and are persisted to disk.

More specifically, this view contains the number of row changes (inserts, updates, and deletes) that have been applied to the table as a destination.

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.
`database_name`	The name of the database containing the table.
`partition`	The `ID` of the partition.
`total_changes`	The total cumulative number of rows changed for this table on this partition.
`last_analyzed_total_changes`	The last recorded change count, when the statistics collection was triggered based on the metadata.

An example query related to this view:

SQL

SELECT table_name, database_name, SUM(TOTAL_CHANGES), SUM(LAST_ANALYZED_TOTAL_CHANGES) FROM MV_COLLECTED_ROW_CHANGE_COUNTS;

+------------+---------------+---------------------+----------------------------------+
| table_name | database_name | sum (TOTAL_CHANGES) | sum(LAST_ANALYZED_TOTAL_CHANGES) |
+------------+---------------+---------------------+----------------------------------+
| t          | db1           |                   8 |                                8 |
+------------+---------------+---------------------+----------------------------------+

MV_COLLECTED_ROW_CHANGE_COUNTS

Was this article helpful?

Was this article helpful?