Now I use piwik/misc/cron/archive.sh and archive.php to archive data, but both met with the following problem. This idsite 2 only has 20K pv every day. But another idsite has 80K pv every day, when archiving, no problem happended.
Settings as followed:
/etc/php.ini
memory_limit = 1024M
piwik/config/config.ini.php
minimum_memory_limit_when_archiving = 1536
Archiving period = week for idsite = 2…
<?xml version="1.0" encoding="utf-8" ?> 3763 77467 69264 104825 121463 130880 119806 115717 93921 98240 89757 104617 63795 Archiving period = month for idsite = 2... PHP Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 8208 bytes) in /opt/piwik/core/DataTable.php on line 1100Archiving period = year for idsite = 2…
PHP Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 8208 bytes) in /opt/piwik/core/DataTable.php on line 1100
Archiving for idsite = 2 done!
Reports archiving finished.