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