Rundeck performance on 'Activity for this Job' pages #1547

Open
jds86930 opened this Issue Nov 12, 2015 · 5 comments

Comments

Projects
None yet
5 participants
@jds86930

Our rundeck instance has a lot of jobs & a lot of executions ('execution' table is about 1 million rows large). We were noticing that performance got really slow on some pages, such as the 'Activity for this Job' pages. We were able to improve page load time quite a lot by adding the indexes listed below. These indexes were successfully applied on a MySQL 5.6.23 database. I wanted to post them here in case they can help anyone else out, or in case the developers want to integrate them into rundeck.

create index WORKFLOW_STEP__ID on workflow_step(id);
create index WORKFLOW_WORKFLOW_STEP__WORKFLOW_COMMANDS_ID on workflow_workflow_step(workflow_commands_id);
create index EXECUTION__PROJECT__DATE_COMPLETED on execution(project, date_completed);
create index EXECUTION__DATE_COMPLETED__SCHEDULED_EXECUTION_ID on execution(date_completed, scheduled_execution_id);
create index BASE_REPORT__CLASS__JC_JOB_ID__CTX_PROJECT on base_report(class, jc_job_id, ctx_project);

@jimr6007

This comment has been minimized.

Show comment
Hide comment
@jimr6007

jimr6007 Apr 20, 2016

I have been using http://rundeck.org/2.6.3/api/index.html#delete-an-execution
to cleanup my stuff but I also have 1 million plus rows in workflow and friends tables

I ended up here for the same reason, super slow "Activity for this Job" tabs on the UI

very annoying when you want to look at the last 10 executions for a job.

Any advice from the Rundeck people ?

Thanks !

I have been using http://rundeck.org/2.6.3/api/index.html#delete-an-execution
to cleanup my stuff but I also have 1 million plus rows in workflow and friends tables

I ended up here for the same reason, super slow "Activity for this Job" tabs on the UI

very annoying when you want to look at the last 10 executions for a job.

Any advice from the Rundeck people ?

Thanks !

@jds86930

This comment has been minimized.

Show comment
Hide comment
@jds86930

jds86930 Apr 21, 2016

Haven't seen any followup on it from the rundeck devs. We're still successfully using the indexes listed in the original post, which cut the time down by 10x for us. It'd be nice if they'd integrate that into rundeck (or otherwise optimize the queries and/or data model), but at least this isn't crippling us anymore.

Haven't seen any followup on it from the rundeck devs. We're still successfully using the indexes listed in the original post, which cut the time down by 10x for us. It'd be nice if they'd integrate that into rundeck (or otherwise optimize the queries and/or data model), but at least this isn't crippling us anymore.

@truppert

This comment has been minimized.

Show comment
Hide comment
@truppert

truppert Jan 4, 2017

This is awesome! I also saw a huge increase in speed by applying these. The Rundeck folks should really integrate this.

truppert commented Jan 4, 2017

This is awesome! I also saw a huge increase in speed by applying these. The Rundeck folks should really integrate this.

@nickrowlandboxuk

This comment has been minimized.

Show comment
Hide comment
@nickrowlandboxuk

nickrowlandboxuk Feb 16, 2017

We're running version 2.6.4-1 of Rundeck. Is this still an issue the current version?

Thanks for sharing this fix. We've seen a massive improvement in page load speed.

We're running version 2.6.4-1 of Rundeck. Is this still an issue the current version?

Thanks for sharing this fix. We've seen a massive improvement in page load speed.

@zsoca8711

This comment has been minimized.

Show comment
Hide comment
@zsoca8711

zsoca8711 Aug 11, 2017

We have applied these indexes too on our Rundeck 2.7.3-1 and the improvement is massive.

We have applied these indexes too on our Rundeck 2.7.3-1 and the improvement is massive.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment