https://bugzilla.wikimedia.org/show_bug.cgi?id=61480

            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
          Assignee: wikibugs-l@lists.wikimedia.org
          Reporter: magnusman...@gmail.com
                CC: abog...@wikimedia.org, rlan...@gmail.com
       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
('Media_from_Beeld_en_Geluid_Wiki');


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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to