• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 Too many connections error?

#1
I'm getting weird errors with my new version of XenForo once I cut over from my SMF site.

Code:
Zend_Db_Adapter_Mysqli_Exception: Too many connections - library/Zend/Db/Adapter/Mysqli.php:333
Generated By: Unknown Account, 32 minutes ago
Stack Trace

#0 /home/site/www/www/forums/library/Zend/Db/Adapter/Abstract.php(315): Zend_Db_Adapter_Mysqli->_connect()
#1 /home/site/www/www/forums/library/XenForo/Application.php(719): Zend_Db_Adapter_Abstract->getConnection()
#2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config))
#3 /home/site/www/www/forums/library/XenForo/Application.php(960): call_user_func_array(Array, Array)
#4 /home/site/www/www/forums/library/XenForo/Application.php(991): XenForo_Application->lazyLoad('db', NULL)
#5 /home/site/www/www/forums/library/XenForo/Application.php(1561): XenForo_Application::get('db')
#6 /home/site/www/www/forums/library/XenForo/Model.php(161): XenForo_Application::getDb()
#7 /home/site/www/www/forums/library/XenForo/Model/DataRegistry.php(138): XenForo_Model->_getDb()
#8 /home/site/www/www/forums/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
#9 /home/site/www/www/forums/library/XenForo/Dependencies/Abstract.php(147): XenForo_Model_DataRegistry->getMulti(Array)
#10 /home/site/www/www/forums/library/XenForo/FrontController.php(127): XenForo_Dependencies_Abstract->preLoadData()
#11 /home/site/www/www/forums/index.php(13): XenForo_FrontController->run()
#12 {main}

Request State

array(3) {
  ["url"] => string(48) "http://sitename.com/forums/index.php?liveupdate"
  ["_GET"] => array(1) {
  ["liveupdate"] => string(0) ""
  }
  ["_POST"] => array(4) {
  ["_xfRequestUri"] => string(78) "/forums/index.php?threads/rvn-3l-apollo-2x-erllas-1x-lrm-5-tag-ecm-xl225.6470/"
  ["_xfNoRedirect"] => string(1) "1"
  ["_xfToken"] => string(8) "********"
  ["_xfResponseType"] => string(4) "json"
  }
}
Anyone have any thoughts on that?
 
#3
I am having the same problem wiht XF1.2.

On my server (managed and dedicated), max clients is set to 150, and php memory limit is 32mb.

I am not an expert on managing servers so I wonder if this figures are 'up to date'. I am using this server during the last five years.

Thank you.
 

Brogan

XenForo moderator
Staff member
#4
Increase the limit until the errors stop.

It varies from site to site and is dependent on traffic.
 
#5
My host company says that in order to make the server more stable we should LOWER max clients setting.

I don't understand anything.
 

Brogan

XenForo moderator
Staff member
#6
You may want to consider a new host if the limits they impose are not sufficient for the level of traffic your site receives.
 

Mike

XenForo developer
Staff member
#7
I'm not sure if you're talking about the same thing. "MaxClients" is an Apache setting; max_connections is a MySQL setting. Reducing MaxClients may well sort this by simply preventing new connections from being started when your server is busy, but it may also block requests from being served.
 
Top