user-connection problem

[wfcmod]

Today my site was completely offline because of an SQL error. The max-user-connection was exeeded. This was the error message created by vbulletin:

****************************************
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User joosenr_vb has already more than 'max_user_connections' active connections /home/joosenr/public_html/vb3/includes/class_core.php on line 271

MySQL Error :
Error Number :
Date : Saturday, November 4th 2006 @ 04:49:10 PM
Script : http://www.webfotoclub.nl/showphoto.php?photo=1288
Referrer :
IP Address : 72.30.177.222
Username :
Classname : vb_database
**************************************************

I host my site at midphase, a very big and proffesional host. The SQL max settings for this server are as follow:

max_connections 600
max_delayed_threads 20
max_heap_table_size 16777216
max_insert_delayed_threads 20
max_join_size 4294967295
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_tmp_tables 32
max_user_connections 40
max_write_lock_count 4294967295

As you can see the max-user-connections is set to 40, which should enable a pretty big forum. Is there any script in photopost that can cause a huge connection load? I only have 700 registered users. The peak of active users was 83. Normally this is around 30-40.

Should I for example reduce the allowed photo-upload size (I have enabled an upload op 5 mb, and let imagemaxic do its work to reduce the size on the server)...Every idea is welcome because my host is (ofcourse) not willing to restart the SQL server every day.

[Chuck S]

Have your host keep an eye on the processes and see if they can determine what is causing this. I really dont have any advise other than to maybe turn off who's online maybe the photopost sidebar so the number of queries or server load is lower.