Obsolete:Index sizes

Note: This page was created as a temporary pastebin and probably doesn't make any sense without its proper context

By table

Index sizes for tables in enwiki, 2006-12-24

Table name                    Index size (MB)
hitcounter                    0
james_revision_usercounts     0
jamesrcusers                  0
linkscc                       0
long_run_profiling            0
math                          0
namespaces                    0
old_growth                    0
povwatch_subscribers          0
profiling                     0
querycache_info               0
site_stats                    0
text                          0
user_rights                   0
archive_old                   0
brokenlinks                   0
dammit_test                   0
links                         0
searchindex                   0
trackbacks                    0
transcache                    0
exlogging                     0
interwiki                     0
arbcom1_vote                  0
exarchive                     0
povwatch_log                  0
validate                      0
hashs                         0
querycachetwo                 0
vote_log                      0
user_groups                   0
exrevision                    0
hidden                        0
job                           2
oldimage_old                  2
querycache_old                2
querycache                    3
ipblocks_old                  3
oldimage                      5
redirect                      9
user_old                      11
ipblocks                      19
imagelinks_old                20
objectcache                   20
user_newtalk                  27
image_old                     28
logging_old                   49
filearchive                   59
watchlist_old                 64
image                         81
page_broken                   84
langlinks                     94
spoofuser                     174
imagelinks                    214
user                          217
categorylinks_old             229
recentchanges_old             382
templatelinks                 429
archive                       608
updates                       792
page                          809
cur                           909
watchlist                     1077
logging                       1260
categorylinks                 1426
james_revision_users          1760
recentchanges                 2166
externallinks                 3594
pagelinks                     4009
revision                      22622

By wiki

Index sizes for the revision table, 2007-02-23.

DB	revision index size (MB)
enwiki	26420.85938
dewiki	6198.234375
frwiki	3331.65625
jawiki	2746.640625
nlwiki	1606.421875
eswiki	1600.40625
itwiki	1570.09375
plwiki	1467.375
commonswiki	1130.328125
ptwiki	1124.390625
svwiki	859.484375
zhwiki	837.28125
ruwiki	736.234375
fiwiki	623.296875
hewiki	604
enwiktionary	516.875
frwiktionary	507.109375
nowiki	484.984375
huwiki	344.484375
cswiki	275.171875
dawiki	271.09375
eowiki	263.359375
trwiki	239.8125
bgwiktionary	235.9375
cawiki	207.0625
bgwiki	190.78125
srwiki	188.8125
rowiki	187.890625
skwiki	186.515625
kowiki	184.734375
slwiki	182.9375
enwikibooks	162.78125
arwiki	139.71875
metawiki	132.6875
idwiki	130.59375
hrwiki	124.5625
ltwiki	122.53125
etwiki	121.78125
ukwiki	118.625
dewiktionary	117.5
viwiki	110.578125
iowiktionary	110.421875
elwiki	105.796875
zhwiktionary	103.265625
enwikinews	102.21875
enwikiquote	100.609375
fawiki	98
plwiktionary	97.65625
euwiki	97.640625
thwiki	97.59375
viwiktionary	91.875
ruwiktionary	90.921875
enwikisource	82.484375
glwiki	75.546875
simplewiki	75.453125
dewikinews	71.203125
fiwiktionary	70.90625
nnwiki	69.625
elwiktionary	65.828125
specieswiki	65.46875
dewikibooks	59.234375
bswiki	58.921875
ptwiktionary	56.9375
dewikiquote	56.6875
mswiki	56.5625
frwikisource	56.28125
lawiki	54.6875
lbwiki	53.59375
itwiktionary	52.203125
kawiki	51.21875
iswiki	48.328125
svwiktionary	47.5625
huwiktionary	44.859375
sqwiki	44.34375
dewikisource	44.140625
trwiktionary	43.921875
nlwiktionary	43.28125
kshwiki	38.953125
afwiki	37.453125
eswiktionary	32.96875
glwiktionary	31.5625
brwiki	31
astwiki	30.546875
lvwiki	30.171875
mkwiki	29.328125
frwikibooks	29.234375
jawiktionary	28.203125
napwiki	28.109375
enwikiversity	27.25
ocwiki	27.109375
anwiki	27.09375
etwiktionary	26.921875
cywiki	26.484375
bnwiki	26.453125
bewiki	26.09375
nostalgiawiki	25.609375
tawiki	24.75
scnwiki	24.34375
eswikisource	24.21875
iowiki	24.1875
gawiki	23.625
wawiki	23.390625
itwikiquote	21.21875
tewiki	20.796875
ttwiki	20.25
eswikibooks	20.21875
kuwiktionary	19.953125
alswiki	19.671875
ndswiki	19.265625
itwikisource	18.859375
yiwiki	18.75
shwiki	18.671875
slwiktionary	18.671875
fywiki	18.40625
iawiki	17.5625
uzwiki	17.453125
kuwiki	17.078125
tlwiki	16.8125
azwiki	16.640625
sourceswiki	16.609375
nlwikibooks	16.078125
kowiktionary	15.875
itwikinews	15.8125
mrwiki	15.625
liwiki	15.421875
plwikiquote	15.28125
cebwiki	15.0625
itwikibooks	15.046875
urwiki	14.796875
idwiktionary	14.4375
lawiktionary	14.359375
zh_min_nanwiki	14.3125
bpywiki	14.265625
cowiki	14.25
suwiki	14.171875
hiwiki	13.78125
ptwikisource	13.5625
incubatorwiki	13.359375
zhwikisource	13.328125
jawikinews	13.125
plwikinews	13.078125
gdwiki	12.859375
zh_yuewiki	12.796875
cvwiki	12.75
nowiktionary	12.65625
frwikinews	12.625
ru_sibwiki	12.5
eswikiquote	12.078125
plwikibooks	11.9375
ptwikinews	11.921875
hewiktionary	11.796875
mediawikiwiki	11.796875
knwiki	11.671875
ptwikiquote	11.625
ptwikibooks	11.609375
swwiki	11.59375
tawiktionary	11.578125
srwiktionary	11.21875
ruwikisource	11.078125
eswikinews	11
frwikiquote	10.765625
hywiki	10.625
nds_nlwiki	10.515625
vecwiki	10.3125
lmowiki	10.296875
vlswiki	10.125
hewikiquote	9.953125
hewikibooks	9.9375
huwikibooks	9.921875
plwikisource	9.921875
htwiki	9.8125
arwiktionary	9.796875
afwiktionary	9.71875
fiwikibooks	9.578125
tgwiki	9.453125
mlwiki	9.421875
fawiktionary	9.375
skwikiquote	9.34375
hrwikisource	9.1875
oswiki	9.125
fowiki	8.96875
hewikisource	8.890625
dewikiversity	8.796875
hywiktionary	8.53125
iswiktionary	8.328125
ruwikiquote	8.328125
zh_classicalwiki	8.3125
kwwiki	8.234375
lawikisource	8.109375
svwikinews	8
jvwiki	7.65625
amwiki	7.40625
frpwiki	7.359375
scowiki	7.328125
mtwiki	7.109375
bswikiquote	6.984375
srwikinews	6.953125
rowiktionary	6.75
zhwikiquote	6.6875
zhwikinews	6.671875
newwiki	6.4375
pmswiki	6.421875
pswiki	6.375
nrmwiki	6.203125
bgwikiquote	6.15625
ilowiki	6.140625
thwikisource	6.140625
warwiki	6.140625
jawikibooks	6.109375
quwiki	6.109375
svwikisource	6.078125
angwiki	6.0625
frwikiversity	6.046875
furwiki	6.03125
testwiki	6.03125
angwiktionary	6
foundationwiki	6
ladwiki	6
rowikisource	5.953125
scnwiktionary	5.875
jawikiquote	5.859375
pamwiki	5.859375
nlwikisource	5.84375
cawiktionary	5.828125
elwikisource	5.8125
sewiki	5.8125
svwikibooks	5.765625
nlwikimedia	5.75
huwikiquote	5.71875
cswiktionary	5.703125
miwiki	5.703125
vowiki	5.640625
jawikisource	5.625
nlwikinews	5.625
hiwiktionary	5.609375
ruwikibooks	5.578125
dawiktionary	5.546875
iawiktionary	5.5
rowikinews	5.46875
csbwiki	5.453125
ukwiktionary	5.4375
eowiktionary	5.40625
slwikiquote	5.40625
fiu_vrowiki	5.359375
kkwiki	5.3125
trwikiquote	5.3125
kkwiktionary	5.265625
ugwiki	5.265625
fiwikiquote	5.234375
simplewiktionary	5.234375
zh_min_nanwiktionary	5.234375
cowiktionary	5.21875
mowiki	5.203125
nawiki	5.171875
sawiki	5.15625
skwiktionary	5.140625
guwiki	5.125
hsbwiki	5.09375
novwiki	5.09375
nahwiki	4.96875
hrwiktionary	4.859375
trwikisource	4.828125
cswikisource	4.78125
dawikibooks	4.78125
zhwikibooks	4.71875
mnwiki	4.671875
srwikisource	4.671875
jbowiki	4.65625
nlwikiquote	4.640625
bat_smgwiki	4.46875
alswiktionary	4.4375
nowikiquote	4.34375
bawiki	4.109375
lnwiki	4.109375
pdcwiki	3.953125
wikimania2006wiki	3.953125
sep11wiki	3.921875
roa_rupwiki	3.75
bswiktionary	3.65625
mgwiki	3.625
fawikiquote	3.515625
vowiktionary	3.359375
sdwiktionary	3.28125
fywiktionary	3.265625
srwikiquote	3.25
tkwiki	3.15625
svwikiquote	3.09375
kywiki	2.921875
scwiki	2.90625
barwiki	2.890625
elwikiquote	2.78125
towiki	2.78125
fiwikisource	2.703125
chrwiki	2.59375
diqwiki	2.59375
arwikisource	2.578125
ruwikinews	2.53125
rmwiki	2.421875
map_bmswiki	2.328125
skwikibooks	2.328125
thwiktionary	2.3125
gnwiki	2.265625
sdwiki	2.265625
aywiki	2.234375
guwiktionary	2.1875
wikimania2005wiki	2.1875
yiwiktionary	2.171875
csbwiktionary	2.15625
iiwiki	2.15625
zawiki	2.15625
sqwiktionary	2.109375
newiki	2
ndswiktionary	1.96875
tewiktionary	1.953125
ltwikiquote	1.921875
idwikibooks	1.890625
kmwiki	1.765625
tpiwiki	1.765625
yowiki	1.734375
brwiktionary	1.703125
ltwiktionary	1.671875
stwiktionary	1.671875
kswiki	1.65625
eswikiversity	1.640625
glwikiquote	1.640625
idwikiquote	1.640625
kywiktionary	1.625
bmwiki	1.578125
knwiktionary	1.578125
mlwiktionary	1.5625
urwiktionary	1.5625
gvwiki	1.53125
sowiki	1.515625
quwiktionary	1.46875
wowiki	1.46875
smwiki	1.453125
bowiki	1.4375
mywiki	1.421875
bswikisource	1.40625
ukwikinews	1.40625
dvwiki	1.359375
nahwiktionary	1.359375
hewikinews	1.34375
abwiki	1.328125
aswiki	1.328125
klwiki	1.328125
arcwiki	1.3125
lijwiki	1.296875
mkwiktionary	1.296875
srwikibooks	1.265625
dawikisource	1.234375
glwikibooks	1.234375
bhwiki	1.1875
biwiki	1.1875
plwikimedia	1.1875
bgwikibooks	1.171875
huwikisource	1.171875
rmywiki	1.171875
cswikibooks	1.125
sawiktionary	1.125
viwikibooks	1.109375
abwiktionary	1.09375
bgwikinews	1.09375
cswikiquote	1.09375
iswikibooks	1.078125
kowikibooks	1.078125
cawikinews	1.0625
iewiki	1.0625
internalwiki	1.03125
wuuwiki	1.015625
betawikiversity	1
kawikiquote	1
tlhwiktionary	0.984375
ukwikibooks	0.984375
fawikibooks	0.96875
thwikibooks	0.921875
trwikibooks	0.90625
boardwiki	0.890625
cywiktionary	0.890625
sdwikinews	0.890625
anwiktionary	0.875
tetwiki	0.875
eowikibooks	0.859375
nowikinews	0.859375
rowikiquote	0.859375
emlwiki	0.84375
cawikibooks	0.796875
cdowiki	0.796875
nowikibooks	0.796875
arwikibooks	0.78125
arwikiquote	0.78125
wikimania2007wiki	0.78125
astwiktionary	0.765625
kawikibooks	0.765625
mrwiktionary	0.75
iewiktionary	0.734375
glwikisource	0.71875
kowikisource	0.71875
swwiktionary	0.71875
siwiki	0.703125
tlwiktionary	0.703125
euwikiquote	0.671875
papwiki	0.671875
tlhwiki	0.671875
avwiki	0.640625
udmwiki	0.640625
scwiktionary	0.625
zuwiki	0.625
hrwikibooks	0.609375
iuwiki	0.609375
nowikisource	0.609375
amwiktionary	0.59375
cawikiquote	0.59375
gotwiki	0.59375
kawiktionary	0.59375
mkwikibooks	0.59375
mswiktionary	0.59375
cuwiki	0.578125
wikimaniateamwiki	0.578125
tywiki	0.5625
etwikibooks	0.546875
fowiktionary	0.546875
lowiki	0.546875
spcomwiki	0.546875
thwikinews	0.546875
viwikiquote	0.53125
cbk_zamwiki	0.515625
kgwiki	0.515625
ocwiktionary	0.5
cawikisource	0.484375
eowikiquote	0.484375
knwikisource	0.484375
rwwiktionary	0.484375
suwiktionary	0.484375
ttwiktionary	0.484375
bswikibooks	0.46875
lawikiquote	0.46875
sqwikibooks	0.46875
tewikisource	0.453125
angwikibooks	0.4375
dawikiquote	0.4375
hywikibooks	0.4375
ltwikibooks	0.4375
bswikinews	0.421875
fawikisource	0.421875
pswiktionary	0.421875
slwikisource	0.421875
tawikibooks	0.421875
gawiktionary	0.40625
hawwiki	0.40625
idwikisource	0.40625
pagwiki	0.40625
crwiki	0.390625
viwikisource	0.390625
zeawiki	0.390625
bewiktionary	0.375
kuwikiquote	0.375
simplewikibooks	0.375
slwikibooks	0.375
lawikibooks	0.34375
lvwiktionary	0.34375
rowikibooks	0.34375
simplewikiquote	0.34375
angwikiquote	0.328125
bnwikibooks	0.328125
etwikiquote	0.328125
glkwiki	0.328125
stwiki	0.328125
hrwikiquote	0.3125
nvwiki	0.3125
pawiki	0.3125
bugwiki	0.296875
nawiktionary	0.296875
alswikibooks	0.28125
comcomwiki	0.265625
euwiktionary	0.265625
iewikibooks	0.265625
ukwikiquote	0.265625
arwikinews	0.25
cywikisource	0.25
grantswiki	0.25
iswikisource	0.25
mrwikibooks	0.25
nnwiktionary	0.25
thwikiquote	0.25
tlwikibooks	0.25
chwikimedia	0.234375
kowikiquote	0.234375
lgwiki	0.234375
mgwiktionary	0.234375
skwikisource	0.234375
bgwikisource	0.21875
cowikibooks	0.21875
gdwiktionary	0.21875
kmwiktionary	0.21875
miwiktionary	0.21875
mnwiktionary	0.21875
twwiki	0.21875
xhwiki	0.21875
akwiki	0.203125
gvwiktionary	0.203125
lbwiktionary	0.203125
sowiktionary	0.203125
tnwiki	0.203125
vewiki	0.203125
zh_min_nanwikisource	0.203125
mlwikisource	0.171875
mznwiki	0.171875
sqwikiquote	0.171875
mlwikibooks	0.15625
piwiki	0.15625
ukwikisource	0.15625
xhwiktionary	0.15625
azwiktionary	0.140625
cewiki	0.140625
eewiki	0.140625
etwikisource	0.140625
ffwiki	0.140625
fjwiki	0.140625
fywikibooks	0.140625
hawiktionary	0.140625
igwiki	0.140625
ikwiki	0.140625
klwiktionary	0.140625
kvwiki	0.140625
mswikibooks	0.140625
newiktionary	0.140625
pawiktionary	0.140625
roa_tarawiki	0.140625
rwwiki	0.140625
tpiwiktionary	0.140625
tumwiki	0.140625
azwikibooks	0.125
bnwiktionary	0.125
elwikibooks	0.125
hawiki	0.125
iawikibooks	0.125
nawikibooks	0.125
urwikibooks	0.125
astwikiquote	0.109375
aywiktionary	0.109375
chwiki	0.109375
cywikibooks	0.109375
dvwiktionary	0.109375
dzwiki	0.109375
fjwiktionary	0.109375
gnwiktionary	0.109375
guwikiquote	0.109375
jvwiktionary	0.109375
kswiktionary	0.109375
kuwikibooks	0.109375
lnwiktionary	0.109375
mkwikisource	0.109375
mlwikiquote	0.109375
mrwikiquote	0.109375
nnwikiquote	0.109375
omwiktionary	0.109375
orwiki	0.109375
rmwiktionary	0.109375
siwiktionary	0.109375
smwiktionary	0.109375
tgwiktionary	0.109375
tnwiktionary	0.109375
tswiktionary	0.109375
twwiktionary	0.109375
ugwiktionary	0.109375
urwikiquote	0.109375
uzwiktionary	0.109375
wowiktionary	0.109375
xalwiki	0.109375
yiwikisource	0.109375
aawiki	0.078125
aawikibooks	0.078125
aawiktionary	0.078125
afwikibooks	0.078125
afwikiquote	0.078125
akwikibooks	0.078125
akwiktionary	0.078125
alswikiquote	0.078125
amwikiquote	0.078125
angwikisource	0.078125
astwikibooks	0.078125
aswikibooks	0.078125
aswiktionary	0.078125
avwiktionary	0.078125
aywikibooks	0.078125
azwikiquote	0.078125
azwikisource	0.078125
bawikibooks	0.078125
bawiktionary	0.078125
bewikibooks	0.078125
bewikiquote	0.078125
bhwiktionary	0.078125
biwikibooks	0.078125
biwiktionary	0.078125
bmwikibooks	0.078125
bmwikiquote	0.078125
bmwiktionary	0.078125
bowikibooks	0.078125
bowiktionary	0.078125
bxrwiki	0.078125
chairwiki	0.078125
chapcomwiki	0.078125
chowiki	0.078125
chrwiktionary	0.078125
chwikibooks	0.078125
chwiktionary	0.078125
chywiki	0.078125
closed_zh_twwiki	0.078125
cowikiquote	0.078125
crwikiquote	0.078125
crwiktionary	0.078125
cvwikibooks	0.078125
cywikiquote	0.078125
dkwikibooks	0.078125
dkwiktionary	0.078125
dzwiktionary	0.078125
euwikibooks	0.078125
fowikisource	0.078125
gawikibooks	0.078125
gawikiquote	0.078125
gnwikibooks	0.078125
gotwikibooks	0.078125
guwikibooks	0.078125
hiwikibooks	0.078125
hiwikiquote	0.078125
howiki	0.078125
htwikisource	0.078125
hywikiquote	0.078125
hzwiki	0.078125
ikwiktionary	0.078125
iswikiquote	0.078125
iuwiktionary	0.078125
jbowiktionary	0.078125
kiwiki	0.078125
kjwiki	0.078125
kkwikibooks	0.078125
kkwikiquote	0.078125
kmwikibooks	0.078125
knwikibooks	0.078125
knwikiquote	0.078125
krwiki	0.078125
krwikiquote	0.078125
kswikibooks	0.078125
kswikiquote	0.078125
kwwikiquote	0.078125
kwwiktionary	0.078125
kywikibooks	0.078125
kywikiquote	0.078125
langcomwiki	0.078125
lbewiki	0.078125
lbwikibooks	0.078125
lbwikiquote	0.078125
liwiktionary	0.078125
lnwikibooks	0.078125
lowiktionary	0.078125
ltwikisource	0.078125
lvwikibooks	0.078125
mgwikibooks	0.078125
mhwiki	0.078125
mhwiktionary	0.078125
miwikibooks	0.078125
mnwikibooks	0.078125
mowiktionary	0.078125
mtwiktionary	0.078125
muswiki	0.078125
mywikibooks	0.078125
mywiktionary	0.078125
nahwikibooks	0.078125
nawikiquote	0.078125
ndswikibooks	0.078125
ndswikiquote	0.078125
newikibooks	0.078125
ngwiki	0.078125
nywiki	0.078125
nzwikimedia	0.078125
ocwikibooks	0.078125
officewiki	0.078125
omwiki	0.078125
orwiktionary	0.078125
pawikibooks	0.078125
pihwiki	0.078125
piwiktionary	0.078125
pswikibooks	0.078125
quwikibooks	0.078125
quwikiquote	0.078125
rmwikibooks	0.078125
rnwiki	0.078125
rnwiktionary	0.078125
roa_rupwiktionary	0.078125
sawikibooks	0.078125
searchcomwiki	0.078125
sewikibooks	0.078125
sgwiki	0.078125
sgwiktionary	0.078125
shwiktionary	0.078125
siwikibooks	0.078125
snwiki	0.078125
snwiktionary	0.078125
sswiki	0.078125
sswiktionary	0.078125
suwikibooks	0.078125
suwikiquote	0.078125
swwikibooks	0.078125
tawikinews	0.078125
tawikiquote	0.078125
tewikibooks	0.078125
tewikiquote	0.078125
tgwikibooks	0.078125
tiwiki	0.078125
tiwiktionary	0.078125
tkwikibooks	0.078125
tkwikiquote	0.078125
tkwiktionary	0.078125
tokiponawiki	0.078125
tokiponawikibooks	0.078125
tokiponawikiquote	0.078125
tokiponawiktionary	0.078125
towiktionary	0.078125
tswiki	0.078125
ttwikibooks	0.078125
ttwikiquote	0.078125
ugwikibooks	0.078125
ugwikiquote	0.078125
uzwikibooks	0.078125
uzwikiquote	0.078125
vowikibooks	0.078125
vowikiquote	0.078125
wawikibooks	0.078125
wawiktionary	0.078125
wowikiquote	0.078125
xhwikibooks	0.078125
yowikibooks	0.078125
yowiktionary	0.078125
zawikibooks	0.078125
zawikiquote	0.078125
zawiktionary	0.078125
zh_min_nanwikibooks	0.078125
zh_min_nanwikiquote	0.078125
zuwikibooks	0.078125
zuwiktionary	0.078125
ilwikimedia	0.078125