[Wikidata-bugs] [Maniphest] [Commented On] T177772: Purge 90% of rows from recentchanges (and posibly defragment) from commonswiki and ruwiki (the ones with source:wikidata)

[jcrespo]

jcrespo added a comment.

ruwiki results are more extreme:

root@db2076[ruwiki]> SELECT count(*) FROM recentchanges;
+----------+
| count(*) |
+----------+
| 37427748 |
+----------+
1 row in set (11.19 sec)

root@db2076[ruwiki]> SELECT COUNT(*) FROM recentchanges WHERE rc_source = 'wb';
+----------+
| COUNT(*) |
+----------+
| 36207647 |
+----------+
1 row in set (8 min 57.10 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T177772

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: jcrespo
Cc: Stashbot, Jdforrester-WMF, Bawolff, Lydia_Pintscher, hoo, Ladsgroup, Base, Aklapper, TerraCodes, Jay8g, Liuxinyu970226, Marostegui, jcrespo, GoranSMilovanovic, QZanden, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Mbch331, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs