Attachment:
[error.jpg](http://issues.piwik.org/attachments/5637/error.jpg)

Attachment:
[error.2.jpg](http://issues.piwik.org/attachments/5637/error.2.jpg)

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

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

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.

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.