<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hi again<br>
    <br>
    after rebooting all my three controllers, now "ceilometer
    statistics" works, but I'm worried about the time it takes to do the
    job:<br>
    <br>
    <font size="-2">time ceilometer statistics -q
      "timestamp>2016-06-01" -m vcpus<br>
+--------+---------------------+----------------------------+-----+-----+---------------+------+-------+------------+----------------------------+----------------------------+<br>
      | Period | Period Start        | Period End                 | Max
      | Min | Avg           | Sum  | Count | Duration   | Duration
      Start             | Duration End               |<br>
+--------+---------------------+----------------------------+-----+-----+---------------+------+-------+------------+----------------------------+----------------------------+<br>
      | 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 |<br>
+--------+---------------------+----------------------------+-----+-----+---------------+------+-------+------------+----------------------------+----------------------------+<br>
      <br>
      real    0m24.516s<br>
      user    0m0.423s<br>
      sys    0m0.077s</font><br>
    <br>
    <br>
    24sec!!  (We are only running some instances.....less than 20 in
    total)<br>
    <br>
    Questions:<br>
    - How can I improve mongoDB in order to improve this?<br>
    - How can I configure ceilometer-api in order to wait > 60 sec
    for mongodb?<br>
    <br>
    <br>
    Thanks<br>
    J.<br>
    <br>
    <div class="moz-cite-prefix">On 30/06/16 10:18,
      <a class="moz-txt-link-abbreviated" href="mailto:magicboiz@hotmail.com">magicboiz@hotmail.com</a> wrote:<br>
    </div>
    <blockquote
      cite="mid:BLU437-SMTP108ACD32CEF0365A3412DC6B0240@phx.gbl"
      type="cite">
      <meta http-equiv="content-type" content="text/html; charset=utf-8">
      Hi there<br>
      <br>
      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<br>
      <br>
      <font size="-2">[user1@ubuntu ~]$ ceilometer statistics -q
        "project=6294315f9df1491fa9345701d2642c96;timestamp>2016-06-20T14:30"
        -m vcpus --period 60<br>
        b'Gateway Timeout (HTTP 504)'</font><br>
      <br>
      Would you happen to know why? Any idea/clue?<br>
      <br>
      Thanks.<br>
      J<br>
      <br>
      <font size="-2">[user1@ubuntu ~]$ time openstack usage show<br>
        Usage from 2016-06-02 to 2016-07-01 on project
        6294315f9df1491fa9345701d2642c96: <br>
        +---------------+-----------+<br>
        | Field         | Value     |<br>
        +---------------+-----------+<br>
        | CPU Hours     | 164.21    |<br>
        | Disk GB-Hours | 16420.51  |<br>
        | RAM MB-Hours  | 168146.07 |<br>
        | Servers       | 1         |<br>
        +---------------+-----------+<br>
        real    0m2.204s<br>
        user    0m1.490s<br>
        sys    0m0.113s<br>
        <br>
        <br>
        <br>
        <br>
        [user1@ubuntu ~]$ time ceilometer meter-list<br>
+---------------------------------+------------+-----------+-----------------------------------------------------------------------+----------------------------------+----------------------------------+<br>
        | Name                            | Type       | Unit      |
        Resource
        ID                                                           |
        User ID                          | Project
        ID                       |<br>
+---------------------------------+------------+-----------+-----------------------------------------------------------------------+----------------------------------+----------------------------------+<br>
        | cpu                             | cumulative | ns        |
        5c305833-fbd2-44cb-b517-789641c2a5db                                 
        | eb12445c73ae4093b7c7105ebe3f1216 |
        6294315f9df1491fa9345701d2642c96 |<br>
        | cpu.delta                       | delta      | ns        |
        5c305833-fbd2-44cb-b517-789641c2a5db                                 
        | eb12445c73ae4093b7c7105ebe3f1216 |
        6294315f9df1491fa9345701d2642c96 |<br>
        .............<br>
        | vcpus                           | gauge      | vcpu      |
        5c305833-fbd2-44cb-b517-789641c2a5db                                 
        | eb12445c73ae4093b7c7105ebe3f1216 |
        6294315f9df1491fa9345701d2642c96 |<br>
+---------------------------------+------------+-----------+-----------------------------------------------------------------------+----------------------------------+----------------------------------+<br>
        <br>
        real    0m2.088s<br>
        user    0m0.897s<br>
        sys    0m0.057s<br>
        <br>
        <br>
        <br>
        <br>
        [user1@ubuntu ~]$ time ceilometer sample-list -q
        "timestamp>2016-06-1T00:00"<br>
+--------------------------------------+-----------------------------------------------------------------------+---------------------------------+------------+------------------------+-----------+----------------------------+<br>
        | ID                                   | Resource
        ID                                                           |
        Name                            | Type       |
        Volume                 | Unit      | Timestamp                 
        |<br>
+--------------------------------------+-----------------------------------------------------------------------+---------------------------------+------------+------------------------+-----------+----------------------------+<br>
        | e81ed112-3e99-11e6-b12c-52540086048d |
        6294315f9df1491fa9345701d2642c96                                     
        | storage.objects.containers      | gauge      |
        0.0                    | container | 2016-06-30T08:09:02.663000
        |<br>
        ......<br>
        | 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
        |<br>
+--------------------------------------+-----------------------------------------------------------------------+---------------------------------+------------+------------------------+-----------+----------------------------+<br>
        <br>
        real    0m2.373s<br>
        user    0m0.977s<br>
        sys    0m0.073s</font><br>
      <br>
      <br>
      <br>
    </blockquote>
    <br>
  </body>
</html>