Improve performance for MySQL with update stats command

diff --git a/bacula/src/cats/make_mysql_tables.in b/bacula/src/cats/make_mysql_tables.in
index 7fc01b3126e13d8d66cfcdee26c6fd2e66280bee..9fcd97ee904e85db89f449e6a6ea719e0c1cbc4a 100644 (file)
--- a/bacula/src/cats/make_mysql_tables.in
+++ b/bacula/src/cats/make_mysql_tables.in
@@ -181,6 +181,7 @@ CREATE TABLE JobHisto (
    HasCache TINYINT DEFAULT 0,
    Reviewed TINYINT DEFAULT 0,
    Comment BLOB,
+   INDEX (JobId),
    INDEX (StartTime)
    );
 

diff --git a/bacula/src/cats/update_mysql_tables.in b/bacula/src/cats/update_mysql_tables.in
index 22db77c3f4a125a800015986b3a9488da443441d..f1b5e16463cfc413b7c00035c0e7924b2a9de0e0 100644 (file)
--- a/bacula/src/cats/update_mysql_tables.in
+++ b/bacula/src/cats/update_mysql_tables.in
@@ -42,6 +42,8 @@ CREATE TABLE RestoreObject (
    INDEX (JobId)
 );
 
+CREATE INDEX jobhisto_jobid_idx ON JobHisto (JobId);
+
 DELETE FROM Version;
 INSERT INTO Version (VersionId) VALUES (13);