Examples of Matomo's database table matomo_archive_invalidations

How does Matomo keep track of what to process?
The core:archive looks for invalidations in the database table called matomo_archive_invalidations.

Four sequential screenshots of the invalidations table in the MySQL database.
1. The table is empty becuase I did:
   mysql> TRUNCATE  matomo_archive_invalidations;
   mysql> SELECT count(*) FROM  matomo_archive_invalidations;
2. Then I told Matomo that all the reports are stale for today and yesterday.
This second screenshot is after this CLI command
   CLI: sudo su www-data -s /bin/bash -c  "php /var/www/littlefurnace.com/matomo/console core:invalidate-report-data --sites=1,2  --dates="2024-11-03",today --periods=day,week,month"
    mysql> SELECT count(*) FROM  matomo_archive_invalidations;
3. Then I ran the archiver, telling it to not calculate the archiving of any segments.
The syntax in Matomo for archiving WITHOUT doing segments is like this:
$ sudo su www-data -s /bin/bash -c  "php  -d memory_limit=2G   /var/www/littlefurnace.com/matomo/console core:archive --skip-all-segments --force-idsites=1,2"
4. The fourth screenshot is of the database after archiving the segments using the following command, similar to the command in 3:
  $ sudo su www-data -s /bin/bash -c  "php  -d memory_limit=2G   /var/www/littlefurnace.com/matomo/console core:archive  --force-idsites=1,2"

What happens in the matomo_archive_invalidations table when you invalidate?

When you do one simple command, invalidate a year, for one site (not any days nor months), what is created in the table is actually a series of rows, presumably each one a different recipe which needs to be performed on your one site, for the year.  Recall that Matomo builds the data of a YEAR by adding up the reports for the individual DAYS.

Run this in the CLI
sudo su www-data -s /bin/bash -c  "php /var/www/littlefurnace.com/matomo/console core:invalidate-report-data --sites=1  --periods=year --dates='2024-11-02','2024-11-02'"

You'll create these lines in the invalidations queue (which is stored in the db as matomo_archive_invalidations