@anonymous-piwik-user opened this Issue on May 9th 2008

I ussing innoBD engine for my piwik because my piwik need insert 800 rows peer second
when I report my piwik . it happend this error:
'''
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1374347 bytes) in C:\xampp\htdocs\piwik\modules\ArchiveProcessing\Record\Blob.php on line 30'''

my DB with
_log_link_visit_action table has 435,694 record nows

Keywords: Allowed memory size

@anonymous-piwik-user commented on May 9th 2008

Attachment:
error.jpg

@anonymous-piwik-user commented on May 9th 2008

Attachment:
error.2.jpg

@anonymous-piwik-user commented on May 9th 2008

I'm using innoBD engine for my piwik because it has to insert 800 lines per second. When I reported, there was an error.
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1374347 bytes) in C:\xampp\htdocs\piwik\modules\ArchiveProcessing\Record\Blob.php on line 30

My DB with
_log_link_visit_action table has 435,694 record nows

@anonymous-piwik-user commented on May 14th 2008

This comes up a lot in php+mysql apps. Take a look at the kludge posted here:

http://mysqldba.blogspot.com/2008/03/i-write-db-scripts-in-php.html

@anonymous-piwik-user commented on May 17th 2008

The same error can be reproduced in the piwik example page itself:

go to http://piwik.org/demo/
and pass the mouse over the word "Day" (on top of the page) and click it: select "Year".
Multiple plugins will show the error.

@mattab commented on May 24th 2008 Owner

We are working on this memory issue.
The first solution will be to automatically truncate the DataTable to a fixed number of rows, for example 500. eg. we will save only the first 500 keywords in the database, the first 500 refering websites, etc.

This will hopefully solve most of the cases.

This is only the first step though, there is also a lot to do on the memory optimization side of the piwik logs compiling process.

This Issue was closed on June 26th 2008
Powered by GitHub Issue Mirror