Bug 1379462 - Upgrade to 4.1.1 - Performance issues [NEEDINFO]
Summary: Upgrade to 4.1.1 - Performance issues
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Performance
Version: 5.6.0
Hardware: x86_64
OS: Linux
medium
high
Target Milestone: GA
: 5.7.0
Assignee: Keenan Brock
QA Contact: Jan Krocil
URL:
Whiteboard:
: 1378991 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-09-26 19:45 UTC by Colin Arnott
Modified: 2020-02-14 17:57 UTC (History)
8 users (show)

Fixed In Version: 5.7.0.7
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-01-04 13:01:11 UTC
Category: ---
Cloudforms Team: CFME Core
Target Upstream Version:
carnott: needinfo? (carnott)


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2017:0012 0 normal SHIPPED_LIVE CFME 5.7.0 bug fixes and enhancement update 2017-01-04 17:50:36 UTC

Description Colin Arnott 2016-09-26 19:45:06 UTC
Description of problem:
I've completed the upgrade to CF 4.1. The major issue at the moment is performance is not great. Selecting compute -> infra -> VM's takes 20-25 seconds to load.

I think there needs to be some major maintenance on our DB. The table vim_performance_states took 30 mins to backup alone. Please consider this a high priority item. Logs to follow.

Version-Release number of selected component (if applicable):
cfme-5.6.1.2

How reproducible:
this env: reproducible


Additional info:
- puma changes applied: "threads 1,1"
current potential RCAs:
- no continuous maintenance scripts running; just finished reindexing miq_queue and miq_workers, waiting for feedback on improvement
- 98000 public AWS temaplates: provider is disabled and these need to be cleaned off manually
- other

Comment 2 Nick Carboni 2016-09-26 20:06:19 UTC
Changing component to the performance team.

Comment 3 dmetzger 2016-09-29 14:17:13 UTC
*** Bug 1378991 has been marked as a duplicate of this bug. ***

Comment 7 Keenan Brock 2016-10-10 14:04:25 UTC
I've wired up the core of this, and it will become available with https://github.com/ManageIQ/manageiq/pull/11387

98k templates does seem a little big.

Comment 8 CFME Bot 2016-10-21 21:50:47 UTC
New commit detected on ManageIQ/manageiq/euwe:
https://github.com/ManageIQ/manageiq/commit/cc51e1f19cb5d4bb9891759a9ee950a81f4be3a9

commit cc51e1f19cb5d4bb9891759a9ee950a81f4be3a9
Author:     Jason Frey <fryguy9>
AuthorDate: Thu Oct 20 16:43:16 2016 -0400
Commit:     Oleg Barenboim <chessbyte>
CommitDate: Fri Oct 21 17:45:53 2016 -0400

    Merge pull request #11387 from ZitaNemeckova/remove_vms_tree
    
    Add option to hide VMs in trees
    (cherry picked from commit 421542727dff6d28906a04dc8caa360cc3c0ed91)
    
    https://bugzilla.redhat.com/show_bug.cgi?id=1379462

 app/assets/javascripts/miq_tree.js               |   1 +
 app/controllers/configuration_controller.rb      |   2 +
 app/controllers/vm_cloud_controller.rb           |   5 +-
 app/controllers/vm_common.rb                     |  62 ++++++++++++--
 app/controllers/vm_infra_controller.rb           |   5 +-
 app/helpers/ui_constants.rb                      |   3 +-
 app/presenters/tree_builder.rb                   |  16 ++++
 app/presenters/tree_builder_archived.rb          |  14 +--
 app/presenters/tree_builder_images.rb            |   5 +-
 app/presenters/tree_builder_instances.rb         |  14 ++-
 app/presenters/tree_builder_vandt.rb             |  15 +---
 app/presenters/tree_builder_vms_and_templates.rb |  18 ++--
 app/views/configuration/_ui_2.html.haml          |  16 ++++
 app/views/layouts/_tree.html.haml                |  10 ++-
 spec/controllers/vm_common_spec.rb               |  86 +++++++++++++++++++
 spec/presenters/tree_builder_archived_spec.rb    | 103 +++++++++++++++++++++++
 spec/presenters/tree_builder_images_spec.rb      |  58 +++++++++++++
 spec/presenters/tree_builder_instances_spec.rb   |  78 +++++++++++++++++
 spec/presenters/tree_builder_spec.rb             |  29 +++++++
 19 files changed, 491 insertions(+), 49 deletions(-)
 create mode 100644 spec/presenters/tree_builder_archived_spec.rb
 create mode 100644 spec/presenters/tree_builder_images_spec.rb
 create mode 100644 spec/presenters/tree_builder_instances_spec.rb

Comment 13 errata-xmlrpc 2017-01-04 13:01:11 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHBA-2017-0012.html


Note You need to log in before you can comment on or make changes to this bug.