Is my site too big for Piwik?

I ditched Google analytics last year for Piwik, and love it. I now have a site that has gone viral, and am getting around 1 million hits a day. The blocks on my page take WAY too long to load when I click a table, ie, outlinks, referrers, etc. I have to actually delete data from the database every hour or so, just to use the outlinks box (Ive gone back to Analytics for data Piwik doesn’t supply).

DELETE FROM piwik_log_visit WHERE idsite = 8;
DELETE FROM piwik_log_link_visit_action WHERE idsite = 8;
DELETE FROM piwik_log_conversion WHERE idsite = 8;
DELETE FROM piwik_log_conversion_item WHERE idsite = 8;

Is there a way I can track JUST outlinks? I don’t really use the other features, I just want to see the outlinks is all.


Have you tried going to Settings -> Plugins, and deactivating everything except ‘Actions’.

Other than that, you can create your own plugin to report on the metric you need. Piwik is well documented, and can be done fairly easy if you have programming background.

Hope this helps.


Ahh, that works for me, thanks.