Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Piwik 3.0.0

piwik.org

Post reply on HN
Print view View original

21–30 of 46 posts

Re: Piwik 3.0.0

#21

Post by user5994461 »

Spone wrote: post #10

Question 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.

> how do you manage the ever-growing MySQL database to keep response times acceptable?

We stopped using MySQL.

Or to word it differently, we stopped using Piwik. They lived together, they died together.

Re: Piwik 3.0.0

#22

Post by user5994461 »

degenerate wrote: post #12
Spone wrote: post #10

Question 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?

You need both. JS is to track clients and do analytics. Logs are for debugging, security and some trivial form of analytics.

Re: Piwik 3.0.0

#23

Post by user5994461 »

mattab wrote: post #16
elcct wrote: post #11

Is 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

So to answer the original question: Nope, doesn't work.

(Quick test: if you're counting page views in millions per day, you're gonna have a tough time).

Re: Piwik 3.0.0

#24

Post by aargh_aargh »

ksec wrote: post #20

I 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. https://goaccess.io/

Thanks, that seems useful.

Re: Piwik 3.0.0

#25

Post by aorth »

Great news, thanks. The automatic upgrade from 2.17.1 to 3.0.0 went smoothly on my small instance tracking four personal sites.

Re: Piwik 3.0.0

#26

Post by LinuxFreedom »

elcct wrote: post #11

Is it still unusable for sites with traffic?

No, not usable in real life. Old-school PHP bloat that will slow down your site. Bonus: breaks occasionally on updates. Developers not willing to learn techniques needed for a quick logger with minimal impact. Run away from people using this with high traffic sites in a still-2005-PHP-mindset.

Re: Piwik 3.0.0

#28

Post by shakna »

elcct wrote: post #11

Is it still unusable for sites with traffic?

I know that GitLab use it, so hopefully one of the devs can pop up and say how it handles, but that's a vote of confidence in my book.

Re: Piwik 3.0.0

#29

Post by buremba »

mattab wrote: post #16
elcct wrote: post #11

Is 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

How it handles that traffic? It would be great if they could share the architecture because using Mysql for analytics is not easy, you can't expect Mysql to handle concurrent queries that needs to aggregate billions of records when I visit the dashboard.
Post reply on HN