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

XF 1.2 Too Many Connections?

Discussion in 'Troubleshooting and Problems' started by Gizzymomo, Dec 19, 2013.

  1. Gizzymomo

    Gizzymomo Member

    Keeping get this error on the admin section of my forum. Any idea.

    Zend_Db_Adapter_Mysqli_Exception: Too many connections - library/Zend/Db/Adapter/Mysqli.php:333

    Stack Trace
    #0 /home/ecigssac/public_html/library/Zend/Db/Adapter/Abstract.php(315): Zend_Db_Adapter_Mysqli->_connect()
    #1 /home/ecigssac/public_html/library/XenForo/Application.php(684): Zend_Db_Adapter_Abstract->getConnection()
    #2 [internal function]: XenForo_Application->loadDb(Object(Zend_Config))
    #3 /home/ecigssac/public_html/library/XenForo/Application.php(921): call_user_func_array(Array, Array)
    #4 /home/ecigssac/public_html/library/XenForo/Application.php(952): XenForo_Application->lazyLoad('db', NULL)
    #5 /home/ecigssac/public_html/library/XenForo/Application.php(1359): XenForo_Application::get('db')
    #6 /home/ecigssac/public_html/library/XenForo/Model.php(161): XenForo_Application::getDb()
    #7 /home/ecigssac/public_html/library/XenForo/Model/DataRegistry.php(138): XenForo_Model->_getDb()
    #8 /home/ecigssac/public_html/library/XenForo/Model/DataRegistry.php(97): XenForo_Model_DataRegistry->_getMultiFromDb(Array)
    #9 /home/ecigssac/public_html/library/XenForo/Dependencies/Abstract.php(144): XenForo_Model_DataRegistry->getMulti(Array)
    #10 /home/ecigssac/public_html/library/XenForo/FrontController.php(127): XenForo_Dependencies_Abstract->preLoadData()
    #11 /home/ecigssac/public_html/index.php(13): XenForo_FrontController->run()
    #12 {main}
    Request State
    array(3) {
    ["url"] => string(34) "http://www.ecigssa.co.za/index.php"
    ["_GET"] => array(0) {
    ["_POST"] => array(0) {
  2. Brogan

    Brogan XenForo Moderator Staff Member

    This is a server limitation.
    Contact your host and they should be able to help.
  3. Gizzymomo

    Gizzymomo Member

    I am the server admin, where could I change that.
  4. Gizzymomo

    Gizzymomo Member

    Also what would be the recommended number
  5. Gizzymomo

    Gizzymomo Member

    my.cnf is already set to this on 16GB RAM, 8 Core server?

    max_connections = 600
    key_buffer = 256M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 4000
    thread_cache_size = 286
    interactive_timeout = 25
    wait_timeout = 7000
    connect_timeout = 10
    max_allowed_packet = 128M
    max_connect_errors = 10
    query_cache_type = 1
    thread_concurrency = 16
    query_cache_limit = 5M
    query_cache_size = 384M
    tmp_table_size = 32M


    max_allowed_packet = 16M

    key_buffer = 384M
    sort_buffer = 384M
    read_buffer = 256M
    write_buffer = 256M

  6. Jeremy

    Jeremy XenForo Moderator Staff Member

    Too many people are connecting to your server at the instance you receive the errors. max_user_connections is the value.
  7. Mike

    Mike XenForo Developer Staff Member

    This particular error is likely the max_connections mentioned in that my.cnf. It's the limit imposed in MySQL so the connection is rejected. When it happens, you'd need to be logged into MySQL as the root user. You can then run a SHOW PROCESSLIST; query to see all the connections and debug what is causing it. Note that the connection limit is shared amongst all apps/users connecting to that MySQL server.
  8. craigiri

    craigiri Well-Known Member

    Not a db expert, but are you missing an innodb buffer pool setting???

    "Ideally, you set the size of the buffer pool to as large a value as practical, leaving enough memory for other processes on the server to run without excessive paging. The larger the buffer pool, the more InnoDB acts like an in-memory database, reading data from disk once and then accessing the data from memory during subsequent reads"

    Also, make sure you look at the robots which are connecting and get rid of those you don't need.
  9. Gizzymomo

    Gizzymomo Member

    Ok thanks for the input guys, changed some setting will see how it goes.

Share This Page