From 4e4b11a620da54c62a2f1f33f8ee43a5099b9f5b Mon Sep 17 00:00:00 2001 From: Aaron Date: Wed, 11 Apr 2012 13:11:07 -0700 Subject: [PATCH] [FileBackend] Simplified fj_batch_id index If we want to sort the ops for a batch ID, we can just use a tiny to small filesort. No need to make the index bigger. Change-Id: Ibf7592930ec633a26e675e33d42aebe7763547b1 --- maintenance/archives/patch-filejournal.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/maintenance/archives/patch-filejournal.sql b/maintenance/archives/patch-filejournal.sql index 8c2f6b95c8..114297c6d8 100644 --- a/maintenance/archives/patch-filejournal.sql +++ b/maintenance/archives/patch-filejournal.sql @@ -18,5 +18,5 @@ CREATE TABLE /*_*/filejournal ( fj_timestamp varbinary(14) NOT NULL default '' ); -CREATE INDEX /*i*/fj_batch_id ON /*_*/filejournal (fj_batch_uuid,fj_id); +CREATE INDEX /*i*/fj_batch_id ON /*_*/filejournal (fj_batch_uuid); CREATE INDEX /*i*/fj_timestamp ON /*_*/filejournal (fj_timestamp); -- 2.20.1