Empty piwik_archive_blob_20xx_XX / piwik_archive_numeric_20xx_xx Tables

Hey there,
we got lot’s of empty piwik_archive_blob_20xx_XX / piwik_archive_numeric_20xx_xx Tables.

Can I safely delete them or are they needed?

thx
Andreas Schnederle-Wagner

Hi,

I just checked and I also have a lot of empty archive tables (they all seem to be of months before I started using piwik).

I think they can be deleted, but only if you know that there should be no data in these months and better make a backup before you do so.

@Findus23 - do you “think” they can be deleted safely or do you “know” it?
(of course only when they are empty)
If I remember right Piwik created them a long time ago when I upgraded Piwik …

I won’t give you a warranty that piwik won’t break or the server start burning if you delete those tables

But I am pretty sure you weren’t using Piwik in 2004 and 2005. So as long as you didn’t import older visitor data there should be no reports about those months and you can safely delete them.

alright - and gone they are … let’s see if everything blows up!

``````DROP TABLE `piwik_archive_blob_2003_01`, `piwik_archive_blob_2004_01`, `piwik_archive_blob_2004_07`, `piwik_archive_blob_2004_08`, `piwik_archive_blob_2004_09`, `piwik_archive_blob_2004_10`, `piwik_archive_blob_2004_11`, `piwik_archive_blob_2004_12`, `piwik_archive_blob_2005_01`, `piwik_archive_blob_2005_02`, `piwik_archive_blob_2005_03`, `piwik_archive_blob_2005_04`, `piwik_archive_blob_2005_05`, `piwik_archive_blob_2005_06`, `piwik_archive_blob_2005_07`, `piwik_archive_blob_2005_08`, `piwik_archive_blob_2005_09`, `piwik_archive_blob_2005_10`, `piwik_archive_blob_2005_11`, `piwik_archive_blob_2005_12`, `piwik_archive_blob_2006_01`, `piwik_archive_blob_2006_02`, `piwik_archive_blob_2006_03`, `piwik_archive_blob_2006_04`, `piwik_archive_blob_2006_05`, `piwik_archive_blob_2006_06`, `piwik_archive_blob_2006_07`, `piwik_archive_blob_2006_08`, `piwik_archive_blob_2006_09`, `piwik_archive_blob_2006_10`, `piwik_archive_blob_2006_11`, `piwik_archive_blob_2006_12`, `piwik_archive_blob_2007_01`, `piwik_archive_blob_2007_02`, `piwik_archive_blob_2007_03`, `piwik_archive_blob_2007_04`, `piwik_archive_blob_2007_05`, `piwik_archive_blob_2007_06`, `piwik_archive_blob_2007_07`, `piwik_archive_blob_2007_08`, `piwik_archive_blob_2007_09`, `piwik_archive_blob_2007_10`, `piwik_archive_blob_2007_11`, `piwik_archive_blob_2007_12`, `piwik_archive_blob_2008_01`, `piwik_archive_blob_2008_02`, `piwik_archive_blob_2008_03`, `piwik_archive_blob_2008_04`, `piwik_archive_blob_2008_05`, `piwik_archive_blob_2008_06`, `piwik_archive_blob_2008_07`, `piwik_archive_blob_2008_08`, `piwik_archive_blob_2008_09`, `piwik_archive_blob_2008_10`, `piwik_archive_blob_2008_11`, `piwik_archive_blob_2008_12`, `piwik_archive_blob_2009_01`, `piwik_archive_blob_2009_02`, `piwik_archive_blob_2009_03`, `piwik_archive_blob_2009_04`, `piwik_archive_blob_2009_05`, `piwik_archive_blob_2009_06`, `piwik_archive_blob_2009_07`, `piwik_archive_blob_2009_08`, `piwik_archive_blob_2009_09`, `piwik_archive_blob_2009_10`, `piwik_archive_blob_2009_11`, `piwik_archive_blob_2009_12`, `piwik_archive_blob_2010_01`, `piwik_archive_blob_2010_02`, `piwik_archive_blob_2010_03`, `piwik_archive_blob_2010_04`, `piwik_archive_blob_2010_05`, `piwik_archive_blob_2010_06`, `piwik_archive_blob_2010_07`, `piwik_archive_blob_2010_08`, `piwik_archive_blob_2010_09`, `piwik_archive_blob_2010_10`, `piwik_archive_blob_2010_11`, `piwik_archive_blob_2010_12`, `piwik_archive_blob_2011_01`, `piwik_archive_blob_2011_02`, `piwik_archive_blob_2011_03`, `piwik_archive_blob_2011_04`, `piwik_archive_blob_2011_05`, `piwik_archive_blob_2011_06`, `piwik_archive_blob_2011_07`, `piwik_archive_blob_2011_08`, `piwik_archive_blob_2011_09`, `piwik_archive_blob_2011_10`, `piwik_archive_blob_2011_11`, `piwik_archive_blob_2011_12`;

DROP TABLE `piwik_archive_numeric_2003_01`, `piwik_archive_numeric_2004_01`, `piwik_archive_numeric_2004_07`, `piwik_archive_numeric_2004_08`, `piwik_archive_numeric_2004_09`, `piwik_archive_numeric_2004_10`, `piwik_archive_numeric_2004_11`, `piwik_archive_numeric_2004_12`, `piwik_archive_numeric_2005_01`, `piwik_archive_numeric_2005_02`, `piwik_archive_numeric_2005_03`, `piwik_archive_numeric_2005_04`, `piwik_archive_numeric_2005_05`, `piwik_archive_numeric_2005_06`, `piwik_archive_numeric_2005_07`, `piwik_archive_numeric_2005_08`, `piwik_archive_numeric_2005_09`, `piwik_archive_numeric_2005_10`, `piwik_archive_numeric_2005_11`, `piwik_archive_numeric_2005_12`, `piwik_archive_numeric_2006_01`, `piwik_archive_numeric_2006_02`, `piwik_archive_numeric_2006_03`, `piwik_archive_numeric_2006_04`, `piwik_archive_numeric_2006_05`, `piwik_archive_numeric_2006_06`, `piwik_archive_numeric_2006_07`, `piwik_archive_numeric_2006_08`, `piwik_archive_numeric_2006_09`, `piwik_archive_numeric_2006_10`, `piwik_archive_numeric_2006_11`, `piwik_archive_numeric_2006_12`, `piwik_archive_numeric_2007_01`, `piwik_archive_numeric_2007_02`, `piwik_archive_numeric_2007_03`, `piwik_archive_numeric_2007_04`, `piwik_archive_numeric_2007_05`, `piwik_archive_numeric_2007_06`, `piwik_archive_numeric_2007_07`, `piwik_archive_numeric_2007_08`, `piwik_archive_numeric_2007_09`, `piwik_archive_numeric_2007_10`, `piwik_archive_numeric_2007_11`, `piwik_archive_numeric_2007_12`, `piwik_archive_numeric_2008_01`, `piwik_archive_numeric_2008_02`, `piwik_archive_numeric_2008_03`, `piwik_archive_numeric_2008_04`, `piwik_archive_numeric_2008_05`, `piwik_archive_numeric_2008_06`, `piwik_archive_numeric_2008_07`, `piwik_archive_numeric_2008_08`, `piwik_archive_numeric_2008_09`, `piwik_archive_numeric_2008_10`, `piwik_archive_numeric_2008_11`, `piwik_archive_numeric_2008_12`, `piwik_archive_numeric_2009_01`, `piwik_archive_numeric_2009_02`, `piwik_archive_numeric_2009_03`, `piwik_archive_numeric_2009_04`, `piwik_archive_numeric_2009_05`, `piwik_archive_numeric_2009_06`, `piwik_archive_numeric_2009_07`, `piwik_archive_numeric_2009_08`, `piwik_archive_numeric_2009_09`, `piwik_archive_numeric_2009_10`, `piwik_archive_numeric_2009_11`, `piwik_archive_numeric_2009_12`, `piwik_archive_numeric_2010_01`, `piwik_archive_numeric_2010_02`, `piwik_archive_numeric_2010_03`, `piwik_archive_numeric_2010_04`, `piwik_archive_numeric_2010_05`, `piwik_archive_numeric_2010_06`, `piwik_archive_numeric_2010_07`, `piwik_archive_numeric_2010_08`, `piwik_archive_numeric_2010_09`, `piwik_archive_numeric_2010_10`, `piwik_archive_numeric_2010_11`, `piwik_archive_numeric_2010_12`, `piwik_archive_numeric_2011_01`, `piwik_archive_numeric_2011_02`, `piwik_archive_numeric_2011_03`, `piwik_archive_numeric_2011_04`, `piwik_archive_numeric_2011_05`, `piwik_archive_numeric_2011_06`, `piwik_archive_numeric_2011_07`, `piwik_archive_numeric_2011_08`, `piwik_archive_numeric_2011_09`, `piwik_archive_numeric_2011_10`, `piwik_archive_numeric_2011_11`, `piwik_archive_numeric_2011_12`;
``````

Andreas

1 Like