Admin Help Please

[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 ---------------

Originally Posted by Marco van Herwaarden

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