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.
i had no limitation in user connections. I use a shared hosting solution and my provider changed my max user connection value now to 25, because piwik had this error. When it was unlimitated it stopped the database from accepting connections from the other users too.
In the last month i had more visitors. Maybe piwik now needs more (too much) connections.
Piwik is still running, but I can’t start the cronjob again or log in the web interface because then the database really fast don’t accept any connection anymore.
Today i tried again. Called http://myweb.de/piwik/?module=Home&act…;date=yesterday. Loading … 4 minutes. Finished with “500 Internal Server Error”. If I call it again it keeps “Loading” for 6 hours and i can not access my database anymore.