From 40119c8e37b699bfb0a4f142dfc870ec21600c15 Mon Sep 17 00:00:00 2001
From: Domas Mituzas <midom@users.mediawiki.org>
Date: Sat, 10 Oct 2009 09:14:51 +0000
Subject: [PATCH] adding partial job_param to job_cmd index

---
 maintenance/tables.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index a139280031..314dcbb919 100644
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -1185,7 +1185,7 @@ CREATE TABLE /*_*/job (
   job_params blob NOT NULL
 ) /*$wgDBTableOptions*/;
 
-CREATE INDEX /*i*/job_cmd ON /*_*/job (job_cmd, job_namespace, job_title);
+CREATE INDEX /*i*/job_cmd ON /*_*/job (job_cmd, job_namespace, job_title, job_params(128));
 
 
 -- Details of updates to cached special pages
-- 
2.20.1