for posterity yes the info isn't hard to find in the database: mysql> select id,vcpus,vcpus_used,memory_mb,memory_mb_used from compute_nodes;
I'm not terribly keen on SQL as an interface, guess if it bothers me enough I'll implement a different interface... On Wed, Jul 11, 2012 at 10:34 PM, Jonathan Proulx <j...@jonproulx.com> wrote: > On Wed, Jul 11, 2012 at 8:58 PM, Chris Behrens <cbehr...@codestud.com> wrote: >> Hi Jon, >> >> There's actually a review up right now proposing to add an OS API extension >> to be able to give some of this data: >> >> https://review.openstack.org/#/c/9544/ > > that seems to be based on quota limits where as I'm look for just now > is over all physical limits for all users. > >> I don't know how you may be looking to query it, but it's not too difficult >> to get it directly from the instances table in the database, either. > > I guess I'm looking for something like: > > eucalyptus-describe-availibility-zones verbose > AVAILABILITYZONE |- vm types free / max cpu ram disk > AVAILABILITYZONE |- m1.small 0000 / 0000 1 128 2 > AVAILABILITYZONE |- c1.medium 0000 / 0000 1 256 5 > AVAILABILITYZONE |- m1.large 0000 / 0000 2 512 10 > AVAILABILITYZONE |- m1.xlarge 0000 / 0000 2 1024 20 > AVAILABILITYZONE |- c1.xlarge 0000 / 0000 4 2048 20 > > (well not with the zeros, but it's the first example I could find) > > where with euca2ools and openstack I get essentially the output of > 'nova-manage service list' which is useful but not for the same > things. Guess I'll dig into the database shouldn't be too hard to get > close to what I want, the eucalyptus output also takes into account > fragmentation, which is nice since if I have 100 free cpu slots but on > 100 different compute nodes I'm in a bit more trouble than if they are > only spread across 10 since in the later case multicore instances can > start (for a while anyway). > > Thanks, > -Jon _______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
