[quote=cer @ Apr 7 2010, 11:32 PM]Hello,
we use piwik on a site with more than 100k daily visits and I have discovered quite a big problem. Every night the archive.sh script is run and during the calculation whole mysql server is unreachable, so the site isn’t able to show any content. This is very odd, i’d appreciate if anyone could come with some solution.
How many sites do you have in piwik? Are you running the archive script on the database server?
There are some memory leaks in piwiks archiving process which is even worse with multiple sites as memory usage is accumulating which could simply be too much for the server.
I’m also seeing thousands of mysql queries per second when archiving is running.