wiki:REDCap Customisation Cron History Indexes

REDCap Customisation Cron History Indexes

Tags: REDCap Customisation_Category

I noticed that the briccsDbDev was running at 100% CPU. The cause was that the test 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:

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);

Error: Macro BackLinks(None) failed
'Environment' object has no attribute 'get_db_cnx'

Last modified 8 years ago Last modified on 01/09/16 10:53:01
Note: See TracWiki for help on using the wiki.