MV_
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_ and background_
|
Column name |
Description |
|---|---|
|
|
The name of the table. |
|
|
The name of the database containing the table. |
|
|
The |
|
|
The total cumulative number of rows changed for this table on this partition. |
|
|
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