'max_user_connections' suddenly exceeded

[mightyb]

Out of nowhere... Bam! 'max_user_connections' gets exceeded so that Pligg does not even connect to the database. When i leave the whole thing for a while everything goes back to normal and then the same thing happens again. I Used to run another pligg on this server no problem for over a year. Also my current Pligg used to get over 50.000 daily uniques for weeks and still cope with the traffic. Now when the traffic has actually dropped considerably the problems have started... As you can probably guess there are a lot of unhappy users faced with database connection error for half a day, every other day...

Any ideas guys? I tried changing $globals['mysql_persistent'] to false but nothing has happened.

[savant]

max_user_connections means the number of connections each mysql user has and usually it is set to a default number. you will need to ask your hoster to tweak the database settings.

[mightyb]

Yea, i know what that means. But the host has not changed anything. I assume its something to do with Pligg. Thanks!

[kbeeveer46]

Did you install/upgrade/change the Pligg code recently? It wouldn't make sense that it would be a problem with Pligg if it worked fine before and all the sudden started.

[savant]

Originally Posted by mightyb

Yea, i know what that means. But the host has not changed anything. I assume its something to do with Pligg. Thanks!

Well the host will set it to a default amount. If your site is growing in traffic then those default settings might not be best suited.

Out of nowhere... Bam! 'max_user_connections' gets exceeded so that Pligg does not even connect to the database.

If you haven't changed or updated anything, your host may need top be tweaked for the amopunt of users you're getting

[mightyb]

My host has suspended my account because i kept on killing the database. This is the log:

33807 mightyb1_ localhost mightyb1_p 6 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
33433 mightyb1_ localhost mightyb1_p 191 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
33365 mightyb1_ localhost mightyb1_p 217 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
32875 mightyb1_ localhost mightyb1_p 404 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
31130 mightyb1_ localhost mightyb1_p 1045 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
30605 mightyb1_ localhost mightyb1_p 1234 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
30152 mightyb1_ localhost mightyb1_p 1437 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
30054 mightyb1_ localhost mightyb1_p 1475 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
30055 mightyb1_ localhost mightyb1_p 1475 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
29896 mightyb1_ localhost mightyb1_p 1538 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
29898 mightyb1_ localhost mightyb1_p 1538 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
29596 mightyb1_ localhost mightyb1_p 1642 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
28621 mightyb1_ localhost mightyb1_p 2016 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
28002 mightyb1_ localhost mightyb1_p 2202 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
27509 mightyb1_ localhost mightyb1_p 2400 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
26356 mightyb1_ localhost mightyb1_p 2860 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
25895 mightyb1_ localhost mightyb1_p 3055 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
25363 mightyb1_ localhost mightyb1_p 3262 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
24464 mightyb1_ localhost mightyb1_p 3682 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
23605 mightyb1_ localhost mightyb1_p 4052 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
23149 mightyb1_ localhost mightyb1_p 4268 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
21933 mightyb1_ localhost mightyb1_p 4932 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
21372 mightyb1_ localhost mightyb1_p 5239 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
20944 mightyb1_ localhost mightyb1_p 5396 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
19144 mightyb1_ localhost mightyb1_p 6145 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
18562 mightyb1_ localhost mightyb1_p 6373 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
18521 mightyb1_ localhost mightyb1_p 6410 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
18441 mightyb1_ localhost mightyb1_p 6470 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
18378 mightyb1_ localhost mightyb1_p 6507 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
18245 mightyb1_ localhost mightyb1_p 6565 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
18195 mightyb1_ localhost mightyb1_p 6602 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
18106 mightyb1_ localhost mightyb1_p 6661 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
18040 mightyb1_ localhost mightyb1_p 6697 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
17943 mightyb1_ localhost mightyb1_p 6756 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
17846 mightyb1_ localhost mightyb1_p 6811 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
17782 mightyb1_ localhost mightyb1_p 6852 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
17550 mightyb1_ localhost mightyb1_p 6972 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
17494 mightyb1_ localhost mightyb1_p 7009 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR
15967 mightyb1_ localhost mightyb1_p 7817 Query SELECT DISTINCT pv_user_id, pv_type, pv_page_id FROM pageviews GR

Any ideas what this could be? Thanks a lot guys!

[mightyb]

I have managed to find the problem. Its the last 5 profile views that's been sucking all the resources.

[TrailofDead]

Could you explain further? I'd like to understand how this happened to avoid it.

[johntheentrepreneur]

the sql is too db intensive. What you have to do is to trimp of a whole bunch of the entries in page_view to solve the problem...

this is my only solution at this moment....

[wwwSENSERELYcom]

The best then would be to delete this query, the last 5 profile views are a detail anyway.