Small board getting max_user_connection errors

[chikuru]

The forum is very small and rarely gets 20 users online (guest and memers combined).
max_user_connection is set to 80
persistent connection settings is:
$config['MasterServer']['usepconnect'] = 0;

What could be the problem and possible fix?

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

[final kaoss]

And this is on a vps?

[Dave]

Well the fix is pretty simple, increase the value of max_user_connection. Most shared hosts usually set it to 250/300 so I would set it to that first and see if that fixes it.

[chikuru]

Originally Posted by Dave

Well the fix is pretty simple, increase the value of max_user_connection. Most shared hosts usually set it to 250/300 so I would set it to that first and see if that fixes it.

Is mysql server restart needed after changing the value?

[bzcomputers]

Originally Posted by chikuru

Is mysql server restart needed after changing the value?

Yes

[chikuru]

Is there vbulletin-side optimization to reduce max connection and max user connection error?

[Lynne]

No, there is not. There is some article in the articles section for getting around it on some servers, but I have never tried and have no idea if it is still valid.

[Paul M]

Originally Posted by chikuru

Is there vbulletin-side optimization to reduce max connection and max user connection error?

No, its not a vbulletin issue, its a MySQL issue, you value is too low (and your mysql timeout is probably too high).