Page MenuHomePhabricator

DB replication results are slow.
Closed, ResolvedPublic

Description

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
    )

Version: unspecified
Severity: normal

Details

Reference
bz73420

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 3:58 AM
bzimport added a project: Toolforge.
bzimport set Reference to bz73420.

At the moment, the query returns 14231 rows in set (2.81 sec). That looks alright to me.