Truncate wikimedia and wikidata storage groups
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• GWicke
	Mar 23 2017, 8:22 PM

Description

The wikimedia storage group containing primarily commons data has been the source of some OOM trouble from frequently re-rendered, very large gallery pages. It also sees very little use from VisualEditor or apps.

Similarly, the wikidata storage group is full of frequently edited JSON blobs. Only a very small minority of pages are actually edited in VE. For this reason, we have already disabled pre-generation for the main namespace.

To clear storage for both groups & generally get an idea of the storage savings, I am thus proposing to truncate tables for the entire wikimedia and wikidata storage groups.

Related Objects

Mentioned Here: P5252 Proposed TRUNCATEs for RESTBase production
P5253 Snapshots, RESTBase production

Event Timeline

• GWicke created this task.Mar 23 2017, 8:22 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 23 2017, 8:22 PM

+1. Go for Monday, 2017-03-27 ?

Eevans triaged this task as Medium priority.Apr 11 2017, 3:25 PM

There isn't a specific storage group for wikidata; I assume that it is the default storage group that needs truncating.

See below for the proposed set of commands (please let me know if this does not look right):

P5252 Proposed TRUNCATEs for RESTBase production

1	TRUNCATE "local_group_wikimedia_T_parsoid_html".data;
2	TRUNCATE "local_group_wikimedia_T_parsoid_dataW4ULtxs1oMqJ".data;
3	TRUNCATE "local_group_wikimedia_T_parsoid_section_offsets".data;
4
5	TRUNCATE "local_group_default_T_parsoid_html".data;
6	TRUNCATE "local_group_default_T_parsoid_dataW4ULtxs1oMqJeY".data;
7	TRUNCATE "local_group_default_T_parsoid_section_offsets".data;

The truncation will result in the automatic creation of snapshots which will need to be cleared (after a suitable delay) prior to realizing any freed up space. In addition to these snapshots (6ea. per node), there are a few outstanding ones that I intend to clear as well:

P5253 Snapshots, RESTBase production

1	restbase1007.eqiad.wmnet: a: Snapshot Details:
2	restbase1007.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
3	restbase1007.eqiad.wmnet: a: 1460538932837-data local_group_globaldomain_T_mathoid_pngdata 5.74 MB 5.74 MB
4	restbase1007.eqiad.wmnet: a: 1474285386517-data local_group_wikipedia_T_feed_aggregateddata 3.59 MB 3.59 MB
5	restbase1007.eqiad.wmnet: a: 1464188466879-data local_group_globaldomain_T_mathoid_svgdata 341.19 MB 341.19 MB
6	restbase1007.eqiad.wmnet: a: 1485298391513-data local_group_wikipedia_T_feed_aggregateddata 2.25 MB 2.25 MB
7	restbase1007.eqiad.wmnet: a: 1473278896268-data local_group_wikipedia_T_feed_aggregateddata 834.04 KB 834.11 KB
8	restbase1007.eqiad.wmnet: a: 1455760438141-data local_group_globaldomain_T_mathoid_mmldata 67.85 MB 67.85 MB
9	restbase1007.eqiad.wmnet: a:
10	restbase1007.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 421.44 MB
11	restbase1007.eqiad.wmnet: b: Snapshot Details:
12	restbase1007.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
13	restbase1007.eqiad.wmnet: b: 1460538932836-data local_group_globaldomain_T_mathoid_pngdata 6.76 MB 6.76 MB
14	restbase1007.eqiad.wmnet: b: 1485298391347-data local_group_wikipedia_T_feed_aggregateddata 1.26 MB 1.26 MB
15	restbase1007.eqiad.wmnet: b: 1474285386567-data local_group_wikipedia_T_feed_aggregateddata 3.51 MB 3.51 MB
16	restbase1007.eqiad.wmnet: b: 1455760438057-data local_group_globaldomain_T_mathoid_mmldata 51.6 MB 51.6 MB
17	restbase1007.eqiad.wmnet: b: 1464188466661-data local_group_globaldomain_T_mathoid_svgdata 371.96 MB 371.96 MB
18	restbase1007.eqiad.wmnet: b: 1473278896105-data local_group_wikipedia_T_feed_aggregateddata 879.99 KB 880.06 KB
19	restbase1007.eqiad.wmnet: b:
20	restbase1007.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 435.94 MB
21	restbase1007.eqiad.wmnet: c: Snapshot Details:
22	restbase1007.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
23	restbase1007.eqiad.wmnet: c: 1485298391509-data local_group_wikipedia_T_feed_aggregateddata 633.21 KB 633.39 KB
24	restbase1007.eqiad.wmnet: c: 1474285386504-data local_group_wikipedia_T_feed_aggregateddata 3.83 MB 3.83 MB
25	restbase1007.eqiad.wmnet: c: 1473278896160-data local_group_wikipedia_T_feed_aggregateddata 1.02 MB 1.02 MB
26	restbase1007.eqiad.wmnet: c:
27	restbase1007.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 5.47 MB
28	restbase1010.eqiad.wmnet: a: Snapshot Details:
29	restbase1010.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
30	restbase1010.eqiad.wmnet: a: 1474285386605-data local_group_wikipedia_T_feed_aggregateddata 2.79 MB 2.79 MB
31	restbase1010.eqiad.wmnet: a: 1485298391818-data local_group_wikipedia_T_feed_aggregateddata 764.8 KB 765.02 KB
32	restbase1010.eqiad.wmnet: a: 1473278896222-data local_group_wikipedia_T_feed_aggregateddata 2.34 MB 2.34 MB
33	restbase1010.eqiad.wmnet: a: 1464188466661-data local_group_globaldomain_T_mathoid_svgdata 344.76 MB 344.76 MB
34	restbase1010.eqiad.wmnet: a: 1460538932838-data local_group_globaldomain_T_mathoid_pngdata 6.43 MB 6.43 MB
35	restbase1010.eqiad.wmnet: a:
36	restbase1010.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 357.06 MB
37	restbase1010.eqiad.wmnet: b: Snapshot Details:
38	restbase1010.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
39	restbase1010.eqiad.wmnet: b: 1474285386594-data local_group_wikipedia_T_feed_aggregateddata 4.39 MB 4.39 MB
40	restbase1010.eqiad.wmnet: b: 1464188467109-data local_group_globaldomain_T_mathoid_svgdata 306.07 MB 306.07 MB
41	restbase1010.eqiad.wmnet: b: 1460538932840-data local_group_globaldomain_T_mathoid_pngdata 5.51 MB 5.52 MB
42	restbase1010.eqiad.wmnet: b: 1473278896346-data local_group_wikipedia_T_feed_aggregateddata 1.77 MB 1.77 MB
43	restbase1010.eqiad.wmnet: b: 1485298391555-data local_group_wikipedia_T_feed_aggregateddata 1.33 MB 1.33 MB
44	restbase1010.eqiad.wmnet: b:
45	restbase1010.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 319.07 MB
46	restbase1010.eqiad.wmnet: c: Snapshot Details:
47	restbase1010.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
48	restbase1010.eqiad.wmnet: c: 1485298391570-data local_group_wikipedia_T_feed_aggregateddata 586.54 KB 586.73 KB
49	restbase1010.eqiad.wmnet: c: 1464188467109-data local_group_globaldomain_T_mathoid_svgdata 319.04 MB 319.04 MB
50	restbase1010.eqiad.wmnet: c: 1473278896340-data local_group_wikipedia_T_feed_aggregateddata 1.03 MB 1.03 MB
51	restbase1010.eqiad.wmnet: c: 1474285386640-data local_group_wikipedia_T_feed_aggregateddata 3.9 MB 3.9 MB
52	restbase1010.eqiad.wmnet: c:
53	restbase1010.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 324.54 MB
54	restbase1011.eqiad.wmnet: a: Snapshot Details:
55	restbase1011.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
56	restbase1011.eqiad.wmnet: a: 1464188466859-data local_group_globaldomain_T_mathoid_svgdata 367.12 MB 367.12 MB
57	restbase1011.eqiad.wmnet: a: 1473278896273-data local_group_wikipedia_T_feed_aggregateddata 1.06 MB 1.06 MB
58	restbase1011.eqiad.wmnet: a: 1474285386847-data local_group_wikipedia_T_feed_aggregateddata 4.63 MB 4.63 MB
59	restbase1011.eqiad.wmnet: a: 1485298391639-data local_group_wikipedia_T_feed_aggregateddata 615.76 KB 615.99 KB
60	restbase1011.eqiad.wmnet: a: 1460538932887-data local_group_globaldomain_T_mathoid_pngdata 6.16 MB 6.17 MB
61	restbase1011.eqiad.wmnet: a:
62	restbase1011.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 379.58 MB
63	restbase1011.eqiad.wmnet: b: Snapshot Details:
64	restbase1011.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
65	restbase1011.eqiad.wmnet: b: 1485298391512-data local_group_wikipedia_T_feed_aggregateddata 2.6 MB 2.6 MB
66	restbase1011.eqiad.wmnet: b: 1460538932886-data local_group_globaldomain_T_mathoid_pngdata 6.69 MB 6.69 MB
67	restbase1011.eqiad.wmnet: b: 1473278896556-data local_group_wikipedia_T_feed_aggregateddata 2.27 MB 2.27 MB
68	restbase1011.eqiad.wmnet: b: 1474285391738-data local_group_wikipedia_T_feed_aggregateddata 3.83 MB 3.83 MB
69	restbase1011.eqiad.wmnet: b: 1464188466916-data local_group_globaldomain_T_mathoid_svgdata 364.61 MB 364.61 MB
70	restbase1011.eqiad.wmnet: b:
71	restbase1011.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 380 MB
72	restbase1011.eqiad.wmnet: c: Snapshot Details:
73	restbase1011.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
74	restbase1011.eqiad.wmnet: c: 1485298391668-data local_group_wikipedia_T_feed_aggregateddata 469.91 KB 470.14 KB
75	restbase1011.eqiad.wmnet: c: 1473278896050-data local_group_wikipedia_T_feed_aggregateddata 1.85 MB 1.86 MB
76	restbase1011.eqiad.wmnet: c: 1474285386639-data local_group_wikipedia_T_feed_aggregateddata 4.18 MB 4.18 MB
77	restbase1011.eqiad.wmnet: c:
78	restbase1011.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 6.5 MB
79	restbase1016.eqiad.wmnet: a: Snapshot Details:
80	restbase1016.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
81	restbase1016.eqiad.wmnet: a: 1485298391378-data local_group_wikipedia_T_feed_aggregateddata 939.79 KB 940.05 KB
82	restbase1016.eqiad.wmnet: a:
83	restbase1016.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 939.79 KB
84	restbase1016.eqiad.wmnet: b: Snapshot Details:
85	restbase1016.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
86	restbase1016.eqiad.wmnet: b: 1485298391399-data local_group_wikipedia_T_feed_aggregateddata 717.68 KB 717.92 KB
87	restbase1016.eqiad.wmnet: b:
88	restbase1016.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 717.68 KB
89	restbase1016.eqiad.wmnet: c: Snapshot Details:
90	restbase1016.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
91	restbase1016.eqiad.wmnet: c: 1485298391374-data local_group_wikipedia_T_feed_aggregateddata 796.34 KB 796.53 KB
92	restbase1016.eqiad.wmnet: c:
93	restbase1016.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 796.34 KB
94	restbase1008.eqiad.wmnet: a: Snapshot Details:
95	restbase1008.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
96	restbase1008.eqiad.wmnet: a: 1485298391482-data local_group_wikipedia_T_feed_aggregateddata 454.38 KB 454.57 KB
97	restbase1008.eqiad.wmnet: a: 1464188466835-data local_group_globaldomain_T_mathoid_svgdata 350.82 MB 350.82 MB
98	restbase1008.eqiad.wmnet: a: 1474285386667-data local_group_wikipedia_T_feed_aggregateddata 3.35 MB 3.35 MB
99	restbase1008.eqiad.wmnet: a: 1460538932912-data local_group_globaldomain_T_mathoid_pngdata 6.04 MB 6.04 MB
100	restbase1008.eqiad.wmnet: a: 1473278896421-data local_group_wikipedia_T_feed_aggregateddata 926.02 KB 926.09 KB
101	restbase1008.eqiad.wmnet: a:
102	restbase1008.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 361.56 MB
103	restbase1008.eqiad.wmnet: b: Snapshot Details:
104	restbase1008.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
105	restbase1008.eqiad.wmnet: b: 1473278896474-data local_group_wikipedia_T_feed_aggregateddata 1.9 MB 1.9 MB
106	restbase1008.eqiad.wmnet: b: 1485298391626-data local_group_wikipedia_T_feed_aggregateddata 1.21 MB 1.21 MB
107	restbase1008.eqiad.wmnet: b: 1474285386479-data local_group_wikipedia_T_feed_aggregateddata 4.25 MB 4.25 MB
108	restbase1008.eqiad.wmnet: b: 1460538932906-data local_group_globaldomain_T_mathoid_pngdata 5.47 MB 5.48 MB
109	restbase1008.eqiad.wmnet: b: 1464188466832-data local_group_globaldomain_T_mathoid_svgdata 309.68 MB 309.68 MB
110	restbase1008.eqiad.wmnet: b:
111	restbase1008.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 322.5 MB
112	restbase1008.eqiad.wmnet: c: Snapshot Details:
113	restbase1008.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
114	restbase1008.eqiad.wmnet: c: 1485298391709-data local_group_wikipedia_T_feed_aggregateddata 577.73 KB 577.96 KB
115	restbase1008.eqiad.wmnet: c: 1474285386583-data local_group_wikipedia_T_feed_aggregateddata 2.2 MB 2.2 MB
116	restbase1008.eqiad.wmnet: c: 1473278896341-data local_group_wikipedia_T_feed_aggregateddata 828.75 KB 828.81 KB
117	restbase1008.eqiad.wmnet: c:
118	restbase1008.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 3.58 MB
119	restbase1012.eqiad.wmnet: a: Snapshot Details:
120	restbase1012.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
121	restbase1012.eqiad.wmnet: a: 1485298391879-data local_group_wikipedia_T_feed_aggregateddata 650.4 KB 650.63 KB
122	restbase1012.eqiad.wmnet: a: 1460538932841-data local_group_globaldomain_T_mathoid_pngdata 6.76 MB 6.76 MB
123	restbase1012.eqiad.wmnet: a: 1474285393464-data local_group_wikipedia_T_feed_aggregateddata 3.73 MB 3.73 MB
124	restbase1012.eqiad.wmnet: a: 1464188466995-data local_group_globaldomain_T_mathoid_svgdata 374.11 MB 374.11 MB
125	restbase1012.eqiad.wmnet: a: 1473278896126-data local_group_wikipedia_T_feed_aggregateddata 2.16 MB 2.17 MB
126	restbase1012.eqiad.wmnet: a:
127	restbase1012.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 387.4 MB
128	restbase1012.eqiad.wmnet: b: Snapshot Details:
129	restbase1012.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
130	restbase1012.eqiad.wmnet: b: 1485298391575-data local_group_wikipedia_T_feed_aggregateddata 813.62 KB 813.82 KB
131	restbase1012.eqiad.wmnet: b: 1464188466991-data local_group_globaldomain_T_mathoid_svgdata 351.51 MB 351.51 MB
132	restbase1012.eqiad.wmnet: b: 1460538932868-data local_group_globaldomain_T_mathoid_pngdata 6.37 MB 6.38 MB
133	restbase1012.eqiad.wmnet: b: 1474285387128-data local_group_wikipedia_T_feed_aggregateddata 5.33 MB 5.33 MB
134	restbase1012.eqiad.wmnet: b: 1473278896599-data local_group_wikipedia_T_feed_aggregateddata 2.22 MB 2.22 MB
135	restbase1012.eqiad.wmnet: b:
136	restbase1012.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 366.24 MB
137	restbase1012.eqiad.wmnet: c: Snapshot Details:
138	restbase1012.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
139	restbase1012.eqiad.wmnet: c: 1473278896224-data local_group_wikipedia_T_feed_aggregateddata 1 MB 1 MB
140	restbase1012.eqiad.wmnet: c: 1485298391881-data local_group_wikipedia_T_feed_aggregateddata 508.72 KB 508.95 KB
141	restbase1012.eqiad.wmnet: c: 1474285386767-data local_group_wikipedia_T_feed_aggregateddata 2.66 MB 2.66 MB
142	restbase1012.eqiad.wmnet: c:
143	restbase1012.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 4.16 MB
144	restbase1013.eqiad.wmnet: a: Snapshot Details:
145	restbase1013.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
146	restbase1013.eqiad.wmnet: a: 1464188466858-data local_group_globaldomain_T_mathoid_svgdata 342.8 MB 342.8 MB
147	restbase1013.eqiad.wmnet: a: 1485298391813-data local_group_wikipedia_T_feed_aggregateddata 1.51 MB 1.51 MB
148	restbase1013.eqiad.wmnet: a: 1474285386709-data local_group_wikipedia_T_feed_aggregateddata 1.57 MB 1.57 MB
149	restbase1013.eqiad.wmnet: a: 1473278896237-data local_group_wikipedia_T_feed_aggregateddata 1.18 MB 1.18 MB
150	restbase1013.eqiad.wmnet: a: 1460538932987-data local_group_globaldomain_T_mathoid_pngdata 6.35 MB 6.36 MB
151	restbase1013.eqiad.wmnet: a:
152	restbase1013.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 353.41 MB
153	restbase1013.eqiad.wmnet: b: Snapshot Details:
154	restbase1013.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
155	restbase1013.eqiad.wmnet: b: 1464188466850-data local_group_globaldomain_T_mathoid_svgdata 363.67 MB 363.67 MB
156	restbase1013.eqiad.wmnet: b: 1485298391494-data local_group_wikipedia_T_feed_aggregateddata 1.31 MB 1.31 MB
157	restbase1013.eqiad.wmnet: b: 1474285386650-data local_group_wikipedia_T_feed_aggregateddata 5.22 MB 5.22 MB
158	restbase1013.eqiad.wmnet: b: 1460538932870-data local_group_globaldomain_T_mathoid_pngdata 6.33 MB 6.33 MB
159	restbase1013.eqiad.wmnet: b: 1473278896562-data local_group_wikipedia_T_feed_aggregateddata 1.21 MB 1.21 MB
160	restbase1013.eqiad.wmnet: b:
161	restbase1013.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 377.73 MB
162	restbase1013.eqiad.wmnet: c: Snapshot Details:
163	restbase1013.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
164	restbase1013.eqiad.wmnet: c: 1473278896499-data local_group_wikipedia_T_feed_aggregateddata 947.32 KB 947.39 KB
165	restbase1013.eqiad.wmnet: c: 1474285386650-data local_group_wikipedia_T_feed_aggregateddata 3.61 MB 3.61 MB
166	restbase1013.eqiad.wmnet: c: 1485298391492-data local_group_wikipedia_T_feed_aggregateddata 1.29 MB 1.29 MB
167	restbase1013.eqiad.wmnet: c:
168	restbase1013.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 5.82 MB
169	restbase1017.eqiad.wmnet: a: Snapshot Details:
170	restbase1017.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
171	restbase1017.eqiad.wmnet: a: 1485298391384-data local_group_wikipedia_T_feed_aggregateddata 1.03 MB 1.03 MB
172	restbase1017.eqiad.wmnet: a:
173	restbase1017.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 1.03 MB
174	restbase1017.eqiad.wmnet: b: Snapshot Details:
175	restbase1017.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
176	restbase1017.eqiad.wmnet: b: 1485298391374-data local_group_wikipedia_T_feed_aggregateddata 892.79 KB 893.01 KB
177	restbase1017.eqiad.wmnet: b:
178	restbase1017.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 892.79 KB
179	restbase1017.eqiad.wmnet: c: Snapshot Details:
180	restbase1017.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
181	restbase1017.eqiad.wmnet: c: 1485298391390-data local_group_wikipedia_T_feed_aggregateddata 905.95 KB 906.21 KB
182	restbase1017.eqiad.wmnet: c:
183	restbase1017.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 905.95 KB
184	restbase1009.eqiad.wmnet: a: Snapshot Details:
185	restbase1009.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
186	restbase1009.eqiad.wmnet: a: 1485298391621-data local_group_wikipedia_T_feed_aggregateddata 1.82 MB 1.82 MB
187	restbase1009.eqiad.wmnet: a: 1473278896706-data local_group_wikipedia_T_feed_aggregateddata 771.48 KB 771.55 KB
188	restbase1009.eqiad.wmnet: a: 1474285386589-data local_group_wikipedia_T_feed_aggregateddata 2.88 MB 2.88 MB
189	restbase1009.eqiad.wmnet: a: 1464188466832-data local_group_globaldomain_T_mathoid_svgdata 309.76 MB 309.77 MB
190	restbase1009.eqiad.wmnet: a:
191	restbase1009.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 315.22 MB
192	restbase1009.eqiad.wmnet: b: Snapshot Details:
193	restbase1009.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
194	restbase1009.eqiad.wmnet: b: 1474285386974-data local_group_wikipedia_T_feed_aggregateddata 2 MB 2 MB
195	restbase1009.eqiad.wmnet: b: 1464188467141-data local_group_globaldomain_T_mathoid_svgdata 363.47 MB 363.47 MB
196	restbase1009.eqiad.wmnet: b: 1460538932863-data local_group_globaldomain_T_mathoid_pngdata 9.78 MB 9.78 MB
197	restbase1009.eqiad.wmnet: b: 1485298391526-data local_group_wikipedia_T_feed_aggregateddata 2.63 MB 2.63 MB
198	restbase1009.eqiad.wmnet: b: 1473278896321-data local_group_wikipedia_T_feed_aggregateddata 1.95 MB 1.95 MB
199	restbase1009.eqiad.wmnet: b:
200	restbase1009.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 379.82 MB
201	restbase1009.eqiad.wmnet: c: Snapshot Details:
202	restbase1009.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
203	restbase1009.eqiad.wmnet: c: 1474285386789-data local_group_wikipedia_T_feed_aggregateddata 2.51 MB 2.51 MB
204	restbase1009.eqiad.wmnet: c: 1473278896314-data local_group_wikipedia_T_feed_aggregateddata 656.78 KB 656.85 KB
205	restbase1009.eqiad.wmnet: c: 1485298391496-data local_group_wikipedia_T_feed_aggregateddata 1.13 MB 1.13 MB
206	restbase1009.eqiad.wmnet: c:
207	restbase1009.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 4.29 MB
208	restbase1014.eqiad.wmnet: a: Snapshot Details:
209	restbase1014.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
210	restbase1014.eqiad.wmnet: a: 1473278896187-data local_group_wikipedia_T_feed_aggregateddata 1.92 MB 1.92 MB
211	restbase1014.eqiad.wmnet: a: 1474285386674-data local_group_wikipedia_T_feed_aggregateddata 4.4 MB 4.4 MB
212	restbase1014.eqiad.wmnet: a: 1485298391837-data local_group_wikipedia_T_feed_aggregateddata 640.81 KB 641.04 KB
213	restbase1014.eqiad.wmnet: a: 1460538933024-data local_group_globaldomain_T_mathoid_pngdata 8.2 MB 8.2 MB
214	restbase1014.eqiad.wmnet: a: 1464188466849-data local_group_globaldomain_T_mathoid_svgdata 339.46 MB 339.46 MB
215	restbase1014.eqiad.wmnet: a:
216	restbase1014.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 354.6 MB
217	restbase1014.eqiad.wmnet: b: Snapshot Details:
218	restbase1014.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
219	restbase1014.eqiad.wmnet: b: 1460538933025-data local_group_globaldomain_T_mathoid_pngdata 7.01 MB 7.02 MB
220	restbase1014.eqiad.wmnet: b: 1464188466885-data local_group_globaldomain_T_mathoid_svgdata 384.21 MB 384.21 MB
221	restbase1014.eqiad.wmnet: b: 1474285386767-data local_group_wikipedia_T_feed_aggregateddata 1.93 MB 1.93 MB
222	restbase1014.eqiad.wmnet: b: 1473278896387-data local_group_wikipedia_T_feed_aggregateddata 1.27 MB 1.27 MB
223	restbase1014.eqiad.wmnet: b: 1485298391696-data local_group_wikipedia_T_feed_aggregateddata 1.25 MB 1.25 MB
224	restbase1014.eqiad.wmnet: b:
225	restbase1014.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 395.67 MB
226	restbase1014.eqiad.wmnet: c: Snapshot Details:
227	restbase1014.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
228	restbase1014.eqiad.wmnet: c: 1485298391837-data local_group_wikipedia_T_feed_aggregateddata 1.19 MB 1.19 MB
229	restbase1014.eqiad.wmnet: c: 1473278896282-data local_group_wikipedia_T_feed_aggregateddata 1.02 MB 1.02 MB
230	restbase1014.eqiad.wmnet: c: 1474285386771-data local_group_wikipedia_T_feed_aggregateddata 4.34 MB 4.34 MB
231	restbase1014.eqiad.wmnet: c:
232	restbase1014.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 6.55 MB
233	restbase1015.eqiad.wmnet: a: Snapshot Details:
234	restbase1015.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
235	restbase1015.eqiad.wmnet: a: 1474285386817-data local_group_wikipedia_T_feed_aggregateddata 4.48 MB 4.48 MB
236	restbase1015.eqiad.wmnet: a: 1473278896560-data local_group_wikipedia_T_feed_aggregateddata 961.09 KB 961.16 KB
237	restbase1015.eqiad.wmnet: a: 1464188466906-data local_group_globaldomain_T_mathoid_svgdata 336.64 MB 336.64 MB
238	restbase1015.eqiad.wmnet: a: 1485298391347-data local_group_wikipedia_T_feed_aggregateddata 594.4 KB 594.56 KB
239	restbase1015.eqiad.wmnet: a:
240	restbase1015.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 342.63 MB
241	restbase1015.eqiad.wmnet: b: Snapshot Details:
242	restbase1015.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
243	restbase1015.eqiad.wmnet: b: 1474285386694-data local_group_wikipedia_T_feed_aggregateddata 4.92 MB 4.92 MB
244	restbase1015.eqiad.wmnet: b: 1485298391528-data local_group_wikipedia_T_feed_aggregateddata 599.92 KB 600.13 KB
245	restbase1015.eqiad.wmnet: b: 1464188466907-data local_group_globaldomain_T_mathoid_svgdata 363.88 MB 363.88 MB
246	restbase1015.eqiad.wmnet: b: 1473278896922-data local_group_wikipedia_T_feed_aggregateddata 1.18 MB 1.18 MB
247	restbase1015.eqiad.wmnet: b:
248	restbase1015.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 370.56 MB
249	restbase1015.eqiad.wmnet: c: Snapshot Details:
250	restbase1015.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
251	restbase1015.eqiad.wmnet: c: 1485298391530-data local_group_wikipedia_T_feed_aggregateddata 444.44 KB 444.64 KB
252	restbase1015.eqiad.wmnet: c: 1474285386815-data local_group_wikipedia_T_feed_aggregateddata 4.78 MB 4.78 MB
253	restbase1015.eqiad.wmnet: c: 1473278896570-data local_group_wikipedia_T_feed_aggregateddata 1.21 MB 1.21 MB
254	restbase1015.eqiad.wmnet: c:
255	restbase1015.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 6.42 MB
256	restbase1018.eqiad.wmnet: a: Snapshot Details:
257	restbase1018.eqiad.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
258	restbase1018.eqiad.wmnet: a: 1485298391372-data local_group_wikipedia_T_feed_aggregateddata 980.17 KB 980.41 KB
259	restbase1018.eqiad.wmnet: a:
260	restbase1018.eqiad.wmnet: a: Total TrueDiskSpaceUsed: 980.17 KB
261	restbase1018.eqiad.wmnet: b: Snapshot Details:
262	restbase1018.eqiad.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
263	restbase1018.eqiad.wmnet: b: 1485298391391-data local_group_wikipedia_T_feed_aggregateddata 868.21 KB 868.45 KB
264	restbase1018.eqiad.wmnet: b:
265	restbase1018.eqiad.wmnet: b: Total TrueDiskSpaceUsed: 868.21 KB
266	restbase1018.eqiad.wmnet: c: Snapshot Details:
267	restbase1018.eqiad.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
268	restbase1018.eqiad.wmnet: c: 1485298391387-data local_group_wikipedia_T_feed_aggregateddata 803.21 KB 803.44 KB
269	restbase1018.eqiad.wmnet: c:
270	restbase1018.eqiad.wmnet: c: Total TrueDiskSpaceUsed: 803.21 KB
271	restbase2003.codfw.wmnet: a: Snapshot Details:
272	restbase2003.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
273	restbase2003.codfw.wmnet: a: 1453504931555-data local_group_wiktionary_T_term_definitiondata 28.09 MB 28.09 MB
274	restbase2003.codfw.wmnet: a: 1464188466931-data local_group_globaldomain_T_mathoid_svgdata 1007.07 MB 1007.07 MB
275	restbase2003.codfw.wmnet: a: 1474285386678-data local_group_wikipedia_T_feed_aggregateddata 1.54 MB 1.54 MB
276	restbase2003.codfw.wmnet: a: 1455760438075-data local_group_globaldomain_T_mathoid_mmldata 95.28 MB 95.28 MB
277	restbase2003.codfw.wmnet: a: 1473278896299-data local_group_wikipedia_T_feed_aggregateddata 844.81 KB 844.88 KB
278	restbase2003.codfw.wmnet: a: 1485298391618-data local_group_wikipedia_T_feed_aggregateddata 407.5 KB 407.7 KB
279	restbase2003.codfw.wmnet: a: 1460538935318-data local_group_globaldomain_T_mathoid_pngdata 17.98 MB 17.99 MB
280	restbase2003.codfw.wmnet: a:
281	restbase2003.codfw.wmnet: a: Total TrueDiskSpaceUsed: 1.12 GB
282	restbase2003.codfw.wmnet: b: Snapshot Details:
283	restbase2003.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
284	restbase2003.codfw.wmnet: b: 1474285386701-data local_group_wikipedia_T_feed_aggregateddata 1.8 MB 1.8 MB
285	restbase2003.codfw.wmnet: b: 1485298391619-data local_group_wikipedia_T_feed_aggregateddata 393.88 KB 394.04 KB
286	restbase2003.codfw.wmnet: b: 1473278896266-data local_group_wikipedia_T_feed_aggregateddata 1.64 MB 1.64 MB
287	restbase2003.codfw.wmnet: b:
288	restbase2003.codfw.wmnet: b: Total TrueDiskSpaceUsed: 3.82 MB
289	restbase2003.codfw.wmnet: c: Snapshot Details:
290	restbase2003.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
291	restbase2003.codfw.wmnet: c: 1485298391617-data local_group_wikipedia_T_feed_aggregateddata 401.99 KB 402.17 KB
292	restbase2003.codfw.wmnet: c: 1474285386786-data local_group_wikipedia_T_feed_aggregateddata 1.59 MB 1.59 MB
293	restbase2003.codfw.wmnet: c: 1473278896270-data local_group_wikipedia_T_feed_aggregateddata 1.94 MB 1.94 MB
294	restbase2003.codfw.wmnet: c:
295	restbase2003.codfw.wmnet: c: Total TrueDiskSpaceUsed: 3.92 MB
296	restbase2004.codfw.wmnet: a: Snapshot Details:
297	restbase2004.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
298	restbase2004.codfw.wmnet: a: 1460538932976-data local_group_globaldomain_T_mathoid_pngdata 17.46 MB 17.46 MB
299	restbase2004.codfw.wmnet: a: 1485298391369-data local_group_wikipedia_T_feed_aggregateddata 467.75 KB 467.98 KB
300	restbase2004.codfw.wmnet: a: 1474285386542-data local_group_wikipedia_T_feed_aggregateddata 1.62 MB 1.62 MB
301	restbase2004.codfw.wmnet: a: 1473278896563-data local_group_wikipedia_T_feed_aggregateddata 839.48 KB 839.55 KB
302	restbase2004.codfw.wmnet: a: 1464188466849-data local_group_globaldomain_T_mathoid_svgdata 1.03 GB 1.03 GB
303	restbase2004.codfw.wmnet: a:
304	restbase2004.codfw.wmnet: a: Total TrueDiskSpaceUsed: 1.05 GB
305	restbase2004.codfw.wmnet: b: Snapshot Details:
306	restbase2004.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
307	restbase2004.codfw.wmnet: b: 1485298391665-data local_group_wikipedia_T_feed_aggregateddata 370.78 KB 370.96 KB
308	restbase2004.codfw.wmnet: b: 1473278896569-data local_group_wikipedia_T_feed_aggregateddata 2.45 MB 2.45 MB
309	restbase2004.codfw.wmnet: b: 1474285386880-data local_group_wikipedia_T_feed_aggregateddata 2.38 MB 2.38 MB
310	restbase2004.codfw.wmnet: b:
311	restbase2004.codfw.wmnet: b: Total TrueDiskSpaceUsed: 5.18 MB
312	restbase2004.codfw.wmnet: c: Snapshot Details:
313	restbase2004.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
314	restbase2004.codfw.wmnet: c: 1473278898911-data local_group_wikipedia_T_feed_aggregateddata 1.23 MB 1.23 MB
315	restbase2004.codfw.wmnet: c: 1485298391366-data local_group_wikipedia_T_feed_aggregateddata 414.74 KB 414.94 KB
316	restbase2004.codfw.wmnet: c: pre-scrub-1473259586201local_group_globaldomain_T_mathoid_pngdata 1.43 GB 1.43 GB
317	restbase2004.codfw.wmnet: c: 1474285386543-data local_group_wikipedia_T_feed_aggregateddata 2.04 MB 2.04 MB
318	restbase2004.codfw.wmnet: c:
319	restbase2004.codfw.wmnet: c: Total TrueDiskSpaceUsed: 1.43 GB
320	restbase2008.codfw.wmnet: a: Snapshot Details:
321	restbase2008.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
322	restbase2008.codfw.wmnet: a: 1473278896992-data local_group_wikipedia_T_feed_aggregateddata 1.52 MB 1.52 MB
323	restbase2008.codfw.wmnet: a: 1474285386797-data local_group_wikipedia_T_feed_aggregateddata 1.99 MB 1.99 MB
324	restbase2008.codfw.wmnet: a: 1485298391734-data local_group_wikipedia_T_feed_aggregateddata 770.65 KB 770.89 KB
325	restbase2008.codfw.wmnet: a: 1464188467093-data local_group_globaldomain_T_mathoid_svgdata 493.07 MB 493.07 MB
326	restbase2008.codfw.wmnet: a:
327	restbase2008.codfw.wmnet: a: Total TrueDiskSpaceUsed: 497.33 MB
328	restbase2008.codfw.wmnet: b: Snapshot Details:
329	restbase2008.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
330	restbase2008.codfw.wmnet: b: 1474285386865-data local_group_wikipedia_T_feed_aggregateddata 2.08 MB 2.08 MB
331	restbase2008.codfw.wmnet: b: 1485298391898-data local_group_wikipedia_T_feed_aggregateddata 392.7 KB 392.91 KB
332	restbase2008.codfw.wmnet: b: 1473278896463-data local_group_wikipedia_T_feed_aggregateddata 1.22 MB 1.22 MB
333	restbase2008.codfw.wmnet: b: 1464188467093-data local_group_globaldomain_T_mathoid_svgdata 535.89 MB 535.89 MB
334	restbase2008.codfw.wmnet: b:
335	restbase2008.codfw.wmnet: b: Total TrueDiskSpaceUsed: 539.57 MB
336	restbase2008.codfw.wmnet: c: Snapshot Details:
337	restbase2008.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
338	restbase2008.codfw.wmnet: c: 1485298391732-data local_group_wikipedia_T_feed_aggregateddata 358.58 KB 358.76 KB
339	restbase2008.codfw.wmnet: c: 1473278896465-data local_group_wikipedia_T_feed_aggregateddata 1.01 MB 1.01 MB
340	restbase2008.codfw.wmnet: c: 1474285386766-data local_group_wikipedia_T_feed_aggregateddata 2.47 MB 2.47 MB
341	restbase2008.codfw.wmnet: c:
342	restbase2008.codfw.wmnet: c: Total TrueDiskSpaceUsed: 3.83 MB
343	restbase2011.codfw.wmnet: a: Snapshot Details:
344	restbase2011.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
345	restbase2011.codfw.wmnet: a: 1485298391388-data local_group_wikipedia_T_feed_aggregateddata 446.69 KB 446.87 KB
346	restbase2011.codfw.wmnet: a:
347	restbase2011.codfw.wmnet: a: Total TrueDiskSpaceUsed: 446.69 KB
348	restbase2011.codfw.wmnet: b: Snapshot Details:
349	restbase2011.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
350	restbase2011.codfw.wmnet: b: 1485298391387-data local_group_wikipedia_T_feed_aggregateddata 369.65 KB 369.83 KB
351	restbase2011.codfw.wmnet: b:
352	restbase2011.codfw.wmnet: b: Total TrueDiskSpaceUsed: 369.65 KB
353	restbase2011.codfw.wmnet: c: Snapshot Details:
354	restbase2011.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
355	restbase2011.codfw.wmnet: c: 1485298391416-data local_group_wikipedia_T_feed_aggregateddata 403.51 KB 403.72 KB
356	restbase2011.codfw.wmnet: c:
357	restbase2011.codfw.wmnet: c: Total TrueDiskSpaceUsed: 403.51 KB
358	restbase2001.codfw.wmnet: a: Snapshot Details:
359	restbase2001.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
360	restbase2001.codfw.wmnet: a: 1485298391937-data local_group_wikipedia_T_feed_aggregateddata 364.01 KB 364.22 KB
361	restbase2001.codfw.wmnet: a:
362	restbase2001.codfw.wmnet: a: Total TrueDiskSpaceUsed: 364.01 KB
363	restbase2001.codfw.wmnet: b: Snapshot Details:
364	restbase2001.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
365	restbase2001.codfw.wmnet: b: 1453504926487-data local_group_wiktionary_T_term_definitiondata 10.04 MB 10.04 MB
366	restbase2001.codfw.wmnet: b: 1455760438088-data local_group_globaldomain_T_mathoid_mmldata 34.17 MB 34.17 MB
367	restbase2001.codfw.wmnet: b: 1460538933106-data local_group_globaldomain_T_mathoid_pngdata 6.22 MB 6.22 MB
368	restbase2001.codfw.wmnet: b: 1473278896407-data local_group_wikipedia_T_feed_aggregateddata 1.07 MB 1.07 MB
369	restbase2001.codfw.wmnet: b: 1464188467756-data local_group_globaldomain_T_mathoid_svgdata 362.12 MB 362.12 MB
370	restbase2001.codfw.wmnet: b: 1474285387054-data local_group_wikipedia_T_feed_aggregateddata 2.31 MB 2.31 MB
371	restbase2001.codfw.wmnet: b: 1485298391532-data local_group_wikipedia_T_feed_aggregateddata 396.6 KB 396.78 KB
372	restbase2001.codfw.wmnet: b:
373	restbase2001.codfw.wmnet: b: Total TrueDiskSpaceUsed: 416.32 MB
374	restbase2001.codfw.wmnet: c: Snapshot Details:
375	restbase2001.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
376	restbase2001.codfw.wmnet: c: 1473278896402-data local_group_wikipedia_T_feed_aggregateddata 1.11 MB 1.11 MB
377	restbase2001.codfw.wmnet: c: 1453504926499-data local_group_wiktionary_T_term_definitiondata 10.1 MB 10.1 MB
378	restbase2001.codfw.wmnet: c: 1455760438116-data local_group_globaldomain_T_mathoid_mmldata 34.24 MB 34.24 MB
379	restbase2001.codfw.wmnet: c: 1485298391750-data local_group_wikipedia_T_feed_aggregateddata 481.07 KB 481.29 KB
380	restbase2001.codfw.wmnet: c: 1464188467101-data local_group_globaldomain_T_mathoid_svgdata 363.99 MB 363.99 MB
381	restbase2001.codfw.wmnet: c: 1460538935625-data local_group_globaldomain_T_mathoid_pngdata 6.72 MB 6.72 MB
382	restbase2001.codfw.wmnet: c: 1474285387158-data local_group_wikipedia_T_feed_aggregateddata 2 MB 2 MB
383	restbase2001.codfw.wmnet: c:
384	restbase2001.codfw.wmnet: c: Total TrueDiskSpaceUsed: 418.62 MB
385	restbase2002.codfw.wmnet: a: Snapshot Details:
386	restbase2002.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
387	restbase2002.codfw.wmnet: a: 1460538933031-data local_group_globaldomain_T_mathoid_pngdata 5.46 MB 5.47 MB
388	restbase2002.codfw.wmnet: a: 1455760438156-data local_group_globaldomain_T_mathoid_mmldata 27.63 MB 27.63 MB
389	restbase2002.codfw.wmnet: a: 1464188467642-data local_group_globaldomain_T_mathoid_svgdata 294.1 MB 294.1 MB
390	restbase2002.codfw.wmnet: a: 1473278896406-data local_group_wikipedia_T_feed_aggregateddata 1.82 MB 1.82 MB
391	restbase2002.codfw.wmnet: a: 1474285387271-data local_group_wikipedia_T_feed_aggregateddata 2.12 MB 2.12 MB
392	restbase2002.codfw.wmnet: a: 1485298391747-data local_group_wikipedia_T_feed_aggregateddata 383.25 KB 383.41 KB
393	restbase2002.codfw.wmnet: a: 1453504926521-data local_group_wiktionary_T_term_definitiondata 8.25 MB 8.25 MB
394	restbase2002.codfw.wmnet: a:
395	restbase2002.codfw.wmnet: a: Total TrueDiskSpaceUsed: 339.76 MB
396	restbase2002.codfw.wmnet: b: Snapshot Details:
397	restbase2002.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
398	restbase2002.codfw.wmnet: b: 1473278896510-data local_group_wikipedia_T_feed_aggregateddata 1.2 MB 1.2 MB
399	restbase2002.codfw.wmnet: b: 1455760438136-data local_group_globaldomain_T_mathoid_mmldata 36.17 MB 36.17 MB
400	restbase2002.codfw.wmnet: b: 1474285390268-data local_group_wikipedia_T_feed_aggregateddata 2.44 MB 2.44 MB
401	restbase2002.codfw.wmnet: b: 1453504926631-data local_group_wiktionary_T_term_definitiondata 10.64 MB 10.64 MB
402	restbase2002.codfw.wmnet: b: 1460538933039-data local_group_globaldomain_T_mathoid_pngdata 6.86 MB 6.86 MB
403	restbase2002.codfw.wmnet: b: 1464188466935-data local_group_globaldomain_T_mathoid_svgdata 382.74 MB 382.74 MB
404	restbase2002.codfw.wmnet: b: 1485298391748-data local_group_wikipedia_T_feed_aggregateddata 376.53 KB 376.73 KB
405	restbase2002.codfw.wmnet: b:
406	restbase2002.codfw.wmnet: b: Total TrueDiskSpaceUsed: 440.41 MB
407	restbase2002.codfw.wmnet: c: Snapshot Details:
408	restbase2002.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
409	restbase2002.codfw.wmnet: c: 1464188466679-data local_group_globaldomain_T_mathoid_svgdata 332.89 MB 332.89 MB
410	restbase2002.codfw.wmnet: c: 1453504926663-data local_group_wiktionary_T_term_definitiondata 9.44 MB 9.44 MB
411	restbase2002.codfw.wmnet: c: 1460538933040-data local_group_globaldomain_T_mathoid_pngdata 5.97 MB 5.98 MB
412	restbase2002.codfw.wmnet: c: 1455760438143-data local_group_globaldomain_T_mathoid_mmldata 31.35 MB 31.35 MB
413	restbase2002.codfw.wmnet: c: 1473278896489-data local_group_wikipedia_T_feed_aggregateddata 833.14 KB 833.2 KB
414	restbase2002.codfw.wmnet: c: 1474285387129-data local_group_wikipedia_T_feed_aggregateddata 2.03 MB 2.03 MB
415	restbase2002.codfw.wmnet: c: 1485298392208-data local_group_wikipedia_T_feed_aggregateddata 451.49 KB 451.7 KB
416	restbase2002.codfw.wmnet: c:
417	restbase2002.codfw.wmnet: c: Total TrueDiskSpaceUsed: 382.94 MB
418	restbase2007.codfw.wmnet: a: Snapshot Details:
419	restbase2007.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
420	restbase2007.codfw.wmnet: a: 1464188466679-data local_group_globaldomain_T_mathoid_svgdata 258.64 MB 258.64 MB
421	restbase2007.codfw.wmnet: a: 1473278896245-data local_group_wikipedia_T_feed_aggregateddata 771.29 KB 771.36 KB
422	restbase2007.codfw.wmnet: a: 1474285386789-data local_group_wikipedia_T_feed_aggregateddata 2.05 MB 2.05 MB
423	restbase2007.codfw.wmnet: a: 1485298391669-data local_group_wikipedia_T_feed_aggregateddata 709.93 KB 710.13 KB
424	restbase2007.codfw.wmnet: a:
425	restbase2007.codfw.wmnet: a: Total TrueDiskSpaceUsed: 262.13 MB
426	restbase2007.codfw.wmnet: b: Snapshot Details:
427	restbase2007.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
428	restbase2007.codfw.wmnet: b: 1464188466679-data local_group_globaldomain_T_mathoid_svgdata 259.26 MB 259.26 MB
429	restbase2007.codfw.wmnet: b: 1474285386873-data local_group_wikipedia_T_feed_aggregateddata 1.67 MB 1.67 MB
430	restbase2007.codfw.wmnet: b: 1473278896278-data local_group_wikipedia_T_feed_aggregateddata 2.11 MB 2.11 MB
431	restbase2007.codfw.wmnet: b: 1485298391684-data local_group_wikipedia_T_feed_aggregateddata 391.61 KB 391.79 KB
432	restbase2007.codfw.wmnet: b:
433	restbase2007.codfw.wmnet: b: Total TrueDiskSpaceUsed: 263.43 MB
434	restbase2007.codfw.wmnet: c: Snapshot Details:
435	restbase2007.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
436	restbase2007.codfw.wmnet: c: 1474285386705-data local_group_wikipedia_T_feed_aggregateddata 1.44 MB 1.44 MB
437	restbase2007.codfw.wmnet: c: 1473278896292-data local_group_wikipedia_T_feed_aggregateddata 2.09 MB 2.09 MB
438	restbase2007.codfw.wmnet: c: 1485298391975-data local_group_wikipedia_T_feed_aggregateddata 444.34 KB 444.55 KB
439	restbase2007.codfw.wmnet: c:
440	restbase2007.codfw.wmnet: c: Total TrueDiskSpaceUsed: 3.97 MB
441	restbase2010.codfw.wmnet: a: Snapshot Details:
442	restbase2010.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
443	restbase2010.codfw.wmnet: a: 1485298391390-data local_group_wikipedia_T_feed_aggregateddata 376.42 KB 376.62 KB
444	restbase2010.codfw.wmnet: a:
445	restbase2010.codfw.wmnet: a: Total TrueDiskSpaceUsed: 376.42 KB
446	restbase2010.codfw.wmnet: b: Snapshot Details:
447	restbase2010.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
448	restbase2010.codfw.wmnet: b: 1485298391406-data local_group_wikipedia_T_feed_aggregateddata 429.21 KB 429.41 KB
449	restbase2010.codfw.wmnet: b:
450	restbase2010.codfw.wmnet: b: Total TrueDiskSpaceUsed: 429.21 KB
451	restbase2010.codfw.wmnet: c: Snapshot Details:
452	restbase2010.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
453	restbase2010.codfw.wmnet: c: 1485298391402-data local_group_wikipedia_T_feed_aggregateddata 444.65 KB 444.85 KB
454	restbase2010.codfw.wmnet: c:
455	restbase2010.codfw.wmnet: c: Total TrueDiskSpaceUsed: 444.65 KB
456	restbase2005.codfw.wmnet: a: Snapshot Details:
457	restbase2005.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
458	restbase2005.codfw.wmnet: a: 1460538932904-data local_group_globaldomain_T_mathoid_pngdata 18.75 MB 18.75 MB
459	restbase2005.codfw.wmnet: a: 1464188469509-data local_group_globaldomain_T_mathoid_svgdata 562.12 MB 562.12 MB
460	restbase2005.codfw.wmnet: a: 1455760438053-data local_group_globaldomain_T_mathoid_mmldata 98.72 MB 98.72 MB
461	restbase2005.codfw.wmnet: a: 1474285386821-data local_group_wikipedia_T_feed_aggregateddata 1.77 MB 1.77 MB
462	restbase2005.codfw.wmnet: a: 1473278896500-data local_group_wikipedia_T_feed_aggregateddata 1.09 MB 1.09 MB
463	restbase2005.codfw.wmnet: a: 1485298391931-data local_group_wikipedia_T_feed_aggregateddata 463.01 KB 463.26 KB
464	restbase2005.codfw.wmnet: a: 1453504926458-data local_group_wiktionary_T_term_definitiondata 29.27 MB 29.27 MB
465	restbase2005.codfw.wmnet: a:
466	restbase2005.codfw.wmnet: a: Total TrueDiskSpaceUsed: 712.16 MB
467	restbase2005.codfw.wmnet: b: Snapshot Details:
468	restbase2005.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
469	restbase2005.codfw.wmnet: b: 1485298391901-data local_group_wikipedia_T_feed_aggregateddata 417.75 KB 417.96 KB
470	restbase2005.codfw.wmnet: b: 1474285386827-data local_group_wikipedia_T_feed_aggregateddata 1.55 MB 1.55 MB
471	restbase2005.codfw.wmnet: b: 1473278896316-data local_group_wikipedia_T_feed_aggregateddata 1.02 MB 1.02 MB
472	restbase2005.codfw.wmnet: b:
473	restbase2005.codfw.wmnet: b: Total TrueDiskSpaceUsed: 2.98 MB
474	restbase2005.codfw.wmnet: c: Snapshot Details:
475	restbase2005.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
476	restbase2005.codfw.wmnet: c: 1474285386825-data local_group_wikipedia_T_feed_aggregateddata 1.54 MB 1.54 MB
477	restbase2005.codfw.wmnet: c: 1473278896201-data local_group_wikipedia_T_feed_aggregateddata 1.78 MB 1.78 MB
478	restbase2005.codfw.wmnet: c: 1485298391651-data local_group_wikipedia_T_feed_aggregateddata 447.56 KB 447.77 KB
479	restbase2005.codfw.wmnet: c:
480	restbase2005.codfw.wmnet: c: Total TrueDiskSpaceUsed: 3.76 MB
481	restbase2006.codfw.wmnet: a: Snapshot Details:
482	restbase2006.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
483	restbase2006.codfw.wmnet: a: 1473278896398-data local_group_wikipedia_T_feed_aggregateddata 949.62 KB 949.68 KB
484	restbase2006.codfw.wmnet: a: 1464188466942-data local_group_globaldomain_T_mathoid_svgdata 529.15 MB 529.15 MB
485	restbase2006.codfw.wmnet: a: 1455760438069-data local_group_globaldomain_T_mathoid_mmldata 96.28 MB 96.28 MB
486	restbase2006.codfw.wmnet: a: 1474285386682-data local_group_wikipedia_T_feed_aggregateddata 1.95 MB 1.95 MB
487	restbase2006.codfw.wmnet: a: 1453504926468-data local_group_wiktionary_T_term_definitiondata 28.23 MB 28.23 MB
488	restbase2006.codfw.wmnet: a: 1460538932966-data local_group_globaldomain_T_mathoid_pngdata 17.69 MB 17.69 MB
489	restbase2006.codfw.wmnet: a: 1485298391651-data local_group_wikipedia_T_feed_aggregateddata 336.29 KB 336.48 KB
490	restbase2006.codfw.wmnet: a:
491	restbase2006.codfw.wmnet: a: Total TrueDiskSpaceUsed: 674.55 MB
492	restbase2006.codfw.wmnet: b: Snapshot Details:
493	restbase2006.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
494	restbase2006.codfw.wmnet: b: 1485298391762-data local_group_wikipedia_T_feed_aggregateddata 363.38 KB 363.54 KB
495	restbase2006.codfw.wmnet: b: 1473278896530-data local_group_wikipedia_T_feed_aggregateddata 943.33 KB 943.39 KB
496	restbase2006.codfw.wmnet: b: 1474285386671-data local_group_wikipedia_T_feed_aggregateddata 2.5 MB 2.5 MB
497	restbase2006.codfw.wmnet: b:
498	restbase2006.codfw.wmnet: b: Total TrueDiskSpaceUsed: 3.77 MB
499	restbase2006.codfw.wmnet: c: Snapshot Details:
500	restbase2006.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
501	restbase2006.codfw.wmnet: c: 1473278896634-data local_group_wikipedia_T_feed_aggregateddata 1.27 MB 1.27 MB
502	restbase2006.codfw.wmnet: c: 1485298391601-data local_group_wikipedia_T_feed_aggregateddata 725.61 KB 725.84 KB
503	restbase2006.codfw.wmnet: c: 1474285386840-data local_group_wikipedia_T_feed_aggregateddata 2.42 MB 2.42 MB
504	restbase2006.codfw.wmnet: c:
505	restbase2006.codfw.wmnet: c: Total TrueDiskSpaceUsed: 4.39 MB
506	restbase2009.codfw.wmnet: a: Snapshot Details:
507	restbase2009.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
508	restbase2009.codfw.wmnet: a: 1473278895932-data local_group_wikipedia_T_feed_aggregateddata 2.01 MB 2.01 MB
509	restbase2009.codfw.wmnet: a: 1474285386360-data local_group_wikipedia_T_feed_aggregateddata 1.82 MB 1.82 MB
510	restbase2009.codfw.wmnet: a: 1464188466715-data local_group_globaldomain_T_mathoid_svgdata 636.21 MB 636.21 MB
511	restbase2009.codfw.wmnet: a: 1485298392150-data local_group_wikipedia_T_feed_aggregateddata 359.35 KB 359.51 KB
512	restbase2009.codfw.wmnet: a:
513	restbase2009.codfw.wmnet: a: Total TrueDiskSpaceUsed: 640.39 MB
514	restbase2009.codfw.wmnet: b: Snapshot Details:
515	restbase2009.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
516	restbase2009.codfw.wmnet: b: 1485298391399-data local_group_wikipedia_T_feed_aggregateddata 308.75 KB 308.89 KB
517	restbase2009.codfw.wmnet: b: 1474285386271-data local_group_wikipedia_T_feed_aggregateddata 2.38 MB 2.38 MB
518	restbase2009.codfw.wmnet: b: 1473278895874-data local_group_wikipedia_T_feed_aggregateddata 1.87 MB 1.87 MB
519	restbase2009.codfw.wmnet: b: 1464188466699-data local_group_globaldomain_T_mathoid_svgdata 517.35 MB 517.35 MB
520	restbase2009.codfw.wmnet: b:
521	restbase2009.codfw.wmnet: b: Total TrueDiskSpaceUsed: 521.9 MB
522	restbase2009.codfw.wmnet: c: Snapshot Details:
523	restbase2009.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
524	restbase2009.codfw.wmnet: c: 1485298391421-data local_group_wikipedia_T_feed_aggregateddata 380.74 KB 380.92 KB
525	restbase2009.codfw.wmnet: c: 1473278895961-data local_group_wikipedia_T_feed_aggregateddata 1.11 MB 1.11 MB
526	restbase2009.codfw.wmnet: c: 1474285386329-data local_group_wikipedia_T_feed_aggregateddata 2.79 MB 2.79 MB
527	restbase2009.codfw.wmnet: c:
528	restbase2009.codfw.wmnet: c: Total TrueDiskSpaceUsed: 4.27 MB
529	restbase2012.codfw.wmnet: a: Snapshot Details:
530	restbase2012.codfw.wmnet: a: Snapshot name Keyspace name Column family name True size Size on disk
531	restbase2012.codfw.wmnet: a: 1485298391378-data local_group_wikipedia_T_feed_aggregateddata 304.71 KB 304.89 KB
532	restbase2012.codfw.wmnet: a:
533	restbase2012.codfw.wmnet: a: Total TrueDiskSpaceUsed: 304.71 KB
534	restbase2012.codfw.wmnet: b: Snapshot Details:
535	restbase2012.codfw.wmnet: b: Snapshot name Keyspace name Column family name True size Size on disk
536	restbase2012.codfw.wmnet: b: 1485298391510-data local_group_wikipedia_T_feed_aggregateddata 297.07 KB 297.28 KB
537	restbase2012.codfw.wmnet: b:
538	restbase2012.codfw.wmnet: b: Total TrueDiskSpaceUsed: 297.07 KB
539	restbase2012.codfw.wmnet: c: Snapshot Details:
540	restbase2012.codfw.wmnet: c: Snapshot name Keyspace name Column family name True size Size on disk
541	restbase2012.codfw.wmnet: c: 1485298391387-data local_group_wikipedia_T_feed_aggregateddata 466.74 KB 466.93 KB
542	restbase2012.codfw.wmnet: c:
543	restbase2012.codfw.wmnet: c: Total TrueDiskSpaceUsed: 466.74 KB

Here's the list of wikis that will be affected by the truncate:

# wikimedia
/{domain:ar.wikimedia.org}: *default_project
/{domain:bd.wikimedia.org}: *default_project
/{domain:be.wikimedia.org}: *default_project
/{domain:br.wikimedia.org}: *default_project
/{domain:ca.wikimedia.org}: *default_project
/{domain:cn.wikimedia.org}: *default_project
/{domain:co.wikimedia.org}: *default_project
/{domain:commons.wikimedia.org}: *default_project
/{domain:dk.wikimedia.org}: *default_project
/{domain:donate.wikimedia.org}: *default_project
/{domain:ee.wikimedia.org}: *default_project
/{domain:et.wikimedia.org}: *default_project
/{domain:fi.wikimedia.org}: *default_project
/{domain:incubator.wikimedia.org}: *default_project
/{domain:wikitech.wikimedia.org}: *default_project
/{domain:login.wikimedia.org}: *default_project
/{domain:meta.wikimedia.org}: *default_project
/{domain:mk.wikimedia.org}: *default_project
/{domain:mx.wikimedia.org}: *default_project
/{domain:nl.wikimedia.org}: *default_project
/{domain:no.wikimedia.org}: *default_project
/{domain:nyc.wikimedia.org}: *default_project
/{domain:outreach.wikimedia.org}: *default_project
/{domain:pl.wikimedia.org}: *default_project
/{domain:pt.wikimedia.org}: *default_project
/{domain:rs.wikimedia.org}: *default_project
/{domain:ru.wikimedia.org}: *default_project
/{domain:se.wikimedia.org}: *default_project
/{domain:species.wikimedia.org}: *default_project
/{domain:tr.wikimedia.org}: *default_project
/{domain:ua.wikimedia.org}: *default_project
/{domain:vote.wikimedia.org}: *default_project
/{domain:wikimania2014.wikimedia.org}: *default_project
/{domain:wikimania2015.wikimedia.org}: *default_project
/{domain:wikimania2016.wikimedia.org}: *default_project
/{domain:wikimania2017.wikimedia.org}: *default_project
/{domain:wikimania2018.wikimedia.org}: *default_project

# specials
/{domain:wikimediafoundation.org}: *default_project
/{domain:www.mediawiki.org}: *default_project
/{domain:wikisource.org}: *default_project
/{domain:beta.wikiversity.org}: *default_project
/{domain:www.wikidata.org}: *wikidata.org
/{domain:test.wikidata.org}: *wikidata.org

I'll go through them and check that non of them have extensive use of VisualEditor.

This looks correct to me. It seems that we forgot to clear the snapshots when we last cleared out the feed and math content.

In T161243#3175442, @Pchelolo wrote:

Here's the list of wikis that will be affected by the truncate:

[ ... ]

I'll go through them and check that none of them have extensive use of VisualEditor.

@Pchelolo I don't know if you had in mind some programmatic means of looking at these, but I sampled a number of these at random and found them to have less VE usage than commons (or none at all).

@Pchelolo I don't know if you had in mind some programmatic means of looking at these, but I sampled a number of these at random and found them to have less VE usage than commons (or none at all).

Oh, no smarter way that looking into them manually. I've done that yesterday and forgot to comment on the task. I think we're good to go here

In T161243#3178808, @Pchelolo wrote:

@Pchelolo I don't know if you had in mind some programmatic means of looking at these, but I sampled a number of these at random and found them to have less VE usage than commons (or none at all).

Oh, no smarter way that looking into them manually. I've done that yesterday and forgot to comment on the task. I think we're good to go here

OK, I'll plan to proceed with this a little later today (say, no later than 2017-04-13T18:30+00:00).

Mentioned in SAL (#wikimedia-operations) [2017-04-13T18:16:50Z] <urandom> T161243: Truncating parsoid tables (default storage group)

Mentioned in SAL (#wikimedia-operations) [2017-04-13T18:29:59Z] <urandom> T161243: Truncating parsoid tables (wikimedia storage group)

Tables for both storage groups have been truncated. I will wait an hour or so before clearing the snapshots (just in case).

Mentioned in SAL (#wikimedia-operations) [2017-04-13T20:07:58Z] <urandom> T161243: Clearing all snapshots

Eevans closed this task as Resolved.Apr 13 2017, 8:57 PM

Truncate wikimedia and wikidata storage groupsClosed, ResolvedPublicActions

Description

Related Objects

Event Timeline

Truncate wikimedia and wikidata storage groups
Closed, ResolvedPublic
Actions