How many connections are needed?

(hank7) #1

Hi there,

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?

(michaelc) #2

Hi hank7,

Welcome to the Piwik community forums.

Did you try to increase the ‘max_user_connections’ value for the user used by Piwik in your MySql database?

Please read more here:

(hank7) #3

Hi michaelc,

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.

(hank7) #4

Today i tried again. Called…;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.

(hank7) #5

Finally I found…ber/000425.html

Are there any news on this topic?

(hank7) #6

nobody? style_emoticons/<#EMO_DIR#>/huh.gif push

(hank7) #7

piwik_log_link_visit_action 1,679,824 entries - 50,1 MiB
piwik_log_visit 1,180,988 entries - 407,9 MiB


(Matthieu Aubry) #8

[quote=hank7 @ Feb 20 2009, 05:20 PM]piwik_log_link_visit_action 1,679,824 entries - 50,1 MiB
piwik_log_visit 1,180,988 entries - 407,9 MiB