r47887 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r47886‎ | r47887 | r47888 >
Date:04:11, 28 February 2009
Author:aaron
Status:ok
Tags:
Comment:
Tweak proposed change: add user_type_time index, since these queries are starting to slow down for some users
Modified paths:
  • /trunk/phase3/maintenance/archives/patch-log_user_text.sql (modified) (history)

Diff [purge]

Index: trunk/phase3/maintenance/archives/patch-log_user_text.sql
——@@ -3,3 +3,5 @@
44 ADD log_target_id int unsigned NULL,
55 CHANGE `log_type` `log_type` VARBINARY( 15 ) NOT NULL,
66 CHANGE `log_action` `log_action` VARBINARY( 15 ) NOT NULL;
 7+
 8+CREATE INDEX /*i*/user_type_time ON /*_*/logging (log_user, log_type, log_timestamp);

Status & tagging log