yahoo-eng-team team mailing list archive

[Joe Gordon <1212428@xxxxxxxxxxxxxxxxxx>]

** Changed in: nova
       Status: In Progress => Fix Released

-- 
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/1212428

Title:
  compute_node_get_all slow as molasses

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  compute_node_get_all() joins compute_node_stats and with a large
  number of compute nodes and a moderate number of stats entries per
  compute node, this is extremely slow.

  http://paste.openstack.org/show/44162/
  http://paste.openstack.org/show/44143/

  I believe the problem stems from the fact that each compute node stat
  is contained in its own row.  With 16K compute nodes and 'x' stats
  being kept per node, that translates into 16*x rows being returned
  from sql server.

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