My poor server’s taking a real beating since the latest piwik upgrade, MySQL is maxing out one CPU core trying to keep up with the normal demand. The Piwik dash wouldn’t load at all until I upgraded to the latest trunk version 1.1.2b1, now it takes forever to display only the first part of the page, and no websites at all.
Most of the time though I’m still getting this:
Fatal error: Maximum execution time of 45 seconds exceeded in \stats\libs\Zend\Db\Statement\Pdo.php on line 228
Logging on to the server itself gets me the standard piwik pages, but it’s unbearably slow and the CPU’s running pretty hot.
Would love to get my server back to the responsive little monster it used to be!! What can I do to help solve this problem?