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.
My Piwik instance is nearly unusable because any non-trivial request takes ages.
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.
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
We stopped using MySQL.
Or to word it differently, we stopped using Piwik. They lived together, they died together.