I have been experiencing a problem a for a little while now, I think it first appear since I upgraded to the latest version of Piwik, but it might also be unrelated to that.
My problem is that I am running a VPS and I get warning messeges from Linode (my VPS hoster) complaining that I am exhausting my diskio. When I check it out it seems like it is due to my box being out of memory and it begins writing to swap. (500 MB memory).
The box is running a piwik install on apache and a wordpress blog. The blog is very low in traffic, say 30 -40 visitors a day. The piwik is connected to a blog with 60-80 visitors a day (on another server).
Looking at the processes in htop shows me that the memory is eaten mostly by alot of apache2 processes (each eating 5MB - 1.4MB) and maybe 20 mysql connections (5MB memory each).
I am guessing that the apache connections are caused by Piwik somehow. Is there anyway I can verify/fix this?
Would appriciate help! Love Piwik, thanks for providing an alternative to Skynet.