Addshore added a comment.
Currently it looks like the maintenance script will only need to run over
~300k items
mysql:[email protected] [wikidatawiki]> select
count(DISTINCT rc_title) from recentchanges where rc_timestamp > 20200406230000
and rc_namespace = 0 limit 10;
+--------------------------+
| count(DISTINCT rc_title) |
+--------------------------+
| 316126 |
+--------------------------+
1 row in set (9.67 sec)
This may still increase while the table continue to be restored, but it does
mean the run of the maint script shouldn't take too long.
First change (roughly) that we need to be concerned with rebuilding for
(it'll probably be more efficient to use this rc_id nd the rc_id at the point
the restored table is restored rather than a timestamp range) (but also might
not matter)
mysql:[email protected] [wikidatawiki]> select rc_id,
rc_title, rc_namespace, rc_timestamp from recentchanges where rc_timestamp =
20200406230000 limit 1;
+------------+-----------+--------------+----------------+
| rc_id | rc_title | rc_namespace | rc_timestamp |
+------------+-----------+--------------+----------------+
| 1190150512 | Q13161841 | 0 | 20200406230000 |
+------------+-----------+--------------+----------------+
1 row in set (0.31 sec)
TASK DETAIL
https://phabricator.wikimedia.org/T249596
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Addshore
Cc: Addshore, Aklapper, Tarrow, Oblanco79, Alter-paule, Beast1978, Un1tY,
Hook696, Daryl-TTMG, RomaAmorRoma, E.S.A-Sheild, Iflorez, darthmon_wmde,
Kent7301, alaa_wmde, Meekrab2012, joker88john, CucyNoiD, Nandana, NebulousIris,
Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30,
Lahi, Gq86, Af420, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic,
Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, WSH1906,
Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS, Jonas, Wikidata-bugs,
aude, Lydia_Pintscher, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
