Ladsgroup added a comment.
So fun fact, the given doesn't de-duplicate entities. This needs to be fixed,
After de-duplication, it's 655 which is better.
For the whole thing, the handler stats are:
| Variable_name | Value |
| Handler_commit | 1 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_external_lock | 0 |
| Handler_icp_attempts | 36780 |
| Handler_icp_match | 36780 |
| Handler_mrr_init | 0 |
| Handler_mrr_key_refills | 0 |
| Handler_mrr_rowid_refills | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 0 |
| Handler_read_key | 76717 |
| Handler_read_last | 0 |
| Handler_read_next | 36780 |
| 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_update | 0 |
| Handler_tmp_write | 0 |
| Handler_update | 0 |
| Handler_write | 0 |
|
for the batch of 50: ordered and deduplicated:
```lang=mysql
SELECT /*
Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsResolver::selectTermsViaJoin
*/ wbtl_id, wbtl_type_id, wbxl_language, wbx_text, wbit_item_id FROM
`wbt_term_in_lang`, `wbt_text_in_lang`, `wbt_text`, `wbt_item_terms` WHERE
(wbtl_text_in_lang_id=wbxl_id) AND (wbxl_text_id=wbx_id) AND wbit_item_id IN
(15, 41, 96, 114, 117, 148, 155, 159, 183, 244, 252, 258, 467, 577, 657, 668,
801, 833, 843, 865, 902, 916, 928, 953, 962, 1009, 1020, 1032, 1033, 1065,
3542, 3787, 4412, 4917, 6256, 6655, 7159, 7502, 7785, 7809, 7825, 8441, 8449,
8475, 8673, 9043, 9051, 11191, 11229, 14005) AND wbxl_language IN ('hu', 'en')
AND (`wbit_term_in_lang_id` = wbtl_id)
The handler stats are:
| Variable_name | Value |
| Handler_commit | 1 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_external_lock | 0 |
| Handler_icp_attempts | 15581 |
| Handler_icp_match | 15581 |
| Handler_mrr_init | 0 |
| Handler_mrr_key_refills | 0 |
| Handler_mrr_rowid_refills | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 0 |
| Handler_read_key | 31665 |
| Handler_read_last | 0 |
| Handler_read_next | 15581 |
| 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_update | 0 |
| Handler_tmp_write | 0 |
| Handler_update | 0 |
| Handler_write | 0 |
|
For the batch of 20:
SELECT /*
Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsResolver::selectTermsViaJoin
*/ wbtl_id, wbtl_type_id, wbxl_language, wbx_text, wbit_item_id FROM
`wbt_term_in_lang`, `wbt_text_in_lang`, `wbt_text`, `wbt_item_terms` WHERE
(wbtl_text_in_lang_id=wbxl_id) AND (wbxl_text_id=wbx_id) AND wbit_item_id IN
(15, 41, 96, 114, 117, 148, 155, 159, 183, 244, 252, 258, 467, 577, 657, 668,
801, 833, 843, 865) AND wbxl_language IN ('hu', 'en') AND
(`wbit_term_in_lang_id` = wbtl_id)
The handler stats are:
| Variable_name | Value |
| Handler_commit | 1 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_external_lock | 0 |
| Handler_icp_attempts | 8330 |
| Handler_icp_match | 8330 |
| Handler_mrr_init | 0 |
| Handler_mrr_key_refills | 0 |
| Handler_mrr_rowid_refills | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 0 |
| Handler_read_key | 16897 |
| Handler_read_last | 0 |
| Handler_read_next | 8330 |
| 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_update | 0 |
| Handler_tmp_write | 0 |
| Handler_update | 0 |
| Handler_write | 0 |
|
And for the batch of ten:
SELECT /*
Wikibase\Lib\Store\Sql\Terms\DatabaseTermInLangIdsResolver::selectTermsViaJoin
*/ wbtl_id, wbtl_type_id, wbxl_language, wbx_text, wbit_item_id FROM
`wbt_term_in_lang`, `wbt_text_in_lang`, `wbt_text`, `wbt_item_terms` WHERE
(wbtl_text_in_lang_id=wbxl_id) AND (wbxl_text_id=wbx_id) AND wbit_item_id IN
(15, 41, 96, 114, 117, 148, 155, 159, 183, 244) AND wbxl_language IN ('hu',
'en') AND (`wbit_term_in_lang_id` = wbtl_id)
The handler stats are:
| Variable_name | Value |
| Handler_commit | 1 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_external_lock | 0 |
| Handler_icp_attempts | 4441 |
| Handler_icp_match | 4441 |
| Handler_mrr_init | 0 |
| Handler_mrr_key_refills | 0 |
| Handler_mrr_rowid_refills | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 0 |
| Handler_read_key | 8999 |
| Handler_read_last | 0 |
| Handler_read_next | 4441 |
| 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_update | 0 |
| Handler_tmp_write | 0 |
| Handler_update | 0 |
| Handler_write | 0 |
|
TASK DETAIL
https://phabricator.wikimedia.org/T246159
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Ladsgroup
Cc: jcrespo, Marostegui, Aklapper, ArielGlenn, Addshore, WMDE-leszek,
Ladsgroup, Hazizibinmahdi, Beast1978, Un1tY, Hook696, Daryl-TTMG, RomaAmorRoma,
E.S.A-Sheild, Iflorez, darthmon_wmde, alaa_wmde, Meekrab2012, joker88john,
CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22,
Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Af420, Darkminds3113, Bsandipan,
Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden,
LawExplorer, WSH1906, Lewizho99, Maathavan, _jensen, rosalieper, Scott_WUaS,
Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
