Lucas_Werkmeister_WMDE added a comment.
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-01-25 16:56:24 | 7441381 | 1050128 | 1684320 |
+---------------------+---------+------------+---------+
1 row in set (2.756 sec)
If we assume that the “other” usages continue decreasing at a constant rate,
and the “statements” usages increase at a constant rate until the “others” hit
zero, we can estimate (1050128 - 868357) / (1711896 - 1684320) * 1684320 +
1050128 = 12152555 **12 million** total statement usages, for ca. 18½ million
rows in the table in total. That’s substantial (not quite the “much less [than
65 million]” I had in mind in the task description), but not likely to cause
any actual problems, I think. hywiki uses more statements per page than I
expected initially.
TASK DETAIL
https://phabricator.wikimedia.org/T296382
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, 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]
