Too many connection on MySQL Server


(umpire274) #1

Hi all.

I’ve this problem. On my Piwik installation, and in particular where I run the ‘archive.php’ script, I’ve one problem with a lot of connections to MySQL Cluster Server in TIME WAIT.

I’ve attached a particular of ‘netstat -an’ command of this server.

Someone can help me?


(umpire274) #2

Update.

I’ve get this error:

Host ‘x’ is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts’
Backtrace:

#0 …/web_analytics/libs/Zend/Db/Adapter/Abstract.php(304): Zend_Db_Adapter_Mysqli->_connect()
#1 …/web_analytics/core/Piwik.php(1479): Zend_Db_Adapter_Abstract->getConnection()
#2 …/web_analytics/core/FrontController.php(218): Piwik::createDatabaseObject()
#3 …/web_analytics/index.php(103): Piwik_FrontController->init()
#4 {main}

There’s something in the MySQL configuration that I can do to solve this?

A.