https://bugzilla.wikimedia.org/show_bug.cgi?id=73420
Bug ID: 73420
Summary: DB replication results are slow. Act as if there are
no indexes.
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: tools
Assignee: m...@uberbox.org
Reporter: cybernet...@yahoo.com
CC: benap...@gmail.com, t...@tim-landscheidt.de
Web browser: ---
Mobile Platform: ---
Lately, the DB has required several tens of seconds to supply the results of a
query that took about 2 seconds in the past.
Here's an example:
[1] => Array
(
[time] => 18.95
[query] => SELECT rev_timestamp,
page_title, page_namespace FROM revision_userindex JOIN page ON page_id =
rev_page WHERE (`rev_user` = '14836860') AND `rev_timestamp` > 1 ORDER BY
rev_timestamp ASC LIMIT 0,2688354;
[result] => succeeded
)
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
