Piwik_archive_blob unnormally large?


(Andreas Schnederle-Wagner) #1

Hey there,
I just noticed that some of the piwik_archive_blob Tables are unormally large in size?

See here:

Any idea what could cause this? And how to fix?

thx, bye from Austria
Andreas Schnederle-Wagner


(Andreas Schnederle-Wagner) #2

@matthieu - I guess you could help me on this?! :wink:


(Andreas Schnederle-Wagner) #3

really noone who can help on this? :frowning:


(Matthieu Aubry) #4

Try to run the command ./console core:purge-old-archive-data


(Andreas Schnederle-Wagner) #5

@matthieu - command didn’t touch those Tables … only new ones! :frowning:

php console core:purge-old-archive-data  
Purging outdated archives for 2017_05...Done. [Time elapsed: 0.447s]
Purging invalidated archives for 2017_05...Done. [Time elapsed: 0.789s]
Purging custom range archives for 2017_05...Done. [Time elapsed: 0.004s]
Optimizing archive tables...
Optimizing table piwik_archive_numeric_2017_05...Done. [Time elapsed: 9.372s]
Optimizing table piwik_archive_blob_2017_05...Done. [Time elapsed: 21.377s]  

Andreas


(Andreas Schnederle-Wagner) #6

alright …

php console core:purge-old-archive-data 2016-01-01

did the Trick … now the Table is 470MB instead of 4,6GB … :wink:

php console core:purge-old-archive-data all

should fix the Problem for all Tables, right?


(Matthieu Aubry) #7

right. let us know if not working for you


(Andreas Schnederle-Wagner) #8

worked as expected:


(Andreas Schnederle-Wagner) #9

Hey there,
just noticed that one Table resists to get smaller - even with the purge command … no big deal - but just out of curiosity … any ideas on that?

thx, bye from Austria
Andreas


(Andreas Schnederle-Wagner) #10

Hey there,
got another Table which is significant bigger than all others … “php console core:purge-old-archive-data all” didn’t make it smaller.
Anything I can do here? Any ideas what’s causing this?

thx, bye from Austria
Andreas


(Fabian Dellwing) #11