Short description:
Add an index on logging.log_user_text to allow quick searching for log entries based on this field (for IP addresses specifically, since their userid is always 0)
Which wikis are affected:
All
Which tables:
logging
What is the change to those tables:
Add an index on the log_user_text field
Links to gerrit changes and/or other related bug reports.
Bug #54404
Version: unspecified
Severity: enhancement
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T60956 Feedback must show up in watchlists | |||
| Open | None | T46377 Use Special:Log properly | |||
| Resolved | None | T58839 AFT5: log by user should support IPs | |||
| Resolved | None | T56404 Anonymous users' log entries cannot be filtered for with their IP address | |||
| Invalid | None | T51188 [DO NOT USE] Schema changes for Wikimedia wikis (tracking) [superseded by #Blocked-on-schema-change] | |||
| Resolved | None | T60691 API: Allow search by ip for list=logevents | |||
| Resolved | None | T56432 Add index on logging.log_user_text |
(In reply to comment #0)
Short description:
Add an index on logging.log_user_text to allow quick searching for log
entries
based on this field (for IP addresses specifically, since their userid is
always 0)Which wikis are affected:
AllWhich tables:
loggingWhat is the change to those tables:
Add an index on the log_user_text fieldLinks to gerrit changes and/or other related bug reports.
Bug #54404
This needs to be done MediaWiki side, and then once there's a patchset for it (optionally after it's been merged), then a bug for adding it to Wikimedia can be done
Change 85508 had a related patch set uploaded by Jackmcbarn:
Add index on logging.log_user_text