https://bugzilla.wikimedia.org/show_bug.cgi?id=54107
Web browser: ---
Bug ID: 54107
Summary: SQL queries on replica tables take much longer than on
the Toolserver
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: tools
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
Classification: Unclassified
Mobile Platform: ---
Some SQL queries on the replica tables take much longer than on the Toolserver.
For example, this query for the first edit of a user takes 0.01 sec on the
Toolserver and 49.08 sec on Tool Labs (for dewiki_p):
select rev_timestamp from revision where rev_user=336793 order by rev_timestamp
asc limit 1;
This is critical for tools as `stimmberechtigung` that checks the right to vote
of a user in the German Wikipedia (Toolserver:
toolserver.org/~stimmberechtigung/, Labs:
tools.wmflabs.org/stimmberechtigung/). While it runs very fast on the
Toolserver, it takes several minutes to load it on Labs.
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
