Marostegui added a comment.
The only common query I have found that executes on all hosts is:
SELECT /*
Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsResolver::selectTermsViaJoin
141.136.76.164 */ wbtl_id, wbtl_type_id, wbxl_language, wbx_text,
wbpt_property_id FROM `wbt_term_in_lang` JOIN `wbt_text_in_lang` ON
((wbtl_text_in_lang_id=wbxl_id)) JOIN `wbt_text` ON ((wbxl_text_id=wbx_id))
JOIN `wbt_property_terms` ON ((`wbpt_term_in_lang_id` = wbtl_id)) WHERE
wbtl_type_id = 1 AND wbxl_language = 'lez'
This query does increase the `read_key` and `read_next` which handlers, which
are the ones spiking on the graphs:
root@db2081.codfw.wmnet[wikidatawiki]> FLUSH STATUS; pager cat > /dev/null;
Query OK, 0 rows affected (0.032 sec)
PAGER set to 'cat > /dev/null'
root@db2081.codfw.wmnet[wikidatawiki]> SELECT /*
Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsResolver::selectTermsViaJoin
4 */ wbtl_id, wbtl_type_id, wbxl_language, wbx_text, wbpt_property_id FROM
`wbt_term_in_lang` JOIN `wbt_text_in_lang` ON ((wbtl_text_in_lang_id=wbxl_id))
JOIN `wbt_text` ON ((wbxl_text_id=wbx_id)) JOIN `wbt_property_terms` ON
((`wbpt_term_in_lang_id` = wbtl_id)) WHERE wbtl_type_id = 1 AND wbxl_language =
'lez' ; nopager;
14 rows in set (1.781 sec)
PAGER set to stdout
root@db2081.codfw.wmnet[wikidatawiki]> SHOW STATUS like 'Hand%';
+----------------------------+--------+
| Variable_name | Value |
+----------------------------+--------+
| Handler_commit | 1 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_external_lock | 0 |
| Handler_icp_attempts | 0 |
| Handler_icp_match | 0 |
| Handler_mrr_init | 0 |
| Handler_mrr_key_refills | 0 |
| Handler_mrr_rowid_refills | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 1 |
| Handler_read_key | 531005 |
| Handler_read_last | 0 |
| Handler_read_next | 364794 |
| Handler_read_prev | 0 |
| Handler_read_retry | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_deleted | 0 |
| Handler_read_rnd_next | 0 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_tmp_delete | 0 |
| Handler_tmp_update | 0 |
| Handler_tmp_write | 0 |
| Handler_update | 0 |
| Handler_write | 0 |
+----------------------------+--------+
27 rows in set (0.033 sec)
The rest of slow queries I can see are mostly related to `watchlist`and
`IndexPager::buildQueryInfo` which only arrives to special slaves, but from
what I have seen, those spikes happens on all hosts, so I guess they can be
discarded.
TASK DETAIL
https://phabricator.wikimedia.org/T264821
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Marostegui
Cc: Addshore, Ladsgroup, RLazarus, Marostegui, Aklapper, CDanis, LSobanski,
lmata, wkandek, JMeybohm, Akuckartz, Iflorez, darthmon_wmde, Legado_Shulgin,
Nandana, jijiki, Davinaclare77, Qtn1293, Techguru.pc, Lahi, Gq86,
GoranSMilovanovic, Th3d3v1ls, Hfbn0, QZanden, LawExplorer, Minhnv-2809, Zppix,
_jensen, rosalieper, Scott_WUaS, Wong128hk, Wikidata-bugs, aude, faidon,
Mbch331, Rxy, Jay8g, Krenair, fgiunchedi, Dzahn
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
