<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>