<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On 09/07/2013, at 2:53 AM, John Griffith <<a href="mailto:john.griffith@solidfire.com">john.griffith@solidfire.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr"><div class="gmail_default" style="font-family:courier new,monospace"><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Jul 7, 2013 at 5:43 PM, Sam Morrison <span dir="ltr"><<a href="mailto:sorrison@gmail.com" target="_blank">sorrison@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
I'm wondering if anyone is using cinder and is having issue with the list volumes API call.<br>
<br>
We have a grizzly install and we're at about 160 active volumes in cinder at the moment.<br>
<br>
To do "cinder list" with a tenant that has about 140 volumes it takes about 6 seconds.<br>
API calls on a specific volume are done in about 0.1 seconds so I'm happy with the API servers, it's the code I'm worried about.<br>
<br>
Doing a "cinder list --all-tenants" as an admin it takes about 20 seconds.<br>
<br>
Looking at the code it seems as an admin it will iterate over every volume 3 times and do a db requests on each volume.<br>
As a normal user it iterates over every volume once.<br>
<br>
The for loops are for adding glance image information and as an admin it also adds host and tenant information which is in the same table so it's a bit strange that it's doing more DB calls.<br>
<br>
Does anyone use cinder with more that just a couple of active volumes and if so how do they when requests are so slow?<br>
We have 36 cinder-api servers handling requests and they aren't under significant load. Also our DB cluster is handling things fine.<br>
<br>
Cheers,<br>
Sam<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Mailing list: <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
Post to : <a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
Unsubscribe : <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br></blockquote><div> </div></div><div class="gmail_default" style="font-family:courier new,monospace">Hi Sam,<br>
</div><div class="gmail_default" style="font-family:courier new,monospace">Definitely some things in this area that cause problems at scale, I'm not sure exactly where you're looking at in terms of the loops?<br>
<br>
</div><div class="gmail_default" style="font-family:courier new,monospace">We did recently submit a bug fix [1] related to some of this, but I don't think it covers the case you're describing and it has NOT been backported to Grizzly.<br>
<br></div><div class="gmail_default" style="font-family:courier new,monospace">If you'd like to point me specifically to the loops your describing I'm happy to take a look and see if we can fix this up.<br><br>Thanks,<br>
</div><div class="gmail_default" style="font-family:courier new,monospace">John<br><br>[1] <a href="http://tinyurl.com/jwgpxpr">http://tinyurl.com/jwgpxpr</a><br><br></div><br></div></div>
</blockquote><br></div><div>Hi John,</div><div><br></div><div>We opened a bug about this: </div><div><br></div><div><a href="https://bugs.launchpad.net/cinder/+bug/1197612">https://bugs.launchpad.net/cinder/+bug/1197612</a></div><div><br></div><div>Cheers,</div><div>Sam</div><div><br></div><div><br></div><br></body></html>