Hello fellow matomo fans,
In advance I want to apologize in case this is a duplicate question. I couldn’t find any answers to my questions via search.
I’ve got the problem, that the archive_blobs for some months are getting absolutely huge. There where no major changes to the amount of visitors tracked in these months. I attach a screenshot of the database size.
I have tried ./console core:purge-old-archive-data all without any improvement result.
I also tried the following SQL query:
SELECT idsite, date1, date2, period, name, COUNT(*) as count FROM piwik_archive_blob_2020_02 GROUP BY idsite, date1, date2, period, name HAVING count > 1;
And got many duplicate entries. Am I right that this query should return zilch?
thanks in advance,
a very desperate db-admin