Live! Visitors causing mysqld to run 100% CPU

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

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


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