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 < [email protected]> 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 < > [email protected]> 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 <[email protected]> >> wrote: >> >>> It is in the disk_image_dynamic table >>> >>> On Thu, Apr 19, 2018 at 3:36 PM, Hari Prasanth Loganathan < >>> [email protected]> 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 >>>> [email protected] >>>> http://lists.ovirt.org/mailman/listinfo/users >>>> >>>> >>> >> > _______________________________________________ > Users mailing list > [email protected] > http://lists.ovirt.org/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
