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

XF 1.5 Too Many Connections

Nirjonadda

Active member
#1
Hello,

I am getting many more Server Error Logs about Too many connections by Mysqli , Please can you let me know, what we need to raise to fixing on this error issue? I am using MariaDB 10.1.15 Version.

PHP:
Server Error Log
Error Info
Zend_Db_Adapter_Mysqli_Exception: Too many connections - library/Zend/Db/Adapter/Mysqli.php:333
Generated By: Unknown Account, 24 minutes ago
Stack Trace

#0 /home/USER/public_html/library/Zend/Db/Adapter/Abstract.php(315): Zend_Db_Adapter_Mysqli->_connect()
#1 /home/nadda/public_html/library/XenForo/Application.php(730): Zend_Db_Adapter_Abstract->getConnection()
#2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config))
#3 /home/nadda/public_html/library/XenForo/Application.php(973): call_user_func_array(Array, Array)
#4 /home/nadda/public_html/library/XenForo/Application.php(1004): XenForo_Application->lazyLoad('db', NULL)
#5 /home/nadda/public_html/library/XenForo/Application.php(1609): XenForo_Application::get('db')
#6 /home/nadda/public_html/library/XenForo/Session.php(236): XenForo_Application::getDb()
#7 /home/nadda/public_html/library/XenForo/Session.php(323): XenForo_Session->__construct()
#8 /home/nadda/public_html/library/XenForo/Session.php(257): XenForo_Session::getPublicSession(Object(Zend_Controller_Request_Http))
#9 /home/nadda/public_html/library/XenForo/Controller.php(293): XenForo_Session::startPublicSession(Object(Zend_Controller_Request_Http))
#10 /home/nadda/public_html/library/XenForo/Controller.php(306): XenForo_Controller->_setupSession('Index')
#11 /home/nadda/public_html/library/XenForo/FrontController.php(350): XenForo_Controller->preDispatch('Index', 'XenForo_Control...')
#12 /home/nadda/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#13 /home/nadda/public_html/index.php(13): XenForo_FrontController->run()
#14 {main}

Request State

array(3) {
  ["url"] => string(35) "http://www.mysite.com/index.php"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(1) {
    ["kPZJ9W_"] => string(7) " HpjUO4"
  }
}
 

Tracy Perry

Well-known member
#4
And if you are your own sysadmin, then simply raising the max connections in your my.cnf will work.
if you don't know where the my.cnf is, run
updatedb && locate my.cnf
it will normally be in /etc or /etc/mysql
Load that file in an editor and look for max connections.