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

       Web browser: ---
            Bug ID: 56041
           Summary: updateCollation.php script prohibitively slow
           Product: MediaWiki
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Maintenance scripts
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected], [email protected],
                    [email protected]
    Classification: Unclassified
   Mobile Platform: ---

updateCollation.php script is awfully slow. It took over a week for
fr.wp (bug 54680), it'll probably take months if we ever decide to run
it on en.wp. That kinda sucks.

I'm not sure what can be done, or if it's just a problem on WMF configuration,
or what, so I'm just filing this and asking for comments. Please resolve
as INVALID if we in fact can't do anything about this.

Possible causes:
* The workaround from bug 45970 which makes it use an index that's not
  entirely perfect for the task (but likely good enough, no idea how
  much slower that makes the script).
* Slave synchronisation, in which case maybe we can do something with
  ops involvement? Don't ask me.
* There's just too much data being sent back-and-forth between PHP and
  the database, in which case we can't do anything (unless we implement
  collating entirely database-side, which I've been told is a bad idea).

I'm CC-ing competent people. Help?

-- 
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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to