Admin Help Please

[Vi3t4Lov3]

I have this error everyday
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User thien8_diendan already has more than 'max_user_connections' active connections
/home/thien8/public_html/forum/includes/class_core.php on line 274

can I fix that problem?...if Yes please show me how? ;)
Thank You

[Marco van Herwaarden]

You will need to contact your host about this.

[Vi3t4Lov3]

oh ok...thanks alot...

[Vi3t4Lov3]

when I contact the hosting webmaster, they said ask the coder

Please note that the issue happens because of the exceeding of the maximum allowed user connections from the user thien8_diendan. This issue happens due to the use of persistent mysql connections in the mysql server.

ie mysql_pconnect. Please contact your code developer and modify your scripts to use mysql_connect so that the issue does not reccurs.

------

someone help me please ....how to fixed this problem :(

[nexialys]

in your file: /includes/config.php

$config['MasterServer']['usepconnect'] = 0; << it is supposed to be set to 0 to deactivate.

[Marco van Herwaarden]

It probably already is, or the error message would have included a call to mysql_pconnect().

[edgecutioner]

what host are you on Vi3t4Lov3?

[nexialys]

oh, from what i see, even your host techie is not even a guy who know where he goes.. he talk about permantent connection when your error is not talking about it...

change your host to a more descent one with real service.

[Marco van Herwaarden]

persistent ;)

[Vi3t4Lov3]

It probably already is, or the error message would have included a call to mysql_pconnect().

so ...can I fixed that error

my host from lypha.com

[Marco van Herwaarden]

Nothing has changed, your host will still need to look into this.

And no you are not using persistent connections.

[Vi3t4Lov3]

alright guys ...thank for your comment ....Appreciate that. ;)

--------------- Added at 08:31 ---------------

Nothing has changed, your host will still need to look into this.

And no you are not using persistent connections.


I contact to the hosting server

they said:
We have examined your issue. You were receiving this error because you have exceeded the maximum no of user connections . We see some sleeping connections which arises when you fail to close open queries. Some of the alternatives are to close the mysql connections after each query. You can contact your mysql developer to optimize the connections so as to eliminate the sleeping connections.


can you help me how to optimize the connections so as to eliminate the sleeping connections?

[Marco van Herwaarden]

What they see as "sleeping connections" are just pages that also use shutdown-queries (a query that will be executed after all the other "work" is done to reduce pageloads).

The rela problem here is that they want to limit the number of queries and your board is execeeding their limit. There are only a few options to overcome this:
- Your host raises this limit.
- You turn off settings in vBulletin to reduce the number of queries used. This would however limit the usability of vBulletin.
- If your host allow for the creations of multiple MySQL users for a database, then there is a work-around for this limit. This would however mean that you would be circumventing the limits set by your host, and i am not sure if they will be hapy with that.
- Remove modifications that add additional queries.
- Change hosts

[vuiveclub]

I had the same error :)