Hall1467 added a comment.
@Ladsgroup: I believe this is the only related open patch right now: https://gerrit.wikimedia.org/r/#/c/355104/. Is that right, @hoo?TASK DETAILhttps://phabricator.wikimedia.org/T151717EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To
Hall1467 added a comment.
@hoo: elwiki sounds good to me.TASK DETAILhttps://phabricator.wikimedia.org/T151717EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Hall1467Cc: gerritbot, Halfak, jcrespo, TomT0m, Hall1467, hoo, zhuyifei1999, Eloquence
Hall1467 added a comment.
@jcrespo: Related to your first comment, the patch that I provided a link to (in my comment from one month ago) is now invalid since we are no longer planning on using a separate table in order to implement statement tracking. A new patch should be ready soon implementing
Hall1467 added a comment.
@jcrespo: We have decided to update the existing wbc_entity_usage table in order to allow for statement tracking (probably done via the "eu_aspect_id" field). We would do an initial deployment to a medium-sized Wikipedia at first and calculate database IO load.
Hall1467 added a comment.
@jcrespo: Asking my question on here per your request.
We were wondering what your thoughts are for the proposed logging table. See statement_usage.sql (https://gerrit.wikimedia.org/r/#/c/336542/19/client/sql/statement_usage.sql) for the schema. The schema is
Hall1467 added a project: DBA.
TASK DETAILhttps://phabricator.wikimedia.org/T151717EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Hall1467Cc: Halfak, jcrespo, TomT0m, Hall1467, hoo, zhuyifei1999, Eloquence, Lydia_Pintscher, Sannita, Ainali, Liuxinyu970226
Hall1467 added a comment.
To follow up on @Halfak's database usage assessments, the estimate of 5 properties per entity/page relationship seems reasonable and conservative since the average number of statements per entity is in fact ~5 as seen here: https://grafana.wikimedia.org/dashboa
Hall1467 added a comment.
If we choose to go the database route instead of EventLogging, my initial thoughts would be to create a new table containing (modeled after @Halfak's reference and the current entity usage documentation: https://github.com/wikimedia/mediawiki-extensions-Wikibase
Hall1467 added a comment.
I'd be happy to take the lead on the implementation of this task. Would that be okay?TASK DETAILhttps://phabricator.wikimedia.org/T151717EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: Hall1467Cc: TomT0m, Hall1467, hoo, zhuyife
Hall1467 added a comment.
I think a good way to go about this tracking would be by overriding the Lua direct access method for the table that represents the entity.
This can be done via an “__index” metamethod that would log statement usage (see this example of tracking: https://www.lua.org/pil
10 matches
Mail list logo
