jenkins-bot has submitted this change and it was merged.
Change subject: USE INDEX(wb_epp_entity) in EntityPerPageTable::listEntities
......................................................................
USE INDEX(wb_epp_entity) in EntityPerPageTable::listEntities
MariaDB tends to use the `epp_redirect_target` key which has a very
low selectivity.
Change-Id: I0d9c6cde3f23bcd52eaad7ad9e0b0fc3aad3b9e0
---
M repo/includes/store/sql/EntityPerPageTable.php
1 file changed, 2 insertions(+), 0 deletions(-)
Approvals:
Aude: Looks good to me, approved
jenkins-bot: Verified
diff --git a/repo/includes/store/sql/EntityPerPageTable.php
b/repo/includes/store/sql/EntityPerPageTable.php
index 0fbc5d6..fd7b91d 100644
--- a/repo/includes/store/sql/EntityPerPageTable.php
+++ b/repo/includes/store/sql/EntityPerPageTable.php
@@ -390,6 +390,8 @@
__METHOD__,
array(
'ORDER BY' => $orderBy,
+ // MySQL tends to use the epp_redirect_target
key which has a very low selectivity
+ 'USE INDEX' => 'wb_epp_entity',
'LIMIT' => $limit
)
);
--
To view, visit https://gerrit.wikimedia.org/r/178526
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I0d9c6cde3f23bcd52eaad7ad9e0b0fc3aad3b9e0
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/Wikibase
Gerrit-Branch: wmf/1.25wmf11
Gerrit-Owner: Aude <aude.w...@gmail.com>
Gerrit-Reviewer: Aude <aude.w...@gmail.com>
Gerrit-Reviewer: Hoo man <h...@online.de>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
