My Piwik 0.5.4 running on VPS with 500mhz and 256Mb of RAM which was enough all this time. Yesterday i added new website with higher load (about 25K visitors/day). It was working fine and server processed everythings untill today. Now on dashboard Visitors wigdet shows only yesterday data and part of VisitsSummary widgets are not working. Logs are working as well as Plugins and ScreenResolution. And all new requests is working too.
Now processor load is around 15-20% and RAM increased to 400 megs (100 of them are still free).
So, appently engine can’t calculate stats like uniq_visitors because of some bottlenecks in MySQL server configuration.
Does anyone can give advices or sample configuration for MySQL to handle correctly such kind of load?
And one more question. Data calculated by VisitsSummary plugin, is stored precalculated when archiving or it will be recalculated each time someone request it?