Too Many Connections MySQL vB3.8.11
 

Any hints on this as to where to increase the number of connections?

Database error in vBulletin :

mysqli_real_connect(): (HY000/1040): Too many connections
/home/-----/public_html/forum/includes/class_core.php on line 1210

MySQL Error :
Error Number :
Request Date : Thursday, October 31st 2019 @ 12:38:40 PM
Error Date : Thursday, October 31st 2019 @ 12:38:41 PM
Script : http://www.smokstak.com/forum/forumdisplay.php?f=1
Referrer :
IP Address : 174.198.11.64
Username :
Classname : vB_Database_MySQLi
MySQL Version :
Server : 192.252.219.187
User Agent :


Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 3608
#1 catch_db_error() called in on line
#2 mysqli_real_connect() called in [path]/includes/class_core.php on line 1210
#3 vB_Database_MySQLi->db_connect() called in [path]/includes/class_core.php on line 287
#4 vB_Database->connect() called in [path]/includes/init.php on line 207
#5 require_once([path]/includes/init.php) called in [path]/global.php on line 20
#6 require_once([path]/global.php) called in [path]/forumdisplay.php on line 101

<a href="https://www.electrictoolbox.com/update-max-connections-mysql/" target="_blank">https://www.electrictoolbox.com/upda...ections-mysql/</a>

If you get a lot of traffic, that might be a fix. If you don't have a lot of traffic, there might be something else going on that is causing it (for example a database backup running behind the scenes that is locking up the tables).

You set it in your my.cnf file.

https://www.electrictoolbox.com/upda...ections-mysql/

Pay attention to the warning at the end.

You should use memcached for your forum and change sessions from database into memory, that can handle high load problem for your forum pretty well.

In the past, I faced this problem more times and when I used the method above, I am rather get this problem again unless it was a ddos attack.