https://bugzilla.wikimedia.org/show_bug.cgi?id=16112
Brion Vibber <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
AssignedTo|wikibugs- |[EMAIL PROTECTED]
|[EMAIL PROTECTED] |
--- Comment #3 from Brion Vibber <[EMAIL PROTECTED]> 2008-12-09 23:20:49 UTC
---
Trevor -- couple quick notes on this:
This action can be done via an existing maintenance script:
php maintenance/refreshLinks.php --dfn-only
However, the implementation (deleteLinksFromNonexistent() in refreshLinks.inc)
isn't currently feasible for Wikimedia's use because it's a potentially very
slow query, which can mess with our DB replication and disrupt the site for
users until the slave databases catch up.
Currently it's doing a single DELETE per table to clear out all matching rows.
I'd recommend breaking this out into two parts for each table:
1) SELECT the relevant page ID numbers (those for which no page record exists).
2) DELETE the matching rows from the link table, preferably in batches. (One at
a time means it'll be very slow if there are many results; doing all at once
means we might disrupt replication or hit SQL limits.)
Once the function's cleaned up we can go ahead and run it on the live sites.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
