Allowed memory size of 404750336 bytes exhausted


(edvsb) #1
        <result date="2010-03-29 to 2010-04-04" />
        <result date="2010-04-05 to 2010-04-11" />
        <result date="2010-04-12 to 2010-04-18">5641</result>
        <result date="2010-04-19 to 2010-04-25">7259</result>
        <result date="2010-04-26 to 2010-05-02">8457</result>
        <result date="2010-05-03 to 2010-05-09">8612</result>
        <result date="2010-05-10 to 2010-05-16">9088</result>
        <result date="2010-05-17 to 2010-05-23">8779</result>
        <result date="2010-05-24 to 2010-05-30">9843</result>
        <result date="2010-05-31 to 2010-06-06">2991</result>
</results>
Archiving period = year for idsite = 1...

Fatal error: Allowed memory size of 404750336 bytes exhausted (tried to allocate 262144 bytes) in /xxx/yyy/zzz/piwik/core/DataTable/Manager.php on line 117
h825672:~#

It is only one site with 1000 - 1500 visits per day. What should i do?

Piwik v0.6.2


(Fabian Becker) #2

Can you increase memory_limit in php.ini and set it to 512M?


(edvsb) #3

Yes I can, but that’s a little too much, because that would be 100% of available memory. I think 512 MB for a small page is not appropriate. In addition, I had tried that a few weeks ago and had the same error every Sunday (with v.0.5.5, v0.6rc2 and v0.6.1).

The archiving of years should really be changed. Not everything at once but in small portions and free memory between the steps. Even the database “* _blob” is very large - more than 2 GB.