Hi Mark, what workload and what setup do you have while you are profiling? e.g. how many compute nodes do you have, how many VMs do you have, are you creating/destroying/migrating VMs, volumes, networks?
Thanks, Yun On Fri, Mar 23, 2012 at 4:26 PM, Mark Washenberger <mark.washenber...@rackspace.com> wrote: > > > "Johannes Erdfelt" <johan...@erdfelt.com> said: > >> >> MySQL isn't exactly slow and Nova doesn't have particularly large >> tables. It looks like the slowness is coming from the network and how >> many queries are being made. >> >> Avoiding joins would mean even more queries, which looks like it would >> slow it down even further. >> > > This is exactly what I saw in my profiling. More complex queries did > still seem to take longer than less complex ones, but it was a second > order effect compared to the overall volume of queries. > > I'm not sure that network was the culprit though, since my ping > roundtrip time was small relative to the wall time I measured for each > nova.db.api call. > > > _______________________________________________ > Mailing list: https://launchpad.net/~openstack > Post to : openstack@lists.launchpad.net > Unsubscribe : https://launchpad.net/~openstack > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp