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

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T13387, the corresponding Phabricator task for complete and up-to-date bug report information.
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.