I’m using Piwik 1.6, and whenever I try and use it, it is incredibly slow and unresponsive. Most of the time none of the dashboard even loads, it just says “Loading Data…”.
I’ve increased the memory_limit to 256M, and the max_input_time to 120 with no affect.
I turned on MySQL slow queries, and one query keeps coming up over and over:
SELECT GET_LOCK(‘piwik’stats.piwik_/1/1/2011-10-20,2011-10-20/767a9cb5cdee96769f2b7v2a6a8edc4f’, 1);
I also get the following errors in apache:
PHP Fatal error: Call to undefined function is_resource() in /var/www/stats/libs/Zend/Log/Writer/Stream.php on line 117
PHP Fatal error: Call to undefined function session_write_close() in /var/www/stats/libs/Zend/Session.php on line 691
Any help is much appreciated!