Last modified: 2014-10-17 00:30:41 UTC
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)