maintenance/archives/patch-backlinkindexes.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

-- 
-- patch-backlinkindexes.sql
-- 
-- Per bug 6440 / http://bugzilla.wikimedia.org/show_bug.cgi?id=6440
--
-- Improve performance of the "what links here"-type queries
-- 

ALTER TABLE /*$wgDBprefix*/pagelinks
   DROP INDEX pl_namespace,
   ADD INDEX pl_namespace(pl_namespace, pl_title, pl_from);

ALTER TABLE /*$wgDBprefix*/templatelinks
   DROP INDEX tl_namespace,
   ADD INDEX tl_namespace(tl_namespace, tl_title, tl_from);
   
ALTER TABLE /*$wgDBprefix*/imagelinks
   DROP INDEX il_to,
   ADD INDEX il_to(il_to, il_from);