[ovirt-users] Any monitoring tool provided?
Vincent Royer
vincent at epicenergy.ca
Wed Mar 28 18:35:22 UTC 2018
Shirly,
Sorry it took so long to reply.
The issue I found was that the code for the variables required single
quotes around some of the fields, such as this one:
WHERE datacenter_id ='$datacenter_id'
without the single quotes I was getting errors.
*Vincent Royer*
*778-825-1057*
<http://www.epicenergy.ca/>
*SUSTAINABLE MOBILE ENERGY SOLUTIONS*
On Sun, Mar 25, 2018 at 4:44 AM, Shirly Radco <sradco at redhat.com> wrote:
> Hi Vincent,
>
>
> I'm sorry it was not an easy setup.
>
> Can you please share what did not work for you in the instructions? I see
> you did manage to get it working... :)
>
> If you want data from the last 24 hours in 60 seconds interval (Still not
> real time but can give you a better granularity),
> You can use the samples tables.
>
> Also, Please make sure to update your* views prefix *to the version you
> are using, In the example prefix is * v4_2_**
> *If you are using oVirt 4.1, prefix should be ** v4_1_**
>
> For example: (Did not get to test this query yet)
>
> SELECT DISTINCT
> min(time) AS time,
> MEM_Usage,
> host_name || 'MEM_Usage' as metric
> FROM (
> SELECT
> stats_hosts.host_id,
> CASE
> WHEN delete_date IS NULL
> THEN host_name
> ELSE
> host_name
> ||
> ' (Removed on '
> ||
> CAST ( CAST ( delete_date AS date ) AS varchar )
> ||
> ')'
> END AS host_name,
> stats_hosts.history_datetime AS time,
> SUM (
> COALESCE (
> stats_hosts.cpu_usage_percent,
> 0
> ) *
> COALESCE (
> stats_hosts.minutes_in_status,
> 0
> )
> ) /
> SUM (
> COALESCE (
> stats_hosts.minutes_in_status,
> 0
> )
> ) AS CPU_Usage,
> SUM (
> COALESCE (
> stats_hosts.memory_usage_percent,
> 0
> ) *
> COALESCE (
> stats_hosts.minutes_in_status,
> 0
> )
> ) /
> SUM (
> COALESCE (
> stats_hosts.minutes_in_status,
> 0
> )
> ) AS MEM_Usage
> FROM* v4_2_statistics_hosts_resources_usage_samples* AS stats_hosts
> INNER JOIN v4_2_configuration_history_hosts
> ON (
> v4_2_configuration_history_hosts.host_id =
> stats_hosts.host_id
> )
> WHERE stats_hosts.history_datetime >= $__timeFrom()
> AND stats_hosts.history_datetime < $__timeTo()
> -- Here we get the latest hosts configuration
> AND v4_2_configuration_history_hosts.history_id IN (
> SELECT MAX ( a.history_id )
> FROM v4_2_configuration_history_hosts AS a
> GROUP BY a.host_id
> )
> AND stats_hosts.host_id IN (
> SELECT a.host_id
> FROM* v4_2_statistics_hosts_resources_usage_samples* a
> INNER JOIN v4_2_configuration_history_hosts b
> ON ( a.host_id = b.host_id )
> WHERE
> -- Here we filter by active hosts only
> a.host_status = 1
> -- Here we filter by the datacenter chosen by the user
> AND b.cluster_id IN (
> SELECT v4_2_configuration_history_clusters.cluster_id
> FROM v4_2_configuration_history_clusters
> WHERE
> v4_2_configuration_history_clusters.datacenter_id
> =
> $datacenter_id
> )
> -- Here we filter by the clusters chosen by the user
> AND b.cluster_id IN ($cluster_id)
> AND a. history_datetime >= $__timeFrom()
> AND a.history_datetime < $__timeTo()
> -- Here we get the latest hosts configuration
> AND b.history_id IN (
> SELECT MAX (g.history_id)
> FROM v4_2_configuration_history_hosts g
> GROUP BY g.host_id
> )
> GROUP BY a.host_id
> ORDER BY
> -- Hosts will be ordered according to the summery of
> -- memory and CPU usage percent.
> --This determines the busiest hosts.
> SUM (
> COALESCE (
> a.memory_usage_percent * a.minutes_in_status,
> 0
> )
> ) /
> SUM (
> COALESCE (
> a.minutes_in_status,
> 0
> )
> ) +
> SUM (
> COALESCE (
> a.cpu_usage_percent * a.minutes_in_status,
> 0
> )
> ) /
> SUM (
> COALESCE (
> a.minutes_in_status,
> 0
> )
> ) DESC
> LIMIT 5
> )
> GROUP BY
> stats_hosts.host_id,
> host_name,
> delete_date,
> history_datetime
> ) AS a
> GROUP BY a.host_name, a.mem_usage
> ORDER BY time
>
> --
>
> SHIRLY RADCO
>
> BI SeNIOR SOFTWARE ENGINEER
>
> Red Hat Israel <https://www.redhat.com/>
> <https://red.ht/sig>
> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
>
> On Thu, Mar 22, 2018 at 9:05 PM, Vincent Royer <vincent at epicenergy.ca>
> wrote:
>
>> I setup Grafana using the instructions I found on accessing the Ovirt
>> history database. However, the instructions didn't work as written.
>> Regardless, it does work, but it's not easy to setup. The update rate also
>> leaves something to be desired, its ok for historical info, but it's not a
>> good real time monitoring solution (although its possible I could set it up
>> differently and it would work better)
>>
>> Also using Grafana, I have setup Telegraf agents on most of my VMs.
>>
>> Lastly, I also installed Telegraf on the Centos hosts in my Ovirt Cluster
>>
>>
>>
>>
>>
>>
>> *Vincent Royer*
>> *778-825-1057 <(778)%20825-1057>*
>>
>>
>> <http://www.epicenergy.ca/>
>> *SUSTAINABLE MOBILE ENERGY SOLUTIONS*
>>
>>
>>
>>
>> On Wed, Mar 21, 2018 at 8:41 PM, Terry hey <recreationh at gmail.com> wrote:
>>
>>> Dear all,
>>>
>>> Now, we can just read how many storage used, cpu usage on ovirt
>>> dashboard.
>>> But is there any monitoring tool for monitoring virtual machine time to
>>> time?
>>> If yes, could you guys give me the procedure?
>>>
>>>
>>> Regards
>>> Terry
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at ovirt.org
>>> http://lists.ovirt.org/mailman/listinfo/users
>>>
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180328/3b1c3180/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 68566 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180328/3b1c3180/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 145730 bytes
Desc: not available
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180328/3b1c3180/attachment-0001.png>
More information about the Users
mailing list