Matomo is slow.... Errors in php.log


#1

Hi, I’m experiencing extreme piwik slowness.
the calls “piwik.php?action_name=” “piwik.js” and “configs.php?idsite=” take several seconds…

in the php.logs I find many of …

Error in Matomo (tracker): SQLSTATE[HY000] [2002] Connection refused

PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/www/html/piwik/libs/Zend/Db/Adapter/Pdo/Abstract.php:128…

Error in Matomo (tracker): Error query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction In query: INSERT INTO matomo_log_form


(Lukas Winkler) #2

Hi,

This error message means that PHP isn’t able to reach MySQL. So please check that the connection between your webserver and the database server is reliable and fast.


#3

Hi Lukas, mysql is up and running,

it can be reached from the frontend servers,
and in the db the data are present, not all, but nevertheless the communication is active


#4

same problem in vaidating environment 3.8

Error query: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying