My idea: Reducing the Page-Title Length Our Situation: The Page-Title always includes the full Website-Name (20 character). It’s not necessary that the Website-Name appear in piwik and in DB-Table log_action (field “name” – type “4”). Without the Website-Name we reduce the title length 30-40 %. My Questions:
Could this possibly reduce the archive-mem-usage more than 5%?
Is this the best way to realize it:
Add “piwikTracker.setDocumentTitle(“”) to the Tracking code?
Is it okay to rename the page title (field “name”) in table “log_action” in all existing records?
Where can I find the code to rebuild the hash (field “hash”) in table “log_action”?
Hello Lesjokolat, many thanks for your help. In our case it’s the same with PHP 5.4. : Php-Error “Out of memory” when running Piwik archiving. I already use the max “memory_limit“ (php.ini) which is allowed on the shared server.
Thank you. With fastcgi archiving is a bit faster (day-archiving from 96s to 91s) but same “Out of memory” during “month archiving”. We don’t use Suhosin or Python.
Do you think a short title in table “log_action” can reduce archive-mem usage?
Can you help me with my questions above?
If its just the title and by 20 characters etc then perhaps when it involves millions of pages or error messages but i think the problem is something else here…
Can you check your web server error logs and see what is showing up?
With fastcgi you can also adjust the timeout settings. Is your server a windows or linux based one?
With fastcgi archiving is a bit faster (day-archiving from 96s to 91s) but same “Out of memory” during “month archiving”. We don’t use Suhosin or Python.