yahoo-eng-team team mailing list archive

[Lin Hua Cheng <1383556@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Simple tenant usage eventually calls to
nova.db.sqlalchemy.api.instance_get_active_by_window_joined() to fetch
the instance usage for the period selected.

For the retrieved instances, the method pulls the instance metadata and
system_metadata information as well.

https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L2164

This incurs an additional call to the database to fetch data that is not
used for the computation of usage.

https://github.com/openstack/nova/blob/master/nova/api/openstack/compute/contrib/simple_tenant_usage.py#L148-L213

** Affects: nova
     Importance: Undecided
     Assignee: Lin Hua Cheng (lin-hua-cheng)
         Status: New

** Changed in: nova
     Assignee: (unassigned) => Lin Hua Cheng (lin-hua-cheng)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1383556

Title:
  Simple tenant usage is slow due to unnecessary joins

Status in OpenStack Compute (Nova):
  New

Bug description:
  Simple tenant usage eventually calls to
  nova.db.sqlalchemy.api.instance_get_active_by_window_joined() to fetch
  the instance usage for the period selected.

  For the retrieved instances, the method pulls the instance metadata
  and system_metadata information as well.

  https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L2164

  This incurs an additional call to the database to fetch data that is
  not used for the computation of usage.

  https://github.com/openstack/nova/blob/master/nova/api/openstack/compute/contrib/simple_tenant_usage.py#L148-L213

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1383556/+subscriptions