Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ELB simpleworkflow usage excessive #25

Open
sjones4 opened this issue Mar 3, 2018 · 0 comments
Open

ELB simpleworkflow usage excessive #25

sjones4 opened this issue Mar 3, 2018 · 0 comments

Comments

@sjones4
Copy link
Member

sjones4 commented Mar 3, 2018

ELB uses the simpleworkflow service for periodic tasks, this generates a large amount of data that is retained for a day in the simpleworkflow database. For ~20 ELBs there is over 2GB of data, which is many times all other database schemas combined.

Example showing largest two tables:

       table_schema        |              table_name          | row_estimate |   total    |   index    |   toast    |   table    
---------------------------+----------------------------------+--------------+------------+------------+------------+-----------
 eucalyptus_simpleworkflow | swf_workflow_history_event       |  6.95791e+06 | 3431 MB    | 1176 MB    | 16 MB      | 2239 MB
 eucalyptus_autoscaling    | metadata_scaling_activity_causes |       348332 | 86 MB      | 20 MB      | 8192 bytes | 67 MB

We could reduce the frequency and size (input/output) for problematic workflow activities.

@sjones4 sjones4 added this to the 4.4.4 milestone May 21, 2018
@sjones4 sjones4 removed this from the 4.4.4 milestone Jun 9, 2018
obino pushed a commit that referenced this issue Oct 24, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant