Page MenuHomePhabricator
Paste P8607

Number of archive rows with blank ar_sha1 on each wiki
ActivePublic

Authored by Catrope on Jun 11 2019, 10:23 PM.
arcwiki: 1
arwiki: 1
azwiki: 3
bgwiki: 5
cawiki: 1
commonswiki: 282
cswiki: 1
dawiki: 2
dewiki: 2718
dewikiversity: 1
dewikivoyage: 39105
enwiki: 1684
enwikibooks: 2
enwikiquote: 2
eswiki: 276
eswiktionary: 64
etwiki: 1
fawiki: 1
fiwiki: 1
frwiki: 488
frwikisource: 2
hrwiki: 1
huwiki: 14
idwiki: 3
itwiki: 262
itwikivoyage: 45940
jawiki: 51
kowiki: 3
kvwiki: 1
metawiki: 3
nlwiki: 8
nlwiktionary: 605
nowiki: 6
oswiki: 1
plwiki: 192
ptwiki: 4
ruwiki: 23
ruwiktionary: 1
slwiki: 4
sourceswiki: 1
srwiki: 4
svwiki: 168
tawiki: 1
testwiki: 11
trwiki: 1
ukwiki: 1
zhwiki: 18

Event Timeline

On stat1006:

(for wiki in $(cat ~/all.dblist); do echo -n "$wiki: "; echo "select count(*) from archive where ar_sha1='';" | analytics-mysql $wiki -N; done) | tee ~/empty-sha1
cat ~/empty-sha1 | grep -v ': 0'