Page MenuHomePhabricator

Add index on logging.log_user_text
Closed, ResolvedPublic

Description

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

Details

Reference
bz54432

Event Timeline

bzimport raised the priority of this task from to Normal.Nov 22 2014, 2:08 AM
bzimport set Reference to bz54432.
bzimport added a subscriber: Unknown Object (MLST).
Reedy added a comment.Sep 21 2013, 7:25 PM

(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:
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

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

https://gerrit.wikimedia.org/r/85508

Do we use the "schema-change" keyword for bugs like this?

Change 85508 merged by Springle:
Add index on logging.log_user_text

https://gerrit.wikimedia.org/r/85508