Are there any recommended automated healthchecks, DB queries, etc. that could be run to monitor the health of Matomo itself?
The reason for the question… we recently experienced an issue relating to the UsersFlow plugin (issue described here) where rows were being added to the
matomo_archive_invalidations table faster than the archiver could clear (approx 15,000/min). The first we realised was when reports weren’t being generated. By then the table was so full (over 30 million rows) it was difficult to fix due to slow running queries - even running extra archivers and increasing AWS RDS processing capacity didn’t help much.
Anyone here have any monitoring / alerting of that nature in place?