[Wikidata-bugs] [Maniphest] [Commented On] T181401: Wikidata is slow on ToolForge

[Legoktm]

Legoktm added a comment.

This is what the query looks like in production, I killed the SELECT after waiting 5 seconds, so "under a second" does not seem reasonable for Toolforge.

mysql:wikiadmin@db1110 [wikidatawiki]> EXPLAIN SELECT 1 FROM wb_items_per_site WHERE ips_site_page='Harrington Place, Stellenbosch' AND ips_site_id != 'enwiki'; 
+------+-------------+-------------------+-------+-----------------------+-----------------------+---------+------+----------+--------------------------+
| id   | select_type | table             | type  | possible_keys         | key                   | key_len | ref  | rows     | Extra                    |
+------+-------------+-------------------+-------+-----------------------+-----------------------+---------+------+----------+--------------------------+
|    1 | SIMPLE      | wb_items_per_site | index | wb_ips_item_site_page | wb_ips_item_site_page | 346     | NULL | 59534791 | Using where; Using index |
+------+-------------+-------------------+-------+-----------------------+-----------------------+---------+------+----------+--------------------------+
1 row in set (0.00 sec)

TASK DETAIL

https://phabricator.wikimedia.org/T181401

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Legoktm
Cc: Legoktm, Dispenser, Aklapper, Lahi, Gq86, GoranSMilovanovic, Chicocvenancio, QZanden, Tbscho, Freddy2001, Vali.matei, JJMC89, TerraCodes, Volker_E, Luke081515, Wikidata-bugs, aude, GWicke, Gryllida, jayvdb, scfc, coren, Mbch331, Jay8g, Krenair, chasemp

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs