2:13 a.m.
May I ask what are you trying to achieve? Why not use the oVirt REST API?
Y.
On Fri, Apr 20, 2018, 8:57 AM Hari Prasanth Loganathan <
hariprasanth.l(a)msystechnologies.com> wrote:
How frequently is the 'disk_all table' is updated with new
statistics?
On Fri, Apr 20, 2018 at 11:15 AM, Hari Prasanth Loganathan <
hariprasanth.l(a)msystechnologies.com> wrote:
> How is the disk id mapped to this table : disk_image_dynamic table?
>
> If I need statistics of all the disk, How can I get it?
>
> On Thu, Apr 19, 2018 at 10:15 PM, Benny Zlotnik <bzlotnik(a)redhat.com>
> wrote:
>
>> It is in the disk_image_dynamic table
>>
>> On Thu, Apr 19, 2018 at 3:36 PM, Hari Prasanth Loganathan <
>> hariprasanth.l(a)msystechnologies.com> wrote:
>>
>>> Hi Team,
>>>
>>> I am trying to get the disk level statistics using oVirt with the
>>> following API,
>>>
>>> /ovirt-engine/api/disks/{unique_disk_id}/statistics/
>>>
>>>
>>> *and I get this response : *
>>> {
>>> "statistic": [
>>> {
>>> "kind": "gauge",
>>> "type": "decimal",
>>> "unit": "bytes_per_second",
>>> "values": {
>>> "value": [
>>> {
>>> "datum": 0
>>> }
>>> ]
>>> },
>>> "disk": {
>>> "href":
>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",
>>> "id":
"a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>> },
>>> * "name": "data.current.read",*
>>> "description": "Read data rate",
>>> "href":
>>>
"/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/33b9212b-f9cb-3fd0-b364-248fb61e1272",
>>> "id": "33b9212b-f9cb-3fd0-b364-248fb61e1272"
>>> },
>>> {
>>> "kind": "gauge",
>>> "type": "decimal",
>>> "unit": "bytes_per_second",
>>> "values": {
>>> "value": [
>>> {
>>> "datum": 0
>>> }
>>> ]
>>> },
>>> "disk": {
>>> "href":
>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",
>>> "id":
"a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>> },
>>> * "name": "data.current.write",*
>>> "description": "Write data rate",
>>> "href":
>>>
"/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/2f23addd-4ebd-3d82-a449-c28778bc33eb",
>>> "id": "2f23addd-4ebd-3d82-a449-c28778bc33eb"
>>> },
>>> {
>>> "kind": "gauge",
>>> "type": "decimal",
>>> "unit": "seconds",
>>> "values": {
>>> "value": [
>>> {
>>> "datum": 0
>>> }
>>> ]
>>> },
>>> "disk": {
>>> "href":
>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",
>>> "id":
"a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>> },
>>> * "name": "disk.read.latency",*
>>> "description": "Read latency",
>>> "href":
>>>
"/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/3a7b3f72-d035-3bb9-b196-e86a4eb34993",
>>> "id": "3a7b3f72-d035-3bb9-b196-e86a4eb34993"
>>> },
>>> {
>>> "kind": "gauge",
>>> "type": "decimal",
>>> "unit": "seconds",
>>> "values": {
>>> "value": [
>>> {
>>> "datum": 0
>>> }
>>> ]
>>> },
>>> "disk": {
>>> "href":
>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",
>>> "id":
"a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>> },
>>> * "name": "disk.write.latency",*
>>> "description": "Write latency",
>>> "href":
>>>
"/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/b1e75c7b-cea4-37d2-8459-f7d68efc69a3",
>>> "id": "b1e75c7b-cea4-37d2-8459-f7d68efc69a3"
>>> },
>>> {
>>> "kind": "gauge",
>>> "type": "decimal",
>>> "unit": "seconds",
>>> "values": {
>>> "value": [
>>> {
>>> "datum": 0
>>> }
>>> ]
>>> },
>>> "disk": {
>>> "href":
>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",
>>> "id":
"a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>> },
>>> "name": "disk.flush.latency",
>>> "description": "Flush latency",
>>> "href":
>>>
"/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/9c17ad7b-9ef1-3e8d-ad0a-ff8bee3925f0",
>>> "id": "9c17ad7b-9ef1-3e8d-ad0a-ff8bee3925f0"
>>> }
>>> ]
>>> }
>>>
>>> I am able to get the disk write and read latency, write and read
>>> bandwidth.
>>>
>>>
>>> *But I am not able to find the postgresql tables used for these
>>> statistics in oVirt? *
>>> *Could somebody let me know the statistics table for the disk?*
>>>
>>> Any help is much Appreciated.
>>>
>>> Thanks,
>>> Harry
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users(a)ovirt.org
>>> http://lists.ovirt.org/mailman/listinfo/users
>>>
>>>
>>
>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users