Piwik on a busy site

Support & Bugs
1

I work on a site that has millions visitors, and I want test Piwik to record the visitors.

And I tested it, it got a heavy-loading on mysqld that I can’t stand.

I’m new to Piwik, maybe it insert the data in mysql synchronously. I want to figure out that is the Piwik can insert the data asynchronously, so I counld reduce the server loading that run the Piwik.
Or anyway else.

Could anyone tell me how?
Thank you!

2

Have you tried How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo ?

3

Yes, I tried.

But when the website’s Concurrent Connections up to 100 or 200, the Mysql server get a heavy-loading. Maybe It’s the fault of mysql. I just want to Konw if Piwik has the feature to insert the data asynchronously or other something that coulad reduce the mysql server loading for someone don’t need the live data.

Thanks.

4

This is currently a known performance issue, mysql doesn’t deal well with so many requests. We could bulk load the requests, see Bulk load Piwik logs with documented API: improved tracking performance, allow performance testing · Issue #5554 · matomo-org/matomo · GitHub - but work hasn’t started on this

See High traffic Piwik FAQ