Multichill added a comment.
Done, original database query was about 1.7M items and is now empty.
TASK DETAIL
https://phabricator.wikimedia.org/T127655
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Multichill
Cc: Aklapper, hoo, Multichill,
Multichill added a comment.
Running a purge job now. Going from low to high. Am at Q863903
TASK DETAIL
https://phabricator.wikimedia.org/T127655
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Multichill
Cc: Aklapper, hoo, Multichill,
Multichill added a comment.
First million items are ready to purge. According to
https://tendril.wikimedia.org/report/table_status?host=db1058=wikidata
the page_props table size is now 20.9M rows. Wonder what that is going to be
when we're done, I expect about 66M (16M items times 4
Multichill added a comment.
Found an old query at
https://tools.wmflabs.org/multichill/queries/wikidata/no_pageprops.sql . It's
not completely correct, but the last time it ran it returned 2476796 items.
Rerunning it now, output will be at