Hi, We area testing piwik to replace all the awstats in the future, but after 4 days of collecting stats now I run with this error message.
The first configuration was 128Mb of max allowed memory for php-cli and I try to increase to 512Mb without luck :
Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 71 bytes) in /var/www/piwik/core/DataTable/Row.php on line 70
Activating the DB plugin I see that Piwik tables are using 908.4 M, piwik_archive_blob_2009_06 is using 722.5 Mb and piwik_log_visit is using 111.8 Mb. That are the biggets tables.
In my config I was disable the browser archiving and I’ve setup a cronjob for today’s statistics every 10 minutes.
time_before_today_archive_considered_outdated = 600 enable_browser_archiving_triggering = ""
In the past 4 days the site that is configured has 316929, 287628, 320637 and 100683 pageviews according awstats.
PHP Version : 5.2.0
MySQL Version : 5.0.51a
Piwik Version : 0.4.1
Any help or tip to try to optimize/fix this problem is appreciate style_emoticons/<#EMO_DIR#>/smile.gif