https://bugzilla.wikimedia.org/show_bug.cgi?id=72167
Bug ID: 72167
Summary: logging table appears to have different indexes from
what vanilla MW does (e.g no type_action index)
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: tools
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
Web browser: ---
Mobile Platform: ---
I was looking at https://tools.wmflabs.org/tools-info/optimizer.py It appears
the logging table is missing 3 indexes that are specified by vanilla MediaWiki.
Specifically:
CREATE INDEX /*i*/type_action ON /*_*/logging (log_type, log_action,
log_timestamp);
CREATE INDEX /*i*/log_user_text_type_time ON /*_*/logging (log_user_text,
log_type, log_timestamp);
CREATE INDEX /*i*/log_user_text_time ON /*_*/logging (log_user_text,
log_timestamp);
The one in particular I wish was there right now, is the type_action index.
Additionally, it lacks the log_search table, which in MediaWiki is used to
locate log entries sometimes. (Mostly for oversight, but its used also for the
block log. I don't really need it for what I'm trying to do right now, but it
would probably be useful for somebody)
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
