i tried it before in the german section of the forum but i didnt get any problem-solving help(http://forum.piwik.org/read.php?5,91067). i use piwik on an ubuntu server vm with now 2 cpu threads and 1gb ram. the filesystem has enough free space (4gb+), site has around 40k hits a month and the installation is 15 month old i think.
Since the last update/the linux kernel time bug i have the problem that when i open the dashboard on my rootacc the whole server seems to freeze with top showing 100% cpu usage for several minutes until data is shown.
even when the rest finally is loading the overview widget where you can change the timeframe that is shown (days, weeks, month etc) never finishes. the whole leap second thing let me research in that direction but that should have been done with after a reboot.
if i dont use my root acc now to look at the dashboard and instead use a secondary non-admin acc everything loads fine in reasonable time and the cpu usage is 35% at a maximum.
I reinstalled piwik on the filesystem without any change.
So any ideas what might be wrong and how to fix it?
thanks in advance