Last modified: 2013-12-19 15:57:14 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 T56432, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 54432 - Add index on logging.log_user_text
Add index on logging.log_user_text
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
: schema-change
Depends on:
Blocks: 49188 54404 58691
  Show dependency treegraph
 
Reported: 2013-09-21 16:43 UTC by Jackmcbarn
Modified: 2013-12-19 15:57 UTC (History)
3 users (show)

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


Attachments

Description Jackmcbarn 2013-09-21 16:43:33 UTC
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
Comment 1 Jackmcbarn 2013-09-21 17:01:16 UTC
See also https://gerrit.wikimedia.org/r/#/c/85436/
Comment 2 Sam Reed (reedy) 2013-09-21 19:25:58 UTC
(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
Comment 3 Gerrit Notification Bot 2013-09-21 21:02:18 UTC
Change 85508 had a related patch set uploaded by Jackmcbarn:
Add index on logging.log_user_text

https://gerrit.wikimedia.org/r/85508
Comment 4 MZMcBride 2013-09-22 06:22:40 UTC
Do we use the "schema-change" keyword for bugs like this?
Comment 5 Gerrit Notification Bot 2013-12-19 03:18:15 UTC
Change 85508 merged by Springle:
Add index on logging.log_user_text

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

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


Navigation
Links