Obsolete:Index sizes

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

See also Index size versus traffic.

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