Big database


(steffan0815) #1

is there an plugin to reduce the memory size of the database? i cant find an option… any ideas?!


(Richard) #2

yes that is true!

for my sites in 2 months around 25 MB (per month 5000-6000 visitors)

Had anyone an idea to reduce the data volume?
I think 120 MB or more per year is not realy nice.


(Thomas Seifert) #3

You think so? I’m at 900 MB after two months ;-).
Well, as far as I read this is around double the real size. The visit tables are kept until a stable version is released to have the possibility to reanalyze them when new features or better algorithms are implemented.


(Jens) #4

Do i need to keep the piwik_archive_* tables for old months, or can i delete them (after backing them up)?


(DriverDan) #5

To free up a lot of space run the archive script located at piwik/misc/cron/archive.sh then use the database query in the troubleshooting faq #42 (Troubleshooting - Analytics Platform - Matomo) to remove archived data from piwik_log_visit and piwik_log_link_visit_action. After that’s done optimize all your tables.


(Richard) #6

The archive.sh script run every night style_emoticons/<#EMO_DIR#>/tongue.gif
FAQ #42 sounds good I will test it style_emoticons/<#EMO_DIR#>/tongue.gif


(biahoi) #7

the link is not working: Troubleshooting - Analytics Platform - Matomo and how can i run the script?! do i need to connect via telnet?! Is there a howto? thx


(mirandam) #8

use without “www” instead.


(biahoi) #9

yes, thats it. thx