5 ms·
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
by Spone 10y ago
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.
- user5994461 10y ago> 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.
- degenerate 10y agoAlso: What works best at scale? JS or Log file analytics?
- user5994461 10y agoYou need both. JS is to track clients and do analytics. Logs are for debugging, security and some trivial form of analytics.
- mattab 10y agoSetup cron archiving is a must: http://piwik.org/docs/setup-auto-archiving/ http://piwik.org/docs/setup-auto-archiving/ For scaling tracking, QueuedTracking plugin is the solution: http://piwik.org/docs/setup-auto-archiving/ http://piwik.org/docs/setup-auto-archiving/ For managing DB size, see: https://piwik.org/docs/managing-your-databases-size/ https://piwik.org/docs/managing-your-databases-size/ For any other issue, maybe report in Github tracker: https://github.com/piwik/piwik/issues https://github.com/piwik/piwik/issues
- bildung 10y agoHave you enabled auto-archieving? Have a look here: http://piwik.org/docs/setup-auto-archiving/ http://piwik.org/docs/setup-auto-archiving/ If that isn't enough http://piwik.org/docs/optimize-how-to/ 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.
- s_kilk 10y agoAt a previous workplace we just ripped out the MySQL bits and persisted data to MongoDB instead, which was massively more performant under heavy load.