after good results with some sites I added the remaining 5800 sites to piwik.
Its not adding a lot of visits but just a lot of minor “sites”.
Since then the database server is running at high load when the archive cronjob is running every hour.
Is there any way to log just the queries done on archiving to see whats going on?
Is there anything bad regarding the number of sites when archiving is done?
Btw. that is on 0.5.4. I will try 0.5.5 tonight.
Thanks in advance,