yahoo-eng-team team mailing list archive

[Piotr Misiak <piotr.misiak@xxxxxxxxxxx>]

Public bug reported:

I have a very slow network list response time when i add --shared false parameter to neutron cli command. Look at this: http://paste.openstack.org/show/584409/
without --shared False argument I've got response in 2 seconds
with --shared False argument I've got response in 32 seconds

I debugged a little bit and I see that database returns over 182000 records which is 200MB of data but there are only 4000 unique records.
There are more or less 45 duplicates for every unique record and I have 45 records in neutron RBAC so I see a correlation here.

The issue is quite important because Horizon uses the request with
shared=false to show up the "Launch Instance" form and it takes ages.

I have 127 neutron networks in my env.
I use Midonet plugin.

Here you have a SQL query which returns over 182000 records:
http://paste.openstack.org/show/584642/
SQL query result is filtered by neutron-server (100% CPU) an produces only a few networks in the response.

This is stable/mitaka version installed from source.

** Affects: neutron
     Importance: Undecided
         Status: New

** Description changed:

  I have a very slow network list response time when i add --shared false parameter to neutron cli command. Look at this: http://paste.openstack.org/show/584409/
  without --shared False argument I've got response in 2 seconds
  with --shared False argument I've got response in 32 seconds
  
  I debugged a little bit and I see that database returns over 182000 records which is 200MB of data but there are only 4000 unique records.
  There are more or less 45 duplicates for every unique record and I have 45 records in neutron RBAC so I see a correlation here.
  
  The issue is quite important because Horizon uses the request with
  shared=false to show up the "Launch Instance" form and it takes ages.
  
  I have 127 neutron networks in my env.
  I use Midonet plugin.
  
  Here you have a SQL query which returns over 182000 records:
  http://paste.openstack.org/show/584642/
  SQL query result is filtered by neutron-server (100% CPU) an produces only a few networks in the response.
+ 
+ This is stable/mitaka version installed from source.

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1630939

Title:
  Very slow net-list command with --shared=false argument

Status in neutron:
  New

Bug description:
  I have a very slow network list response time when i add --shared false parameter to neutron cli command. Look at this: http://paste.openstack.org/show/584409/
  without --shared False argument I've got response in 2 seconds
  with --shared False argument I've got response in 32 seconds

  I debugged a little bit and I see that database returns over 182000 records which is 200MB of data but there are only 4000 unique records.
  There are more or less 45 duplicates for every unique record and I have 45 records in neutron RBAC so I see a correlation here.

  The issue is quite important because Horizon uses the request with
  shared=false to show up the "Launch Instance" form and it takes ages.

  I have 127 neutron networks in my env.
  I use Midonet plugin.

  Here you have a SQL query which returns over 182000 records:
  http://paste.openstack.org/show/584642/
  SQL query result is filtered by neutron-server (100% CPU) an produces only a few networks in the response.

  This is stable/mitaka version installed from source.

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