Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 31 Oct 2019, 13:54
oldengine oldengine is offline
 
Join Date: Mar 2004
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
Reply With Quote
  #2  
Old 31 Oct 2019, 15:23
Dave Dave is online now
 
Join Date: Jun 2010
Real name: Dave
https://www.electrictoolbox.com/upda...ections-mysql/

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).
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 31 Oct 2019, 15:41
Stingray27 Stingray27 is offline
 
Join Date: Jan 2006
Originally Posted by oldengine View Post
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/upda...ections-mysql/

Pay attention to the warning at the end.
Reply With Quote
  #4  
Old 02 Nov 2019, 17:12
romaine's Avatar
romaine romaine is offline
 
Join Date: Jan 2015
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.
__________________
Best smartphones 2018 - smartphones discussion forums, reviews and news.
Tranh phong cảnh, khung tranh đẹp
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 14:17.

Layout Options | Width: Wide Color: