| Index: branches/stable/phase3/maintenance/archives/patch-list.txt |
| — | — | @@ -122,3 +122,9 @@ |
| 123 | 123 | Run patch-interwiki.sql to create the interwiki table, then the |
| 124 | 124 | plain interwiki.sql to load up the default set of mappings. |
| 125 | 125 | |
| | 126 | +* 2003-11: Indexes |
| | 127 | +Fixes up indexes on links, brokenlinks, recentchanges, watchlist, |
| | 128 | +and archive tables to boost speed. |
| | 129 | + |
| | 130 | +Run patch-indexes.sql. |
| | 131 | + |
| Index: branches/stable/phase3/maintenance/archives/patch-indexes.sql |
| — | — | @@ -0,0 +1,25 @@ |
| | 2 | +-- |
| | 3 | +-- patch-indexes.sql |
| | 4 | +-- |
| | 5 | +-- Fix up table indexes; new to stable release in November 2003 |
| | 6 | +-- |
| | 7 | + |
| | 8 | +ALTER TABLE links |
| | 9 | + DROP INDEX l_from (l_from (10)), |
| | 10 | + ADD INDEX l_from (l_from); |
| | 11 | + |
| | 12 | +ALTER TABLE brokenlinks |
| | 13 | + DROP INDEX bl_to (bl_to(10)), |
| | 14 | + ADD INDEX bl_to (bo_to); |
| | 15 | + |
| | 16 | +ALTER TABLE recentchanges |
| | 17 | + ADD INDEX rc_timestamp (rc_timestamp), |
| | 18 | + ADD INDEX rc_namespace_title (rc_namespace, rc_title), |
| | 19 | + ADD INDEX rc_cur_id (rc_cur_id); |
| | 20 | + |
| | 21 | +ALTER TABLE archive |
| | 22 | + ADD KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp); |
| | 23 | + |
| | 24 | +ALTER TABLE watchlist |
| | 25 | + ADD KEY namespace_title (wl_namespace,wl_title); |
| | 26 | + |
| Property changes on: branches/stable/phase3/maintenance/archives/patch-indexes.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 27 | + native |
| Added: svn:keywords |
| 2 | 28 | + Author Date Id Revision |