• 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?

#1
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) {
}
}
 
#5
my.cnf is already set to this on 16GB RAM, 8 Core server?

[mysqld]
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_user_connections=100

innodb_file_per_table=1
open_files_limit=6998
[mysqld_safe]

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 384M
sort_buffer = 384M
read_buffer = 256M
write_buffer = 256M

[mysqlhotcopy]
interactive-timeout
 

Jeremy

Well-known member
#6
Too many people are connecting to your server at the instance you receive the errors. max_user_connections is the value.
 

Mike

XenForo developer
Staff member
#7
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.
 

craigiri

Well-known member
#8
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.