MYSQL blocking PIWIK for incorrect connections

Support & Bugs
1

Hi,

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.

Bye

Kaine

2

setting up a persistent connection is complex because it’s less portable, and probably not as well supported for typical user environments.

there are two performance improvements in the pipe for 1.3: bulk loading and changes to tracker indexes.