PDA

View Full Version : Too Many Connections MySQL vB3.8.11


oldengine
10-31-2019, 11:54 AM
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

Dave
10-31-2019, 01:23 PM
<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).

Stingray27
10-31-2019, 01:41 PM
Any hints on this as to where to increase the number of connections?
You set it in your my.cnf file.

https://www.electrictoolbox.com/update-max-connections-mysql/

Pay attention to the warning at the end.

romaine
11-02-2019, 03:12 PM
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.