Last modified: 2007-11-17 11:01:22 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 11387 - Checkuser perfomance issues
Checkuser perfomance issues
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
All All
: Normal enhancement (vote)
: ---
Assigned To: Aaron Schulz
Depends on:
  Show dependency treegraph
Reported: 2007-09-18 18:52 UTC by Aaron Schulz
Modified: 2007-11-17 11:01 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

performance tweaks (17.65 KB, patch)
2007-09-18 18:53 UTC, Aaron Schulz

Description Aaron Schulz 2007-09-18 18:52:17 UTC
I've made some proposed modifications to checkuser:

1) Altered the index on cuc_user,cuc_timestamp to cuc_user,cuc_ip,cuc_timestamp. This lets "get ips" show all IPs (rather than limiting to avoid timeouts) and only needs to read off the index.

2) The other check types now scan how many rows there are that match the criteria (for range scans only). If there are too many, it bails out to avoid a huge filesort (that still gives an incomplete result set) and list the IPs with edits in the range, to let the user do more specific checks. One the one hand, this makes overhead itself, but on the other, if tuned right, it can avoid nasty timeouts that happen on some /16 ranges. At least knowing the IPs with edits in there helps to narrow down scans.
Comment 1 Aaron Schulz 2007-09-18 18:53:19 UTC
Created attachment 4128 [details]
performance tweaks
Comment 2 Aaron Schulz 2007-11-17 11:01:22 UTC
Done in r27262, live.

Note You need to log in before you can comment on or make changes to this bug.