I run PIWIK on a external MySQL database and have the tracking code on the same server as the website is.
My problem is that the mysql server blocks the website server now and then which has to be removed with “FLUSH HOSTS”.
The website is quite busy but when i watch the latest entrys in the PIWIK DB then i see nothing strange.
Is there anything else i could possibly check for? I would love to have 1 permanent connection but its not possible with piwik right now it seems.