cron spam from mwmaint1002
Closed, InvalidPublic
Actions

Assigned To

None

Authored By

	• Mathew.onipe
	Dec 6 2018, 3:09 AM

Description

Cron <www-data@mwmaint1002> /usr/local/bin/foreachwikiindblist /srv/mediawiki/dblists/pageassessments.dblist extensions/PageAssessments/maintenance/purgeUnusedProjects.php > /dev/null

[Wed Dec  5 20:42:15 2018] [hphp] [133116:7fd4650313c0:0:000001] [] SlowTimer [12813ms] at runtime/ext_mysql: slow query: SELECT /* Wikimedia\Rdbms\Database::select www-data@mwmain... */  DISTINCT( pa_project_id )  FROM `page_assessments`

Adding the DBA team to this. Its smells like some slow connection/slow query as well.

Related Objects

Mentioned Here: T208231: Issues with purgeUnusedProjects.php cron job on mwmaint1002 (Fri Oct 26, 2018)

Event Timeline

• Mathew.onipe created this task.Dec 6 2018, 3:09 AM

Restricted Application added a project: Community-Tech. · View Herald TranscriptDec 6 2018, 3:09 AM

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

• Mathew.onipe added projects: DBA, MediaWiki-libs-Rdbms.Dec 6 2018, 3:10 AM

• Mathew.onipe updated the task description. (Show Details)

I'll take a look into this

• Banyek updated the task description. (Show Details)Dec 6 2018, 1:20 PM

I checked the query

SELECT /* Wikimedia\Rdbms\Database::select www-data@mwmain... */  DISTINCT( pa_project_id )  FROM `page_assessments

Based on the file /srv/mediawiki/dblists/pageassessments.dblist the enwiki, enwikivoyage, testwiki databases were used. Here are the results. I don't know which database would be queried this way but I was supposing vslow.

host	db	section	results
db1106	enwiki	s1	3009 rows in set (3.30 sec)
db1113:3315	enwikivoyage	s5	11 rows in set (0.07 sec)
db1123	testwiki	s3	3 rows in set (0.04 sec)

enwiki wasn't fast, but 3 seconds is way better than 12

• Banyek moved this task from Triage to Backlog on the DBA board.Dec 6 2018, 1:34 PM

This is a duplicate of T208231

MusikAnimal moved this task from Ready to Done on the MediaWiki-extensions-PageAssessments board.Jan 11 2019, 2:03 AM

cron spam from mwmaint1002Closed, InvalidPublicActions

Description

Related Objects

Event Timeline

cron spam from mwmaint1002
Closed, InvalidPublic
Actions