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:

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 |
+------------+---------------+---------------------+----------------------------------+

Last modified: October 30, 2023

Was this article helpful?