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