logging table appears to have different indexes from what vanilla MW does (e.g no type_action index)
Closed, InvalidPublic
Actions

Assigned To

Authored By

	Bawolff
	Oct 17 2014, 12:30 AM

Description

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)

Version: unspecified
Severity: normal

Details

Reference: bz72167

Event Timeline

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:44 AM

• bzimport added a project: Toolforge.

• bzimport set Reference to bz72167.

Bawolff created this task.Oct 17 2014, 12:30 AM

coren moved this task from Backlog to Ready to be worked on on the Toolforge board.Nov 25 2014, 4:07 PM

Those indexes are available on the views with restricted rows, logging_userindex will have those incices (because it does not selectively suppress the log_user* columns, rather elides the suppressed rows entirely).

logging table appears to have different indexes from what vanilla MW does (e.g no type_action index)Closed, InvalidPublicActions

Description

Details

Event Timeline

logging table appears to have different indexes from what vanilla MW does (e.g no type_action index)
Closed, InvalidPublic
Actions