Intermittent database error

[josepmgm]

Hello,
Some days ago the users of my forum are finding an intermittent database error when they intent to access to the web www.cromosdefutbol.com/forum
This is the code of the error:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User XXXXXX already has more than 'max_user_connections' active connections
/hermes/web10/b758/pow.XXXXXXXXXXXX/htdocs/forum/includes/class_core.php on line 273

I have put a suppor ticket but when the customer support test the web, it runs (as I have said it is a intermittent issue...).

I have asked to the forum of vBulletin.com and they said that it seems that my host are limiting the number of MySQL connections they allow we to have. Is it true? The database error appears with a few users or with more users indistinctly...

My database is on the mysql15 server, like other web that I have in the same database server in a second account of Powweb. The web is www.insigniasdefutbol.com and sometimes also has access problems (and I have only 27 registered users and no more of two connect at the same time...).

I would need a solution because I have the users dissatisfied with us...

Thanks and excuse my English ;)

[HalfaBee]

You can check what mysql queries are running by using this sql.
SHOW FULL PROCESSLIST.
I would suggest putting this in a simple php script and echoing the results.
You can then see why there are lots of concurent connections.

Queries on the information_schema DB can remain for quite a while.
I have seen queries checking permission for 100-200 seconds, even after the script is killed.
So, when you get the error keep running the script until its makes a connection, then you will see all the other current queries.

[HalfaBee]

Yep, too many DB's on the one server.
IS table then gets very large and slow.