Manual Delete in SQL DB


#1

Is it possible and okay if i just go and delete thes Rows in the SQL DB


piwik_archive_blob_2012_01	211,11	62.4 MiB
piwik_archive_blob_2012_02	172,063	48.7 MiB
piwik_archive_blob_2012_03	187,736	52.4 MiB
piwik_archive_blob_2012_04	192,626	53.6 MiB
piwik_archive_blob_2012_05	119,358	33.7 MiB
piwik_archive_blob_2012_06	124,579	35.5 MiB
piwik_archive_blob_2012_07	150,101	43.8 MiB
piwik_archive_blob_2012_08	173,565	50.9 MiB
piwik_archive_blob_2012_09	198,623	58.1 MiB
piwik_archive_blob_2012_10	251,847	74.4 MiB
piwik_archive_blob_2012_11	287	85.3 MiB
piwik_archive_blob_2012_12	342,432	102.1 MiB
piwik_archive_blob_2013_01	472,087	146.3 MiB
piwik_archive_blob_2013_02	364,055	107.1 MiB
piwik_archive_blob_2013_03	450,757	131.6 MiB
piwik_archive_blob_2013_04	526,852	154.8 MiB
piwik_archive_blob_2013_05	564,385	166.8 MiB
piwik_archive_blob_2013_06	627,806	198.7 MiB
piwik_archive_blob_2013_07	633,818	202.7 MiB
piwik_archive_blob_2013_08	570,534	184.3 MiB
piwik_archive_blob_2013_09	537,441	180.9 MiB
piwik_archive_blob_2013_10	523,366	178.1 MiB
piwik_archive_blob_2013_11	507,183	173.9 MiB
piwik_archive_blob_2013_12	537,555	184.9 MiB

and


piwik_archive_numeric_2011_12	23	8 KiB
piwik_archive_numeric_2012_01	16,855	2.1 MiB
piwik_archive_numeric_2012_02	17,162	2.8 MiB
piwik_archive_numeric_2012_03	20,217	3.3 MiB
piwik_archive_numeric_2012_04	20,789	3.3 MiB
piwik_archive_numeric_2012_05	20,19	3.2 MiB
piwik_archive_numeric_2012_06	20,233	3.2 MiB
piwik_archive_numeric_2012_07	22,387	3.6 MiB
piwik_archive_numeric_2012_08	21,967	3.6 MiB
piwik_archive_numeric_2012_09	23,565	3.8 MiB
piwik_archive_numeric_2012_10	26,616	4.3 MiB
piwik_archive_numeric_2012_11	28,742	4.6 MiB
piwik_archive_numeric_2012_12	34,423	4.4 MiB
piwik_archive_numeric_2013_01	39,875	5.1 MiB
piwik_archive_numeric_2013_02	37,831	4.8 MiB
piwik_archive_numeric_2013_03	50,715	6.4 MiB
piwik_archive_numeric_2013_04	59,743	7.6 MiB
piwik_archive_numeric_2013_05	63,686	8.1 MiB
piwik_archive_numeric_2013_06	69,105	8.9 MiB
piwik_archive_numeric_2013_07	76,723	9.9 MiB
piwik_archive_numeric_2013_08	74,416	9.6 MiB
piwik_archive_numeric_2013_09	69,752	9 MiB
piwik_archive_numeric_2013_10	76,087	9.8 MiB
piwik_archive_numeric_2013_11	74,622	9.6 MiB
piwik_archive_numeric_2013_12	80,724	10.4 MiB

I do not need these old Data anymore and that would reduce my DB by only 2852MB, but at least a little bit old stuff that is totally unimportant today would be gone.

I can give, or have done that already, my SQL DB unlimited Space, but it grew now already to 10GB and … well… at least these 2852 MB are worthless.

Kind Regards


(Matthieu Aubry) #2

You can configure Piwik to delete old logs and/or old reports, see Managing your database’s size - Analytics Platform - Matomo


#3

This Picture is already long time no more loading… it tries to do so, but after like 10-15 minutes i always close the window ^^

Regulary delete old visitor logs from the database…
was already checked with “180 days” setting.

Regulary delete old reports from the database…
is now checked with standard settings.

Kind of Edit: While writing and collecting needed data for this Posting, the Pic actually loaded… only 1,8GB saving, but at least :wink:

Thanks