LXC memory % in Grafana

[svenvg93]

I'm currently creating Grafana dashboards for my systems. I have one for the CPU usage in %. But i can't seem to find one for memory usage. Only memfree, memused etc.

Is this option available?

 

[svenvg93]

Anyone??

 

[dcsapak]

no this field does not exist, but you can use the memused and memfree to achieve the same thing, no?

 

[svenvg93]

I could use it. But it give me a lot of data, see screenshot. Can I calculate a percentage with this data in grafana?

 

[dcsapak]

i use a query like this:

SELECT mean("mem")/mean("maxmem") AS used FROM "system" WHERE "object" = 'qemu' OR "object" = 'lxc' AND $timeFilter GROUP BY time($__interval), "host" fill(null)

and alias by : $tag_host

afaics, you cannot do this with the graphical editor in grafana, but you can still enter the query manually

 

[svenvg93]

i use a query like this:

SELECT mean("mem")/mean("maxmem") AS used FROM "system" WHERE "object" = 'qemu' OR "object" = 'lxc' AND $timeFilter GROUP BY time($__interval), "host" fill(null)

and alias by : $tag_host

afaics, you cannot do this with the graphical editor in grafana, but you can still enter the query manually

Thanks you are a life safer!