ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
previous usage: https://phabricator.wikimedia.org/T263703#6622726
Scenario 1: Keeping full history
Scenario 2: Keeping max 1 year of history
2
assumptions2 years (GB)3 years (GB)5 years (GB)wolfram link2 years3 years5 yearswolfram link
3
future running time 3 years
150 weeksraw tables4757311281raw tables231256281
https://www.wolframalpha.com/input/?i=integrate+y%3D5%2B0.005x+from+0+to+50
4
future running time 5 years
250 weeksmetrics5158211535

https://www.wolframalpha.com/input/?i=integrate+y%3D4.5%2B0.013x+from+0+to+250
metrics5158211535
5
backfill375375375back fill375375375
6
7
Denelezh metrics Calctotal136519273191total112114522191
8
201704032.0 GB
9
202004064.0 GB
10
after 5 years2.0 GB additional
11
~0.013 GB/week additional
12
13
Denelezh raw updating tables
14
human0.64
15
human_sitelink0.8
16
human_country0.27
17
human_occupation2.7
18
misc0.1
19
~ total per week4.5 GB
20
guessing addition0.005 GB/week
21
Maximum needed
5 years, full history
22
per week (x=weeks since launch)
cumulation after 3 years
after 5 years3.2TB
23
Equation for metrics
y=(4.5+0.013x)GB
Minimum neede
2 years, 1 year history
24
Equation for raw
y=(4.5+0.005x)GB
1.12TB
25
26
27
28
Backfill
29
From denelezh300
30
From from whgi75
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100