We recently upgrading to Piwik 6.x (and subsequently 7 and now 8). For all upgrades (and I cannot hand on heard attribute the issue to the upgrade), the Piwik site has become extremely slow and unusable.
We’re running on MySQL 5.1.37 (using PDO), PHP 5.3.2, Apache 2.2.14 (all on Ubuntu 10.04 LTS).
The issue seems to be that the AJAX requests are queuing up and timing out. This should be clear in the following image from Firebug:
As you can see, each AJAX request seems to die after ~30secs (although the request seems to actually work in that the dashboard is populated - eventually).
PHP’s max execution time is set to 60 secs (not a typo) and there’s no fatal exceeding max execution time in any logs. Memory to 512MB.
I’ve also tried a fresh database and a fresh install and all have the same effect.
At this point I’m pulling my hair out!
Anyone have any suggestions / solutions? Could it be an Apache config I’m missing (using the standard as installed).
Thanks and kind regards,