I am having a problem with purging the data. The problem is that I am not sure if I loose important data by running the script ./console core:purge-old-archive-data all
The size of the database is huge. That’s the reason to purge. We are also migrating the Matomo to new server and this is a good time for us to purge the data.
I have a regular cronjob for archiving the logs (./console core:archive).
I would like to keep all the data since the 1.1.2020.
select table_name, round(data_length/1024/1024) as data_length_mb, round(data_free/1024/1024) as data_free_mb from information_schema.tables where round(data_free/1024/1024) > 200 order by data_free_mb;
I noticed this also a few days ago and it makes sense: Matomo can delete entries from the database, but the disk space MySQL uses often doesn’t decrease if the database size decreases unless you run an optimize on it.