https://bugzilla.wikimedia.org/show_bug.cgi?id=63777
Bug ID: 63777
Summary: archive_userindex on replication server not indexed
well. Takes 10s of seconds to execute a query.
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: General
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected],
[email protected]
Web browser: ---
Mobile Platform: ---
Executing a query involving the use of ar_user is very slow.
Executing SELECT COUNT(*) AS count FROM archive_userindex WHERE `ar_user`
='14836860'; returns:
+-------+
| count |
+-------+
| 344 |
+-------+
1 row in set (16.76 sec)
Executing SELECT COUNT(*) AS count FROM archive_userindex WHERE `ar_user_text`
='Cyberpower678'; returns:
+-------+
| count |
+-------+
| 344 |
+-------+
1 row in set (0.08 sec)
Why not use ar_user_text? I have very good reasons, but it's beside the point.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
