Live! Visitors causing mysqld to run 100% CPU


(TQdom) #1

Greets - I’ve been using Piwik (and OpenX) for quite a while now and they’re both awesome products! I recently updated to the latest version of Piwik 0.5.5 and notices that the Live! Visitors widget causes mysqld to use 100% CPU.

I am using Piwik 0.5.5 with:

PHP 5.2.6
mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i386) using readline 5.0
Apache/2.2.8

Is anyone else seeing this happen with 0.5.5? It didn’t do this with the previous version.

Thanks!


(vipsoft) #2

I believe there are some index changes going into 0.6 that will help with the Live performance issue.