Changes between Initial Version and Version 1 of REDCap Customisation Cron History Indexes

Timestamp:

01/09/16 10:50:44 (8 years ago)

Author:

Richard Bramley

Comment:

--

REDCap Customisation Cron History Indexes

@@ +1 @@
+= REDCap Customisation Cron History Indexes
+
+Tags: [[REDCap]] [[Customisation_Category]]
+
+I noticed that the briccsDbDev was running at 100% CPU.  The cause was that the REDCap cron job was checking cron history every minute and the history table was massive and there weren't appropriate indexes.  So I created those indexes in both live, test and external:
+
+{{{
+#!sql
+
+CREATE INDEX redcap_crons_history_cron_id_cron_run_status ON redcap_crons_history (cron_id, cron_run_status);
+CREATE INDEX redcap_crons_history_cron_id_cron_run_start ON redcap_crons_history (cron_id, cron_run_start);
+
+}}}
+
+[[BackLinks]]