Last modified: 2007-11-17 11:01:22 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.
Created attachment 4128 [details]
Done in r27262, live.