[Wikidata-bugs] [Maniphest] [Commented On] T127655: Populate page_props table for all items on wikidata.org

2016-02-24 Thread Multichill
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,

[Wikidata-bugs] [Maniphest] [Commented On] T127655: Populate page_props table for all items on wikidata.org

2016-02-21 Thread 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,

[Wikidata-bugs] [Maniphest] [Commented On] T127655: Populate page_props table for all items on wikidata.org

2016-02-21 Thread 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

[Wikidata-bugs] [Maniphest] [Commented On] T127655: Populate page_props table for all items on wikidata.org

2016-02-21 Thread Multichill
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