i’ve got a “high” traffic website with 300.000 unique vistors per month.
I use piwik since approx. 9 month and never experienced serious problems. At night i run a cronjob and so statistics where always fine.
But since some days i get “#1226 - User has exceeded the ‘max_user_connections’ resource” from my mySQL Database every morning. I stopped the crontab. In the next days everything was okay again.
So I thought - okay this has something to do with Piwik. So I updated to the latest version and called the stats page without running a cronjob before to see what is happening.
And again my mySQL had to many connections and closed down for everything else.
I checked this. There are serveral piwik connections open about 30minutes without a single query. Some are locked.
Is this a speed issue? What can i do now?