Open Stack

Hi again

after rebooting all my three controllers, now "ceilometer statistics" 
works, but I'm worried about the time it takes to do the job:

time ceilometer statistics -q "timestamp>2016-06-01" -m vcpus
+--------+---------------------+----------------------------+-----+-----+---------------+------+-------+------------+----------------------------+----------------------------+
| Period | Period Start        | Period End                 | Max | Min 
| Avg           | Sum  | Count | Duration   | Duration Start             
| Duration End               |
+--------+---------------------+----------------------------+-----+-----+---------------+------+-------+------------+----------------------------+----------------------------+
| 0      | 2016-06-01T00:00:00 | 2016-06-30T13:00:56.394000 | 4.0 | 1.0 
| 1.28571428571 | 81.0 | 63    | 578920.533 | 2016-06-23T20:12:15.861000 
| 2016-06-30T13:00:56.394000 |
+--------+---------------------+----------------------------+-----+-----+---------------+------+-------+------------+----------------------------+----------------------------+

real    0m24.516s
user    0m0.423s
sys    0m0.077s


24sec!!  (We are only running some instances.....less than 20 in total)

Questions:
- How can I improve mongoDB in order to improve this?
- How can I configure ceilometer-api in order to wait > 60 sec for mongodb?


Thanks
J.

On 30/06/16 10:18, magicboiz at hotmail.com wrote:
> Hi there
>
> I'm facing a strange ceilometer-api behavior. While I can query 
> ceilometer-api for "meter-list"/"sample-list" (or even openstack usage 
> show) very fast, it looks like ceilometer cli (or api) struggles with 
> "ceilometer statistics" gettting always a timeout
>
> [user1 at ubuntu ~]$ ceilometer statistics -q 
> "project=6294315f9df1491fa9345701d2642c96;timestamp>2016-06-20T14:30" 
> -m vcpus --period 60
> b'Gateway Timeout (HTTP 504)'
>
> Would you happen to know why? Any idea/clue?
>
> Thanks.
> J
>
> [user1 at ubuntu ~]$ time openstack usage show
> Usage from 2016-06-02 to 2016-07-01 on project 
> 6294315f9df1491fa9345701d2642c96:
> +---------------+-----------+
> | Field         | Value     |
> +---------------+-----------+
> | CPU Hours     | 164.21    |
> | Disk GB-Hours | 16420.51  |
> | RAM MB-Hours  | 168146.07 |
> | Servers       | 1         |
> +---------------+-----------+
> real    0m2.204s
> user    0m1.490s
> sys    0m0.113s
>
>
>
>
> [user1 at ubuntu ~]$ time ceilometer meter-list
> +---------------------------------+------------+-----------+-----------------------------------------------------------------------+----------------------------------+----------------------------------+
> | Name                            | Type       | Unit      | Resource 
> ID                                                           | User 
> ID                          | Project ID                       |
> +---------------------------------+------------+-----------+-----------------------------------------------------------------------+----------------------------------+----------------------------------+
> | cpu                             | cumulative | ns        | 
> 5c305833-fbd2-44cb-b517-789641c2a5db | 
> eb12445c73ae4093b7c7105ebe3f1216 | 6294315f9df1491fa9345701d2642c96 |
> | cpu.delta                       | delta      | ns        | 
> 5c305833-fbd2-44cb-b517-789641c2a5db | 
> eb12445c73ae4093b7c7105ebe3f1216 | 6294315f9df1491fa9345701d2642c96 |
> .............
> | vcpus                           | gauge      | vcpu      | 
> 5c305833-fbd2-44cb-b517-789641c2a5db | 
> eb12445c73ae4093b7c7105ebe3f1216 | 6294315f9df1491fa9345701d2642c96 |
> +---------------------------------+------------+-----------+-----------------------------------------------------------------------+----------------------------------+----------------------------------+
>
> real    0m2.088s
> user    0m0.897s
> sys    0m0.057s
>
>
>
>
> [user1 at ubuntu ~]$ time ceilometer sample-list -q 
> "timestamp>2016-06-1T00:00"
> +--------------------------------------+-----------------------------------------------------------------------+---------------------------------+------------+------------------------+-----------+----------------------------+
> | ID                                   | Resource 
> ID                                                           | 
> Name                            | Type       | Volume                 
> | Unit      | Timestamp |
> +--------------------------------------+-----------------------------------------------------------------------+---------------------------------+------------+------------------------+-----------+----------------------------+
> | e81ed112-3e99-11e6-b12c-52540086048d | 
> 6294315f9df1491fa9345701d2642c96 | storage.objects.containers      | 
> gauge      | 0.0                    | container | 
> 2016-06-30T08:09:02.663000 |
> ......
> | 9b50bb52-3e99-11e6-90d4-52540086048d | 
> instance-000002d6-5c305833-fbd2-44cb-b517-789641c2a5db-tapdefa1d28-b5 
> | network.outgoing.packets.gb     | cumulative | 
> 2.654269337654114e-07  | gb        | 2016-06-30T08:06:53.700000 |
> +--------------------------------------+-----------------------------------------------------------------------+---------------------------------+------------+------------------------+-----------+----------------------------+
>
> real    0m2.373s
> user    0m0.977s
> sys    0m0.073s
>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20160630/05788c0b/attachment.html>