I would need some help to resolve this problem.
Picik sits on a WIndows 2003 server with iis and PHP with 4 gb or ram.
Picik 1.6, upgraded from 1.0
It is used to monitor an intranet with an organisation of 500 people max. Not all at the same time on the intranet. So the traffic is not that huge.
I have disabled archiving from the browser and set up time limit of 3600 seconds for reports
The server still hits 100% cpu with the processes showing
mysqld.exe around 90%
php-cgi.exe around 10%
The only way to get that down is for me to disable logging by setting in the conf
[Tracker]
record_statistics = 0
but of course this does not help because i am not tracking anyone then.
I have also tried to run the windows powershell script with
powershell.exe –Noninteractive –Noprofile –Command “&{E:\piwik\misc\cron\archive.windows.ps1}”
and it returns:
Starting Piwik archiving…
Piwik archiving finished.
Starting Scheduled tasks…
Fatal error: Exception thrown without a stack frame in Unknown on line 0
This is what comes up with SHOW FULLPROCESSLIST\G;
Info: SELECT
site.idsite,
site.main_url,
site.sitesearch_url,
site.sitesearch_parameter
FROM
piwik_site AS site
LEFT JOIN
piwik_log_visit AS visit
ON site.idsite = visit.idsite
LEFT JOIN
piwik_log_link_visit_action AS link
ON visit.idvisit = link.idvisit
LEFT JOIN
piwik_log_action AS action
ON action.idaction = link.idaction_url
WHERE
action.idaction = 33051
SET timestamp=1328664909;
SELECT
site.idsite,
site.main_url,
site.sitesearch_url,
site.sitesearch_parameter
FROM
piwik_site AS site
LEFT JOIN
piwik_log_visit AS visit
ON site.idsite = visit.idsite
LEFT JOIN
piwik_log_link_visit_action AS link
ON visit.idvisit = link.idvisit
LEFT JOIN
piwik_log_action AS action
ON action.idaction = link.idaction_url
WHERE
action.idaction = 33064;
SET timestamp=1328664915;
SELECT
site.idsite,
site.main_url,
site.sitesearch_url,
site.sitesearch_parameter
FROM
piwik_site AS site
LEFT JOIN
piwik_log_visit AS visit
ON site.idsite = visit.idsite
LEFT JOIN
piwik_log_link_visit_action AS link
ON visit.idvisit = link.idvisit
LEFT JOIN
piwik_log_action AS action
ON action.idaction = link.idaction_url
WHERE
action.idaction = 33061;
SET timestamp=1328664917;
SELECT
site.idsite,
site.main_url,
site.sitesearch_url,
site.sitesearch_parameter
FROM
piwik_site AS site
LEFT JOIN
piwik_log_visit AS visit
ON site.idsite = visit.idsite
LEFT JOIN
piwik_log_link_visit_action AS link
ON visit.idvisit = link.idvisit
LEFT JOIN
piwik_log_action AS action
ON action.idaction = link.idaction_url
WHERE
action.idaction = 10;