← Back to team overview

openstack team mailing list archive

Re: Caching strategies in Nova ...


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?



On Fri, Mar 23, 2012 at 4:26 PM, Mark Washenberger
<mark.washenberger@xxxxxxxxxxxxx> wrote:
> "Johannes Erdfelt" <johannes@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp

Follow ups