From a5f27b2960a7430429c64b18b58a82adc3c0f858 Mon Sep 17 00:00:00 2001 From: Chad Horohoe Date: Thu, 26 Jun 2008 20:38:26 +0000 Subject: [PATCH] (bug 13438) Make Special:MIMESearch less expensive. Needs some benchmarking to see if it's enough saving to remove it from the "is expensive special page" list. --- maintenance/archives/patch-index-img_mime.sql | 6 ++++++ maintenance/tables.sql | 6 ++++-- maintenance/updaters.inc | 1 + 3 files changed, 11 insertions(+), 2 deletions(-) create mode 100644 maintenance/archives/patch-index-img_mime.sql diff --git a/maintenance/archives/patch-index-img_mime.sql b/maintenance/archives/patch-index-img_mime.sql new file mode 100644 index 0000000000..f808e1a518 --- /dev/null +++ b/maintenance/archives/patch-index-img_mime.sql @@ -0,0 +1,6 @@ +-- Indexing MIME types +-- +-- Allows MIME search to work on large databases like Wikimedia one + +ALTER TABLE /*$wgDBprefix*/image + ADD INDEX img_mime (img_major_mime, img_minor_mime); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 5b83983d99..d717dcc48b 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -745,9 +745,11 @@ CREATE TABLE /*$wgDBprefix*/image ( INDEX img_size (img_size), -- Used by Special:Newimages and Special:Imagelist INDEX img_timestamp (img_timestamp), + -- Used in API and duplicate search + INDEX img_sha1 (img_sha1), + -- Used in MIME search + INDEX img_mime (img_major_mime, img_minor_mime) - -- For future use - INDEX img_sha1 (img_sha1) ) /*$wgDBTableOptions*/; diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index c83893b2dc..8f5ffbbc88 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -143,6 +143,7 @@ $wgMysqlUpdates = array( array( 'maybe_do_profiling_memory_update' ), array( 'do_filearchive_indices_update' ), array( 'update_password_format' ), + array( 'add_index', 'image', 'img_mime', 'patch-index-img_mime.sql' ), ); -- 2.20.1