archive_blob table sizes


(xurizaemon) #1

so we run archive.sh every morning with great faith, and it does run properly, but we still have many huge archive_blob tables sitting around

ie (table sizes in KB)

piwik_access size: 627
piwik_archive_blob_2008_01 size: 2483605
piwik_archive_blob_2008_06 size: 1
piwik_archive_blob_2008_07 size: 19219035
piwik_archive_blob_2008_08 size: 19539387
piwik_archive_blob_2008_09 size: 22205579
piwik_archive_blob_2008_10 size: 24984425
piwik_archive_blob_2008_11 size: 22972165
piwik_archive_blob_2008_12 size: 18417669
piwik_archive_blob_2009_01 size: 17136679
piwik_archive_blob_2009_02 size: 16017425
piwik_archive_blob_2009_03 size: 21586983
piwik_archive_blob_2009_04 size: 15430399
piwik_archive_blob_2009_05 size: 7046773
piwik_archive_numeric_2008_01 size: 5525
piwik_archive_numeric_2008_06 size: 9520333
piwik_archive_numeric_2008_07 size: 157997
piwik_archive_numeric_2008_08 size: 126617
piwik_archive_numeric_2008_09 size: 124863
piwik_archive_numeric_2008_10 size: 125163
piwik_archive_numeric_2008_11 size: 121583
piwik_archive_numeric_2008_12 size: 120589
piwik_archive_numeric_2009_01 size: 114607
piwik_archive_numeric_2009_02 size: 102995
piwik_archive_numeric_2009_03 size: 117211
piwik_archive_numeric_2009_04 size: 110071
piwik_archive_numeric_2009_05 size: 53641
piwik_goal size: 1
piwik_log_action size: 3851733
piwik_log_conversion size: 1
piwik_log_link_visit_action size: 49938298
piwik_log_profiling size: 1
piwik_log_visit size: 186232614
piwik_logger_api_call size: 31330
piwik_logger_error size: 1
piwik_logger_exception size: 1
piwik_logger_message size: 1
piwik_option size: 1498
piwik_site size: 158
piwik_site_url size: 77
piwik_user size: 1040
piwik_user_dashboard size: 1134
piwik_user_language size: 1

i just dropped piwik_archive_blob_2008_06 because it was 700MB+, and piwik has put it back, but i don’t mind small tables, just massive ones

shouldn’t archive.sh be pruning these tables for us? do they contain useful data?

thanks in advance