Bug ID: 61480
           Summary: commonswiki globalimagelinks table slow
           Product: Wikimedia Labs
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Infrastructure
       Web browser: ---
   Mobile Platform: ---

A simple SQL query that used to run in seconds now hangs around until it fails
with a server timeout.

First noticed on 2014-02-17, but may have appeared earlier.

Example query:

SELECT globalimagelinks.* FROM globalimagelinks,page,categorylinks WHERE
gil_to=page_title AND cl_from=page_id AND page_namespace=6 AND cl_to IN

Maybe a dropped index somewhere? Or related to the recent nfs fails?

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

Reply via email to