I have since version 2.0.X the following query that takes about 40% of my CPU when running, but it looks like it is doing nothing:
INSERT IGNORE INTO piwik_tmp_log_actions_to_keep SELECT idaction_url FROM piwik_log_link_visit_action WHERE idlink_va >= ? AND idlink_va < ?
I don’t have the table piwik_tmp_log_actions_to_keep, so all the results will be dropped, because of the ‘INSERT IGNORE INTO’ ? But the query is running just for hours, and looks that it is never ending. Should the table piwik_tmp_log_actions_to_keep be in Piwik?
And what is this query doing? It has to do with the cleanup of the old visitors log. For now I daily kill the query, in order to get the full performance back. Else my server goes slower and slower.
So is there anybody who can explain why I have this query running for hours? And is it needed, because the table is never there. The table is not created, at least it does not show up in my PHPMyAdmin.