I’ve just installed piwik 0.4.3, and I notice that a couple of the piwik MySQL tables grow with every access of the piwik UI (perhaps just the dashboard… not sure). The tables are:
But what, exactly, is new that needs archived when all that’s happened is an admin user accessing the piwik UI? I.e. - the tables are growing despite there being no activity whatsoever on the website that’s actually contributing data via javascript to piwik.
Stats of visits, visitors and click are kept in 3 tables that wont change when the admin visit Piwik dashboard.
What is changing when you visit the dashboard is that Piwik will take the data contained in thoses tables and produce two new tables for each month and it’s normal that are growing for months that arent over.
They stop growing when we get to the next month. But Piwik will create 2 new tables for the begining month that will show the same behavior.
I apologize if I’m being dense… but the behavior still doesn’t make any sense.
When an admin accesses the piwik dashboard, does that cause only an incremental piece of the non-archived data to get archived, and thus with each dashboard access a little bit more of the data gets processed?
I was under the impression that browser-triggered archiving caused a full archive of any non-archived data, and that was the very reason for encouraging cron-based archiving for sites accruing lots of data – to avoid what would otherwise be a painfully long archive hit as a consequence of merely trying to view the reports.
But that would imply that after you access the dashboard, there would no longer be any non-archived data until such time as the target website registered new visits.
Otherwise the behavior of having the tables grow visibly with each and every dashboard access even though absolutely no new additional data has been logged is befuddling.
I’m only talking by experience of what i’ve seen since i use Piwik.
When i access a site dashboard, new visits data get archived.
Next time i visit the dashboard, if the site had new visitors, that new data get processed.
But, it seems Piwik process separatly data for day, week, month and year.
When changing site or time frame, data get processed too.
Archives tables stop been altered (growing) when the month for them is over and that all data for that month still in the visit log have been processed.