diff options
Diffstat (limited to 'extensions/CheckUser/archives')
-rw-r--r-- | extensions/CheckUser/archives/patch-cu_changes_indexes.sql | 11 | ||||
-rw-r--r-- | extensions/CheckUser/archives/patch-cu_changes_indexes2.sql | 7 |
2 files changed, 18 insertions, 0 deletions
diff --git a/extensions/CheckUser/archives/patch-cu_changes_indexes.sql b/extensions/CheckUser/archives/patch-cu_changes_indexes.sql new file mode 100644 index 00000000..9c81058f --- /dev/null +++ b/extensions/CheckUser/archives/patch-cu_changes_indexes.sql @@ -0,0 +1,11 @@ +-- Improves indexes for better peformance with large result sets +-- vim: autoindent syn=mysql sts=2 sw=2 +-- Replace /*$wgDBprefix*/ with the proper prefix + +ALTER TABLE /*$wgDBprefix*/cu_changes + ADD INDEX cuc_ip_hex_time (cuc_ip_hex,cuc_timestamp), + ADD INDEX cuc_user_ip_time (cuc_user,cuc_ip,cuc_timestamp), + ADD INDEX cuc_xff_hex_time (cuc_xff_hex,cuc_timestamp), + DROP INDEX cuc_ip_hex, + DROP INDEX cuc_xff_hex, + DROP INDEX cuc_user; diff --git a/extensions/CheckUser/archives/patch-cu_changes_indexes2.sql b/extensions/CheckUser/archives/patch-cu_changes_indexes2.sql new file mode 100644 index 00000000..645962ba --- /dev/null +++ b/extensions/CheckUser/archives/patch-cu_changes_indexes2.sql @@ -0,0 +1,7 @@ +-- Improves indexes for better peformance with large result sets +-- vim: autoindent syn=mysql sts=2 sw=2 +-- Replace /*$wgDBprefix*/ with the proper prefix + +ALTER TABLE /*$wgDBprefix*/cu_changes + ADD INDEX cuc_user_ip_time (cuc_user,cuc_ip,cuc_timestamp), + DROP INDEX cuc_user_time; |