* (bug 22744) Add/Update indexes for queries done by the API

Add index to logging table accross log_type and log_action

diff --git a/includes/installer/MysqlUpdater.php b/includes/installer/MysqlUpdater.php
index 093593f..35c59b4 100644 (file)
--- a/includes/installer/MysqlUpdater.php
+++ b/includes/installer/MysqlUpdater.php
@@ -181,10 +181,11 @@ class MysqlUpdater extends DatabaseUpdater {
                        array( 'doUserNewTalkTimestampNotNull' ),
                        array( 'addIndex', 'user',          'user_email',       'patch-user_email_index.sql' ),
                        array( 'modifyField', 'user_properties', 'up_property', 'patch-up_property.sql' ),
-                       array( 'addTable', 'uploadstash', 'patch-uploadstash.sql' ),
+                       array( 'addTable', 'uploadstash',                       'patch-uploadstash.sql' ),
 
                        // 1.19
-                       array( 'addTable', 'config', 'patch-config.sql' ),
+                       array( 'addTable', 'config',                            'patch-config.sql' ),
+                       array( 'addIndex', 'logging',       'type_action',      'patch-logging-type-action-index.sql')
                );
        }
 

diff --git a/maintenance/archives/patch-logging-type-action-index.sql b/maintenance/archives/patch-logging-type-action-index.sql
new file mode 100644 (file)
index 0000000..c5b921e
--- /dev/null
+++ b/maintenance/archives/patch-logging-type-action-index.sql
@@ -0,0 +1 @@
+CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action);

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 90326d4..fa8d657 100644 (file)
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -1226,6 +1226,7 @@ CREATE INDEX /*i*/page_time ON /*_*/logging (log_namespace, log_title, log_times
 CREATE INDEX /*i*/times ON /*_*/logging (log_timestamp);
 CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, log_type, log_timestamp);
 CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp);
+CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action);
 
 
 CREATE TABLE /*_*/log_search (