Nothing Special   »   [go: up one dir, main page]
Page MenuHomePhabricator
Paste P2860

cu_changes deletion on beta
ActivePublic
Actions

Authored by Krenair on Apr 5 2016, 7:49 PM.
Tags
Referenced Files
F3834176: cu_changes deletion on beta
Apr 5 2016, 7:50 PM
F3834173: cu_changes deletion on beta
Apr 5 2016, 7:49 PM
Subscribers
Liuxinyu970226
krenair@deployment-tin:~$ while read p; do echo $p; sql $p -e "select max(cuc_timestamp), count(*) from cu_changes"; done </srv/mediawiki-staging/dblists/all-labs.dblist
aawiki
max(cuc_timestamp) count(*)
20120529203332 3
arwiki
max(cuc_timestamp) count(*)
20120607134102 7
cawiki
max(cuc_timestamp) count(*)
NULL 0
commonswiki
max(cuc_timestamp) count(*)
20120613131336 149
deploymentwiki
max(cuc_timestamp) count(*)
20120613160735 376
dewiki
max(cuc_timestamp) count(*)
20120605131149 1166
en_rtlwiki
max(cuc_timestamp) count(*)
NULL 0
enwiki
max(cuc_timestamp) count(*)
20120718135609 320
enwikibooks
max(cuc_timestamp) count(*)
20120613160350 949
enwikinews
max(cuc_timestamp) count(*)
20120608135320 496
enwikiquote
max(cuc_timestamp) count(*)
20120610142757 29
enwikisource
max(cuc_timestamp) count(*)
20120608173349 328
enwikiversity
max(cuc_timestamp) count(*)
20120610142746 222
enwikivoyage
max(cuc_timestamp) count(*)
NULL 0
enwiktionary
max(cuc_timestamp) count(*)
20120609081352 483
eowiki
max(cuc_timestamp) count(*)
20120610182536 5
eswiki
max(cuc_timestamp) count(*)
NULL 0
fawiki
max(cuc_timestamp) count(*)
NULL 0
hewiki
max(cuc_timestamp) count(*)
20120610182708 19
hiwiki
max(cuc_timestamp) count(*)
NULL 0
jawiki
max(cuc_timestamp) count(*)
NULL 0
kowiki
max(cuc_timestamp) count(*)
NULL 0
loginwiki
max(cuc_timestamp) count(*)
NULL 0
metawiki
max(cuc_timestamp) count(*)
20120612074934 427
ruwiki
max(cuc_timestamp) count(*)
NULL 0
simplewiki
max(cuc_timestamp) count(*)
20120613161546 370
sqwiki
max(cuc_timestamp) count(*)
20120610140956 666
testwiki
max(cuc_timestamp) count(*)
20120531171740 52
ukwiki
max(cuc_timestamp) count(*)
NULL 0
wikidatawiki
max(cuc_timestamp) count(*)
NULL 0
zerowiki
max(cuc_timestamp) count(*)
NULL 0
zhwiki
max(cuc_timestamp) count(*)
NULL 0
krenair@deployment-tin:~$ while read p; do echo $p; sql $p -e "truncate cu_changes"; done </srv/mediawiki-staging/dblists/all-labs.dblist
aawiki
arwiki
cawiki
commonswiki
deploymentwiki
dewiki
en_rtlwiki
enwiki
enwikibooks
enwikinews
enwikiquote
enwikisource
enwikiversity
enwikivoyage
enwiktionary
eowiki
eswiki
fawiki
hewiki
hiwiki
jawiki
kowiki
loginwiki
metawiki
ruwiki
simplewiki
sqwiki
testwiki
ukwiki
wikidatawiki
zerowiki
zhwiki
krenair@deployment-tin:~$ while read p; do echo $p; sql $p -e "select max(cuc_timestamp), count(*) from cu_changes"; done </srv/mediawiki-staging/dblists/all-labs.dblist
aawiki
max(cuc_timestamp) count(*)
NULL 0
arwiki
max(cuc_timestamp) count(*)
NULL 0
cawiki
max(cuc_timestamp) count(*)
NULL 0
commonswiki
max(cuc_timestamp) count(*)
NULL 0
deploymentwiki
max(cuc_timestamp) count(*)
NULL 0
dewiki
max(cuc_timestamp) count(*)
NULL 0
en_rtlwiki
max(cuc_timestamp) count(*)
NULL 0
enwiki
max(cuc_timestamp) count(*)
NULL 0
enwikibooks
max(cuc_timestamp) count(*)
NULL 0
enwikinews
max(cuc_timestamp) count(*)
NULL 0
enwikiquote
max(cuc_timestamp) count(*)
NULL 0
enwikisource
max(cuc_timestamp) count(*)
NULL 0
enwikiversity
max(cuc_timestamp) count(*)
NULL 0
enwikivoyage
max(cuc_timestamp) count(*)
NULL 0
enwiktionary
max(cuc_timestamp) count(*)
NULL 0
eowiki
max(cuc_timestamp) count(*)
NULL 0
eswiki
max(cuc_timestamp) count(*)
NULL 0
fawiki
max(cuc_timestamp) count(*)
NULL 0
hewiki
max(cuc_timestamp) count(*)
NULL 0
hiwiki
max(cuc_timestamp) count(*)
NULL 0
jawiki
max(cuc_timestamp) count(*)
NULL 0
kowiki
max(cuc_timestamp) count(*)
NULL 0
loginwiki
max(cuc_timestamp) count(*)
NULL 0
metawiki
max(cuc_timestamp) count(*)
NULL 0
ruwiki
max(cuc_timestamp) count(*)
NULL 0
simplewiki
max(cuc_timestamp) count(*)
NULL 0
sqwiki
max(cuc_timestamp) count(*)
NULL 0
testwiki
max(cuc_timestamp) count(*)
NULL 0
ukwiki
max(cuc_timestamp) count(*)
NULL 0
wikidatawiki
max(cuc_timestamp) count(*)
NULL 0
zerowiki
max(cuc_timestamp) count(*)
NULL 0
zhwiki
max(cuc_timestamp) count(*)
NULL 0
krenair@deployment-tin:~$
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits