Lucas_Werkmeister_WMDE closed this task as "Resolved".
Lucas_Werkmeister_WMDE moved this task from Tech Verification to Our work done
on the Wikidata-Campsite (Team A Hearth 🏰🔥) board.
Lucas_Werkmeister_WMDE added a comment.
One month later:
MariaDB [hywiki]> SELECT NOW() AS asof, COUNT(*) AS total, SUM(eu_aspect
LIKE 'C%') AS statements, SUM(eu_aspect LIKE 'O%') AS others FROM
wbc_entity_usage;
+---------------------+----------+------------+--------+
| asof | total | statements | others |
+---------------------+----------+------------+--------+
| 2022-02-28 09:55:39 | 14842746 | 10086742 | 8391 |
+---------------------+----------+------------+--------+
1 row in set (6.068 sec)
Other usages are basically gone; statement usages have stayed around 10
million; total usages are down to just under 15 million (from over 16 million
in T296382#7651993 <https://phabricator.wikimedia.org/T296382#7651993>).
MariaDB [hywiki]> SELECT COUNT(*) AS total, SUM(rc_type = 5) FROM
recentchanges;
+--------+------------------+
| total | SUM(rc_type = 5) |
+--------+------------------+
| 274021 | 210804 |
+--------+------------------+
1 row in set (0.200 sec)
Total recent changes rows are down from 380k (T296382#7664474
<https://phabricator.wikimedia.org/T296382#7664474>) to 270k, with 210k
Wikidata changes (down from 290k).
I think we can call this a success and close this task.
TASK DETAIL
https://phabricator.wikimedia.org/T296382
WORKBOARD
https://phabricator.wikimedia.org/project/board/5612/
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: noarave, Lucas_Werkmeister_WMDE
Cc: Ladsgroup, Aklapper, Lydia_Pintscher, hoo, Michael, Marostegui,
Lucas_Werkmeister_WMDE, Lmlmljs, karapayneWMDE, Invadibot, maantietaja,
Akuckartz, Nandana, lucamauri, Lahi, Gq86, GoranSMilovanovic, QZanden,
LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Addshore,
Mbch331
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
