获取zabbix数据

 

获取主机hostid
select * from hosts where host='redis-1000001'

Memory usage
##总内存
select itemid,name from items where hostid=10636;
| 43574 | 可用内存量 |
| 43575 | Total memory |
| 43576 | 内存使用率

获取使用率
select avg(value)
from history_uint
where itemid=43576
and from_unixtime(clock)>='2024-12-04 13:00:00'
and from_unixtime(clock) <'2024-12-04 13:10:00';

select avg(value)
from history_uint
where itemid=43576
and clock>= unix_timestamp('2024-12-04 13:00:00')
and clock < unix_timestamp('2024-12-04 13:10:00');

select *
from history_uint t where itemid=43576 order by clock desc limit 10;

 

获取已使用内存
select
round((select round(value/1024/1024/1024,1)
from history_uint t
where itemid=43575 order by clock desc limit 1) *
(select value*0.01
from history_uint t
where itemid=43576 order by clock desc limit 1),1) as "mem_used"

 

关联表获取

 

select 
from_unixtime(clock),
value
from history_uint a
inner join items b
  on a.itemid = b.itemid
inner join hosts c
  on b.hostid = c.hostid
where c.host='redis-A'
  and b.name = '内存使用率'
order by clock desc limit 10;