zabbix 监控项相关表研究
zabbix 监控项相关表研究
首先套用下这个图：
监控项前端配置:
-
items表
itemid : 监控项的id
type : 监控项的type，与前端界面配置相对应
snmp_community : snmp的community
snmp_oid : snmp的oid
hostid : 监控项所在的host的hostid。如果item属于template，那么这里显示的是templateid
name : 监控项的名字
key_ : 监控项的key
delay : 监控项数据更新间隔
history : 历史数据保留时长
trends : 趋势数据保留时长
status : 监控项的状态，0是启用(enabled)，1是未启用(disabled)
value_type : 监控项返回的值类型
trapper_hosts : 配置type为zabbix trapper时允许的hosts
units : 单位
multiplier : 自定义倍数
delta : 值变化， 0表示存储值不变
snmpv3_securityname :
snmpv3_securitylevel :
snmpv3_authpassphrase :
snmpv3_privpassphrase :
formula :
error :
lastlogsize :
logtimefmt : 用于log类型中，表示时间格式
templateid :
valuemapid :
delay_flex : 例外的更新间隔
params :
ipmi_sensor :
data_type :
authtype :
username :
password :
publickey :
privatekey :
mtime :
flags :
interfaceid :
port :
description : 监控项的描述
inventory_link :
lifetime :
snmpv3_authprotocol :
snmpv3_privprotocol :
state : 状态正常与否，0(正常), 1(not support)
snmpv3_contextname :
evaltype :MariaDB [rtm]> desc items; +-----------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------------+------+-----+---------+-------+ | itemid | bigint(20) unsigned | NO | PRI | NULL | | | type | int(11) | NO | | 0 | | | snmp_community | varchar(64) | NO | | | | | snmp_oid | varchar(255) | NO | | | | | hostid | bigint(20) unsigned | NO | MUL | NULL | | | name | varchar(255) | NO | | | | | key_ | varchar(255) | NO | | | | | delay | int(11) | NO | | 0 | | | history | int(11) | NO | | 90 | | | trends | int(11) | NO | | 365 | | | status | int(11) | NO | MUL | 0 | | | value_type | int(11) | NO | | 0 | | | trapper_hosts | varchar(255) | NO | | | | | units | varchar(255) | NO | | | | | multiplier | int(11) | NO | | 0 | | | delta | int(11) | NO | | 0 | | | snmpv3_securityname | varchar(64) | NO | | | | | snmpv3_securitylevel | int(11) | NO | | 0 | | | snmpv3_authpassphrase | varchar(64) | NO | | | | | snmpv3_privpassphrase | varchar(64) | NO | | | | | formula | varchar(255) | NO | | | | | error | varchar(2048) | NO | | | | | lastlogsize | bigint(20) unsigned | NO | | 0 | | | logtimefmt | varchar(64) | NO | | | | | templateid | bigint(20) unsigned | YES | MUL | NULL | | | valuemapid | bigint(20) unsigned | YES | MUL | NULL | | | delay_flex | varchar(255) | NO | | | | | params | text | NO | | NULL | | | ipmi_sensor | varchar(128) | NO | | | | | data_type | int(11) | NO | | 0 | | | authtype | int(11) | NO | | 0 | | | username | varchar(64) | NO | | | | | password | varchar(64) | NO | | | | | publickey | varchar(64) | NO | | | | | privatekey | varchar(64) | NO | | | | | mtime | int(11) | NO | | 0 | | | flags | int(11) | NO | | 0 | | | interfaceid | bigint(20) unsigned | YES | MUL | NULL | | | port | varchar(64) | NO | | | | | description | text | NO | | NULL | | | inventory_link | int(11) | NO | | 0 | | | lifetime | varchar(64) | NO | | 30 | | | snmpv3_authprotocol | int(11) | NO | | 0 | | | snmpv3_privprotocol | int(11) | NO | | 0 | | | state | int(11) | NO | | 0 | | | snmpv3_contextname | varchar(255) | NO | | | | | evaltype | int(11) | NO | | 0 | | +-----------------------+---------------------+------+-----+---------+-------+ *************************** 1. row *************************** itemid: 30169 type: 2 snmp_community: snmp_oid: hostid: 10157 name: OSPF接口状态异常的数量 key_: get_ospf_abormal_oper_status_count delay: 300 history: 7 trends: 90 status: 0 value_type: 3 trapper_hosts: units: multiplier: 0 delta: 0 snmpv3_securityname: snmpv3_securitylevel: 0 snmpv3_authpassphrase: snmpv3_privpassphrase: formula: 1 error: lastlogsize: 0 logtimefmt: templateid: 23668 valuemapid: NULL delay_flex: params: ipmi_sensor: data_type: 0 authtype: 0 username: password: publickey: privatekey: mtime: 0 flags: 0 interfaceid: NULL port: description: CMD inventory_link: 0 lifetime: 30 snmpv3_authprotocol: 0 snmpv3_privprotocol: 0 state: 0 snmpv3_contextname: evaltype: 0 -
hosts表
hostid : host的id标识
proxy_hostid : 代理host的id标识
host : 主机的hostname
status : 主机目前的状态，0表示正常监控，1为disable，3表示是个template
disable_until :
error :
available :
errors_from :
lastaccess :
ipmi_authtype :
ipmi_privilege :
ipmi_username :
ipmi_password :
ipmi_disable_until :
ipmi_available :
snmp_disable_until :
snmp_available :
maintenanceid :
maintenance_status :
maintenance_type :
maintenance_from :
ipmi_errors_from :
snmp_errors_from :
ipmi_error :
snmp_error :
jmx_disable_until :
jmx_available :
jmx_errors_from :
jmx_error :
name :
flags :
templateid :
description :
tls_connect :
tls_accept :
tls_issuer :
tls_subject :
tls_psk_identity :
tls_psk :MariaDB [rtm]> desc hosts; +--------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+---------------------+------+-----+---------+-------+ | hostid | bigint(20) unsigned | NO | PRI | NULL | | | proxy_hostid | bigint(20) unsigned | YES | MUL | NULL | | | host | varchar(128) | NO | MUL | | | | status | int(11) | NO | MUL | 0 | | | disable_until | int(11) | NO | | 0 | | | error | varchar(2048) | NO | | | | | available | int(11) | NO | | 0 | | | errors_from | int(11) | NO | | 0 | | | lastaccess | int(11) | NO | | 0 | | | ipmi_authtype | int(11) | NO | | 0 | | | ipmi_privilege | int(11) | NO | | 2 | | | ipmi_username | varchar(16) | NO | | | | | ipmi_password | varchar(20) | NO | | | | | ipmi_disable_until | int(11) | NO | | 0 | | | ipmi_available | int(11) | NO | | 0 | | | snmp_disable_until | int(11) | NO | | 0 | | | snmp_available | int(11) | NO | | 0 | | | maintenanceid | bigint(20) unsigned | YES | MUL | NULL | | | maintenance_status | int(11) | NO | | 0 | | | maintenance_type | int(11) | NO | | 0 | | | maintenance_from | int(11) | NO | | 0 | | | ipmi_errors_from | int(11) | NO | | 0 | | | snmp_errors_from | int(11) | NO | | 0 | | | ipmi_error | varchar(2048) | NO | | | | | snmp_error | varchar(2048) | NO | | | | | jmx_disable_until | int(11) | NO | | 0 | | | jmx_available | int(11) | NO | | 0 | | | jmx_errors_from | int(11) | NO | | 0 | | | jmx_error | varchar(2048) | NO | | | | | name | varchar(128) | NO | MUL | | | | flags | int(11) | NO | | 0 | | | templateid | bigint(20) unsigned | YES | MUL | NULL | | | description | text | NO | | NULL | | | tls_connect | int(11) | NO | | 1 | | | tls_accept | int(11) | NO | | 1 | | | tls_issuer | varchar(1024) | NO | | | | | tls_subject | varchar(1024) | NO | | | | | tls_psk_identity | varchar(128) | NO | | | | | tls_psk | varchar(512) | NO | | | | +--------------------+---------------------+------+-----+---------+-------+ *************************** 1. row *************************** hostid: 10108 proxy_hostid: NULL host: SNYAN-MC-CMNET-BAS12-HLDT-7750 status: 0 disable_until: 1546396094 error: Get value from agent failed: cannot connect to [[120.192.244.124]:10050]: [111] Connection refused available: 2 errors_from: 1531292163 lastaccess: 0 ipmi_authtype: 0 ipmi_privilege: 2 ipmi_username: ipmi_password: ipmi_disable_until: 0 ipmi_available: 0 snmp_disable_until: 0 snmp_available: 0 maintenanceid: NULL maintenance_status: 0 maintenance_type: 0 maintenance_from: 0 ipmi_errors_from: 0 snmp_errors_from: 0 ipmi_error: snmp_error: jmx_disable_until: 0 jmx_available: 0 jmx_errors_from: 0 jmx_error: name: 黄陵店头 flags: 0 templateid: NULL description: tls_connect: 1 tls_accept: 1 tls_issuer: tls_subject: tls_psk_identity: tls_psk: -
hosts_templates表
MariaDB [rtm]> desc hosts_templates; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | hosttemplateid | bigint(20) unsigned | NO | PRI | NULL | | | hostid | bigint(20) unsigned | NO | MUL | NULL | | | templateid | bigint(20) unsigned | NO | MUL | NULL | | +----------------+---------------------+------+-----+---------+-------+ MariaDB [rtm]> select * from hosts_templates; +----------------+--------+------------+ | hosttemplateid | hostid | templateid | +----------------+--------+------------+ | 39 | 10084 | 10001 | | 38 | 10084 | 10047 | | 43 | 10106 | 10105 | | 45 | 10108 | 10106 | | 46 | 10109 | 10106 | | 47 | 10110 | 10106 | | 48 | 10111 | 10106 | -
interface表
存储了所有设备的ip和端口的数据。（由于hosts表中不仅保存了设备信息还保存了模版信息，所以统计实际监控的设备，此表更加准确）
MariaDB [rtm]> desc interface; +-------------+---------------------+------+-----+-----------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------------+------+-----+-----------+-------+ | interfaceid | bigint(20) unsigned | NO | PRI | NULL | | | hostid | bigint(20) unsigned | NO | MUL | NULL | | | main | int(11) | NO | | 0 | | | type | int(11) | NO | | 0 | | | useip | int(11) | NO | | 1 | | | ip | varchar(64) | NO | MUL | 127.0.0.1 | | | dns | varchar(64) | NO | | | | | port | varchar(64) | NO | | 10050 | | | bulk | int(11) | NO | | 1 | | +-------------+---------------------+------+-----+-----------+-------+ MariaDB [rtm]> select * from interface; +-------------+--------+------+------+-------+-----------------+-----+-------+------+ | interfaceid | hostid | main | type | useip | ip | dns | port | bulk | +-------------+--------+------+------+-------+-----------------+-----+-------+------+ | 1 | 10084 | 1 | 1 | 1 | 127.0.0.1 | | 10050 | 1 | | 2 | 10108 | 1 | 1 | 1 | 120.192.244.124 | | 10050 | 1 | | 3 | 10109 | 1 | 1 | 1 | 120.192.244.125 | | 10050 | 1 |
