Maniphest T119726

A long-running query is done on the master (WikimediaEventsHooks.php)
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	jcrespo
	Nov 26 2015, 4:16 PM

Description

count:23
max_time:12
avg_time:11
total_time:269
server: db1040
user: wikiuser
wiki: commonswiki
last_seen: 2015-11-26 15:40:10
query: SELECT /* /srv/mediawiki/php-1.27.0-wmf.7/extensions/WikimediaEvents/WikimediaEventsHooks.php:156 <sanitized> */ COUNT(*) AS rowcount FROM (SELECT 1 FROM `revision` INNER JOIN `page` ON ((rev_page = page_id)) WHERE rev_user = '1159597' AND (rev_timestamp >= '20151031000000') AND page_namespace = '0' LIMIT 6 ) tmp_count

Related Objects

Mentioned Here: T177101: PageContentSaveComplete. Stop collecting

Event Timeline

jcrespo created this task.Nov 26 2015, 4:16 PM

jcrespo raised the priority of this task from to Needs Triage.

jcrespo updated the task description. (Show Details)

jcrespo added projects: WMF-General-or-Unknown, Performance Issue.

jcrespo subscribed.

Restricted Application added subscribers: StudiesWorld, Aklapper. · View Herald TranscriptNov 26 2015, 4:16 PM

Reedy added a project: MediaWiki-extensions-WikimediaEvents.Nov 26 2015, 4:16 PM

Reedy set Security to None.

jcrespo renamed this task from A long-running query is done on the master to A long-running query is done on the master (WikimediaEventsHooks.php).Nov 26 2015, 4:17 PM

jcrespo removed a project: WMF-General-or-Unknown.Nov 26 2015, 4:19 PM

This instrumentation that caused this (PageContentSaveComplete) has since been removed per T177101. The query in question came from User::getEditCount, which has also been improved since to generally not permit large ad-hoc row counts like this, given persistent storage in user_editcount.

Krinkle edited projects, added Performance-Team; removed Performance Issue.Oct 29 2021, 10:59 PM

A long-running query is done on the master (WikimediaEventsHooks.php)Closed, ResolvedPublicActions

Description

Related Objects

Event Timeline

A long-running query is done on the master (WikimediaEventsHooks.php)
Closed, ResolvedPublic
Actions