Is it still unusable for sites with traffic?
Piwik 3.0.0
11–20 of 46 posts
Re: Piwik 3.0.0
#12Question to other Piwik users: how do you manage the ever-growing MySQL database to keep response times acceptable? Where do you host it? My Piwik instance is nearly unusable because any non-trivial request takes ages.
Also: What works best at scale? JS or Log file analytics?
Re: Piwik 3.0.0
#13No Postgres, no Piwik.
Re: Piwik 3.0.0
#14Question to other Piwik users: how do you manage the ever-growing MySQL database to keep response times acceptable? Where do you host it? My Piwik instance is nearly unusable because any non-trivial request takes ages.
Also: What works best at scale? JS or Log file analytics?
Setup cron archiving is a must: http://piwik.org/docs/setup-auto-archiving/
For scaling tracking, QueuedTracking plugin is the solution: http://piwik.org/docs/setup-auto-archiving/
For managing DB size, see: https://piwik.org/docs/managing-your-databases-size/
For any other issue, maybe report in Github tracker: https://github.com/piwik/piwik/issues
Re: Piwik 3.0.0
#15Question to other Piwik users: how do you manage the ever-growing MySQL database to keep response times acceptable? Where do you host it? My Piwik instance is nearly unusable because any non-trivial request takes ages.
Have you enabled auto-archieving? Have a look here: http://piwik.org/docs/setup-auto-archiving/
If that isn't enough http://piwik.org/docs/optimize-how-to/ shows you how to configure php and mysql for more performance.
Actual hardware requirements are quite small for small sites (say < 10k visitors/day). Any 10-15$ VPS should be fine.
Re: Piwik 3.0.0
#16Is it still unusable for sites with traffic?
Piwik now works on websites with 100M pageviews per month and more (much more) with the right setup
Re: Piwik 3.0.0
#17Site is down, any screenshots? :-)
Site is back up!
Re: Piwik 3.0.0
#18Piwik is a great alternative to Google analytics, can't recommend them enough. On my websites I really like the option to track visits directly from the log file. It isn't as detailed as js tracking, but gives accurate number of visits (not altered by ghostery / privacy plugins).
Re: Piwik 3.0.0
#19Re: Piwik 3.0.0
#20I am surprised at so many comment using it as Log File Analytics rather then JS setup.
If you want Log File Analytic, you should definitely give GoAccess a try.