Running "./console core:purge-old-archive-data all" fails on some system with [Exception] Date format

[mattab]

Running the following command works on most servers (demo2, localhost, etc.)

./console core:purge-old-archive-data all

But on demo.piwik.org it does not work and outputs:

  [Exception]                                                                                                                                                                     
  Date format must be: YYYY-MM-DD, or 'today' or 'yesterday' or any keyword supported by the strtotime function (see http://php.net/strtotime for more information): -2976912000  

core:purge-old-archive-data [--exclude-outdated] [--exclude-invalidated] [--exclude-ranges] [--skip-optimize-tables] [--include-year-archives] [--force-optimize-tables] [dates1] ... [datesN]

We should investigate to make sure this command always work as we use it for time to time.

[sgiehl]

@mattab does that error still occur on demo?

[mattab]

we're now getting:

$ ./console core:purge-old-archive-data all


                                                                                                                                          
  [Exception]                                                                                                                             
  The date '1875-09-01' is a date before first website was online. Try date that's after Aug 6, 1991 (timestamp 681436800).: -2976912000  
                                                                                                                                          


core:purge-old-archive-data [--exclude-outdated] [--exclude-invalidated] [--exclude-ranges] [--skip-optimize-tables] [--include-year-archives] [--force-optimize-tables] [dates1] ... [datesN]

[sgiehl]

would you mind looking up the archive table names in database? Are there any archive_blob / archive_numeric tables that do not have a name like archive_{type}{month}{year}?

[mattab]

here is all tables that contain archive, it seems OK although it has too many archive tables created in the past, and in the future:

(edit: added the second page of table names)

Table Ascending 	Rows 	Type 	Collation 	Size 	Overhead
piwik_archive_blob_1991_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1992_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1993_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1993_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1994_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2008_01 	154,477 	InnoDB 	utf8_general_ci 	54.6 MiB 	-
piwik_archive_blob_2008_02 	216,063 	InnoDB 	utf8_general_ci 	79.7 MiB 	-
piwik_archive_blob_2008_03 	35,925 	InnoDB 	utf8_general_ci 	14.6 MiB 	-
piwik_archive_blob_2008_04 	40,112 	InnoDB 	utf8_general_ci 	16.6 MiB 	-
piwik_archive_blob_2008_05 	50,647 	InnoDB 	utf8_general_ci 	19.6 MiB 	-
piwik_archive_blob_2008_06 	47,755 	InnoDB 	utf8_general_ci 	19.6 MiB 	-
piwik_archive_blob_2008_07 	46,146 	InnoDB 	utf8_general_ci 	18.6 MiB 	-
piwik_archive_blob_2008_08 	52,418 	InnoDB 	utf8_general_ci 	21.6 MiB 	-
piwik_archive_blob_2008_09 	51,906 	InnoDB 	utf8_general_ci 	21.6 MiB 	-
piwik_archive_blob_2008_10 	50,531 	InnoDB 	utf8_general_ci 	20.6 MiB 	-
piwik_archive_blob_2008_11 	54,756 	InnoDB 	utf8_general_ci 	23.6 MiB 	-
piwik_archive_blob_2008_12 	79,495 	InnoDB 	utf8_general_ci 	32.6 MiB 	-
piwik_archive_blob_2009_01 	103,531 	InnoDB 	utf8_general_ci 	51.6 MiB 	-
piwik_archive_blob_2009_02 	71,134 	InnoDB 	utf8_general_ci 	32.6 MiB 	-
piwik_archive_blob_2009_03 	106,934 	InnoDB 	utf8_general_ci 	49.6 MiB 	-
piwik_archive_blob_2009_04 	96,512 	InnoDB 	utf8_general_ci 	43.6 MiB 	-
piwik_archive_blob_2009_05 	115,279 	InnoDB 	utf8_general_ci 	51.6 MiB 	-
piwik_archive_blob_2009_06 	84,506 	InnoDB 	utf8_general_ci 	37.6 MiB 	-
piwik_archive_blob_2009_07 	86,859 	InnoDB 	utf8_general_ci 	39.6 MiB 	-
piwik_archive_blob_2009_08 	95,859 	InnoDB 	utf8_general_ci 	43.6 MiB 	-
piwik_archive_blob_2009_09 	75,075 	InnoDB 	utf8_general_ci 	35.6 MiB 	-
piwik_archive_blob_2009_10 	92,879 	InnoDB 	utf8_general_ci 	42.6 MiB 	-
piwik_archive_blob_2009_11 	91,147 	InnoDB 	utf8_general_ci 	41.6 MiB 	-
piwik_archive_blob_2009_12 	97,190 	InnoDB 	utf8_general_ci 	46.6 MiB 	-
piwik_archive_blob_2010_01 	161,409 	InnoDB 	utf8_general_ci 	76.7 MiB 	-
piwik_archive_blob_2010_02 	126,694 	InnoDB 	utf8_general_ci 	57.6 MiB 	-
piwik_archive_blob_2010_03 	169,728 	InnoDB 	utf8_general_ci 	74.7 MiB 	-
piwik_archive_blob_2010_04 	192,379 	InnoDB 	utf8_general_ci 	93.3 MiB 	-
piwik_archive_blob_2010_05 	187,218 	InnoDB 	utf8_general_ci 	91.3 MiB 	-
piwik_archive_blob_2010_06 	157,154 	InnoDB 	utf8_general_ci 	76.2 MiB 	-
piwik_archive_blob_2010_07 	181,533 	InnoDB 	utf8_general_ci 	89.3 MiB 	-
piwik_archive_blob_2010_08 	302,531 	InnoDB 	utf8_general_ci 	144.4 MiB 	-
piwik_archive_blob_2010_09 	185,888 	InnoDB 	utf8_general_ci 	88.3 MiB 	-
piwik_archive_blob_2010_10 	172,659 	InnoDB 	utf8_general_ci 	82.2 MiB 	-
piwik_archive_blob_2010_11 	206,762 	InnoDB 	utf8_general_ci 	99.3 MiB 	-
piwik_archive_blob_2010_12 	164,639 	InnoDB 	utf8_general_ci 	82.2 MiB 	-
piwik_archive_blob_2011_01 	342,513 	InnoDB 	utf8_general_ci 	176.4 MiB 	-
piwik_archive_blob_2011_02 	310,145 	InnoDB 	utf8_general_ci 	139.3 MiB 	-
piwik_archive_blob_2011_03 	364,921 	InnoDB 	utf8_general_ci 	171.4 MiB 	-
piwik_archive_blob_2011_04 	~571,881 	InnoDB 	utf8_general_ci 	212.5 MiB 	-
piwik_archive_blob_2011_05 	333,427 	InnoDB 	utf8_general_ci 	156.4 MiB 	-
piwik_archive_blob_2011_06 	281,878 	InnoDB 	utf8_general_ci 	132.3 MiB 	-
piwik_archive_blob_2011_07 	265,421 	InnoDB 	utf8_general_ci 	123.3 MiB 	-
piwik_archive_blob_2011_08 	288,609 	InnoDB 	utf8_general_ci 	132.3 MiB 	-
piwik_archive_blob_2011_09 	279,493 	InnoDB 	utf8_general_ci 	129.3 MiB 	-
piwik_archive_blob_2011_10 	413,565 	InnoDB 	utf8_general_ci 	188.5 MiB 	-
piwik_archive_blob_2011_11 	378,388 	InnoDB 	utf8_general_ci 	171.4 MiB 	-
piwik_archive_blob_2011_12 	369,205 	InnoDB 	utf8_general_ci 	166.4 MiB 	-
piwik_archive_blob_2012_01 	~621,176 	InnoDB 	utf8_general_ci 	228.5 MiB 	-
piwik_archive_blob_2012_02 	485,424 	InnoDB 	utf8_general_ci 	214.5 MiB 	-
piwik_archive_blob_2012_03 	402,169 	InnoDB 	utf8_general_ci 	187.4 MiB 	-
piwik_archive_blob_2012_04 	401,660 	InnoDB 	utf8_general_ci 	185.4 MiB 	-
piwik_archive_blob_2012_05 	~551,211 	InnoDB 	utf8_general_ci 	192.5 MiB 	-
piwik_archive_blob_2012_06 	362,029 	InnoDB 	utf8_general_ci 	168.4 MiB 	-
piwik_archive_blob_2012_07 	52,779 	InnoDB 	utf8_general_ci 	19.1 MiB 	-
piwik_archive_blob_2012_08 	205,206 	InnoDB 	utf8_general_ci 	102.3 MiB 	-
piwik_archive_blob_2012_09 	213,973 	InnoDB 	utf8_general_ci 	107.3 MiB 	-
piwik_archive_blob_2012_10 	236,363 	InnoDB 	utf8_general_ci 	134.3 MiB 	-
piwik_archive_blob_2012_11 	241,230 	InnoDB 	utf8_general_ci 	143.3 MiB 	-
piwik_archive_blob_2012_12 	237,838 	InnoDB 	utf8_general_ci 	137.3 MiB 	-
piwik_archive_blob_2013_01 	329,985 	InnoDB 	utf8_general_ci 	217.4 MiB 	-
piwik_archive_blob_2013_02 	260,613 	InnoDB 	utf8_general_ci 	150.3 MiB 	-
piwik_archive_blob_2013_03 	277,943 	InnoDB 	utf8_general_ci 	162.3 MiB 	-
piwik_archive_blob_2013_04 	256,787 	InnoDB 	utf8_general_ci 	163.3 MiB 	-
piwik_archive_blob_2013_05 	258,496 	InnoDB 	utf8_general_ci 	160.3 MiB 	-
piwik_archive_blob_2013_06 	250,600 	InnoDB 	utf8_general_ci 	164.3 MiB 	-
piwik_archive_blob_2013_07 	305,080 	InnoDB 	utf8_general_ci 	193.4 MiB 	-
piwik_archive_blob_2013_08 	284,727 	InnoDB 	utf8_general_ci 	180.3 MiB 	-
piwik_archive_blob_2013_09 	258,695 	InnoDB 	utf8_general_ci 	175.3 MiB 	-
piwik_archive_blob_2013_10 	240,609 	InnoDB 	utf8_general_ci 	167.3 MiB 	-
piwik_archive_blob_2013_11 	216,997 	InnoDB 	utf8_general_ci 	150.3 MiB 	-
piwik_archive_blob_2013_12 	235,643 	InnoDB 	utf8_general_ci 	161.3 MiB 	-
piwik_archive_blob_2014_01 	317,093 	InnoDB 	utf8_general_ci 	248.4 MiB 	-
piwik_archive_blob_2014_02 	270,141 	InnoDB 	utf8_general_ci 	189.3 MiB 	-
piwik_archive_blob_2014_03 	300,337 	InnoDB 	utf8_general_ci 	205.4 MiB 	-
piwik_archive_blob_2014_04 	291,896 	InnoDB 	utf8_general_ci 	197.4 MiB 	-
piwik_archive_blob_2014_05 	~1,803,451 	InnoDB 	utf8_general_ci 	1 GiB 	-
piwik_archive_blob_2014_06 	270,639 	InnoDB 	utf8_general_ci 	183.3 MiB 	-
piwik_archive_blob_2014_07 	291,159 	InnoDB 	utf8_general_ci 	189.3 MiB 	-
piwik_archive_blob_2014_08 	269,823 	InnoDB 	utf8_general_ci 	177.3 MiB 	-
piwik_archive_blob_2014_09 	284,337 	InnoDB 	utf8_general_ci 	189.3 MiB 	-
piwik_archive_blob_2014_10 	293,719 	InnoDB 	utf8_general_ci 	195.3 MiB 	-
piwik_archive_blob_2014_11 	271,245 	InnoDB 	utf8_general_ci 	183.3 MiB 	-
piwik_archive_blob_2014_12 	272,875 	InnoDB 	utf8_general_ci 	184.3 MiB 	-
piwik_archive_blob_2015_01 	326,767 	InnoDB 	utf8_general_ci 	270.4 MiB 	-
piwik_archive_blob_2015_02 	293,875 	InnoDB 	utf8_general_ci 	209.4 MiB 	-
piwik_archive_blob_2015_03 	258,208 	InnoDB 	utf8_general_ci 	198.3 MiB 	-

Filters
Containing the word:
Table Ascending 	Rows 	Type 	Collation 	Size 	Overhead
piwik_archive_blob_2015_04 	106,174 	InnoDB 	utf8_general_ci 	149.2 MiB 	-
piwik_archive_blob_2015_05 	105,907 	InnoDB 	utf8_general_ci 	138.2 MiB 	-
piwik_archive_blob_2015_06 	109,110 	InnoDB 	utf8_general_ci 	137.2 MiB 	-
piwik_archive_blob_2015_07 	107,466 	InnoDB 	utf8_general_ci 	132.2 MiB 	-
piwik_archive_blob_2015_08 	114,105 	InnoDB 	utf8_general_ci 	128.2 MiB 	-
piwik_archive_blob_2015_09 	114,532 	InnoDB 	utf8_general_ci 	126.2 MiB 	-
piwik_archive_blob_2015_10 	129,102 	InnoDB 	utf8_general_ci 	138.2 MiB 	-
piwik_archive_blob_2015_11 	117,964 	InnoDB 	utf8_general_ci 	146.2 MiB 	-
piwik_archive_blob_2015_12 	108,330 	InnoDB 	utf8_general_ci 	118.2 MiB 	-
piwik_archive_blob_2016_01 	114,817 	InnoDB 	utf8_general_ci 	154.2 MiB 	-
piwik_archive_blob_2016_02 	103,627 	InnoDB 	utf8_general_ci 	127.2 MiB 	-
piwik_archive_blob_2016_03 	104,363 	InnoDB 	utf8_general_ci 	131.2 MiB 	-
piwik_archive_blob_2016_04 	101,978 	InnoDB 	utf8_general_ci 	127.2 MiB 	-
piwik_archive_blob_2016_05 	112,856 	InnoDB 	utf8_general_ci 	134.2 MiB 	-
piwik_archive_blob_2016_06 	102,642 	InnoDB 	utf8_general_ci 	130.2 MiB 	-
piwik_archive_blob_2016_07 	97,760 	InnoDB 	utf8_general_ci 	116.2 MiB 	-
piwik_archive_blob_2016_08 	100,604 	InnoDB 	utf8_general_ci 	124.2 MiB 	-
piwik_archive_blob_2016_09 	92,750 	InnoDB 	utf8_general_ci 	112.2 MiB 	-
piwik_archive_blob_2016_10 	108,131 	InnoDB 	utf8_general_ci 	132.2 MiB 	-
piwik_archive_blob_2016_11 	106,760 	InnoDB 	utf8_general_ci 	132.2 MiB 	-
piwik_archive_blob_2016_12 	96,942 	InnoDB 	utf8_general_ci 	134.2 MiB 	-
piwik_archive_blob_2017_01 	105,334 	InnoDB 	utf8_general_ci 	165.2 MiB 	-
piwik_archive_blob_2017_02 	89,988 	InnoDB 	utf8_general_ci 	130.2 MiB 	-
piwik_archive_blob_2017_03 	111,352 	InnoDB 	utf8_general_ci 	144.2 MiB 	-
piwik_archive_blob_2017_04 	105,070 	InnoDB 	utf8_general_ci 	119.2 MiB 	-
piwik_archive_blob_2017_05 	121,772 	InnoDB 	utf8_general_ci 	114.2 MiB 	-
piwik_archive_blob_2017_06 	117,900 	InnoDB 	utf8_general_ci 	106.2 MiB 	-
piwik_archive_blob_2017_07 	125,513 	InnoDB 	utf8_general_ci 	114.2 MiB 	-
piwik_archive_blob_2017_08 	112,699 	InnoDB 	utf8_general_ci 	110.2 MiB 	-
piwik_archive_blob_2017_09 	106,843 	InnoDB 	utf8_general_ci 	102.2 MiB 	-
piwik_archive_blob_2017_10 	85,644 	InnoDB 	utf8_general_ci 	102.2 MiB 	-
piwik_archive_blob_2017_11 	76,042 	InnoDB 	utf8_general_ci 	95.1 MiB 	-
piwik_archive_blob_2017_12 	71,736 	InnoDB 	utf8_general_ci 	86.1 MiB 	-
piwik_archive_blob_2018_01 	104,166 	InnoDB 	utf8_general_ci 	235.2 MiB 	-
piwik_archive_blob_2018_02 	77,624 	InnoDB 	utf8_general_ci 	105.1 MiB 	-
piwik_archive_blob_2018_03 	140,108 	InnoDB 	utf8_general_ci 	240.3 MiB 	-
piwik_archive_blob_2018_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2036_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-

[sgiehl]

archive_numeric tables have the same names?
Guess we could fix that problem with a try catch, but would be good to know what causes it...

[mattab]

Hi @sgiehl

I just sent you the full list y email, btw it would be great if we could find or prevent those archive tables to be created in the future... should we create a separate issue or is this something you could open a PR for? (and we'll need to cleanup the tables from the demo DB ideally, in case you could prepare the sql query to run)

[sgiehl]

Thanks. Will have a look at it.