019-zabbix数据库表详解

喜欢ヅ旅行 2023-10-10 10:27 29阅读 0赞

[https://www.cnblogs.com/yaoyaojcy/p/10367945.html][https_www.cnblogs.com_yaoyaojcy_p_10367945.html]

![1217531-20190219105351401-1683704274.png][]

![1217531-20190219105445568-1702915736.png][]

![1217531-20190219120730899-1905293498.png][]

![1217531-20190219120847206-1719410239.png][]

###  1. 查看目前zabbix系统所有数据表： ###

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div> 
    <div>
      4 
    </div> 
    <div>
      5 
    </div> 
    <div>
      6 
    </div> 
    <div>
      7 
    </div> 
    <div>
      8 
    </div> 
    <div>
      9 
    </div> 
    <div>
      10 
    </div> 
    <div>
      11 
    </div> 
    <div>
      12 
    </div> 
    <div>
      13 
    </div> 
    <div>
      14 
    </div> 
    <div>
      15 
    </div> 
    <div>
      16 
    </div> 
    <div>
      17 
    </div> 
    <div>
      18 
    </div> 
    <div>
      19 
    </div> 
    <div>
      20 
    </div> 
    <div>
      21 
    </div> 
    <div>
      22 
    </div> 
    <div>
      23 
    </div> 
    <div>
      24 
    </div> 
    <div>
      25 
    </div> 
    <div>
      26 
    </div> 
    <div>
      27 
    </div> 
    <div>
      28 
    </div> 
    <div>
      29 
    </div> 
    <div>
      30 
    </div> 
    <div>
      31 
    </div> 
    <div>
      32 
    </div> 
    <div>
      33 
    </div> 
    <div>
      34 
    </div> 
    <div>
      35 
    </div> 
    <div>
      36 
    </div> 
    <div>
      37 
    </div> 
    <div>
      38 
    </div> 
    <div>
      39 
    </div> 
    <div>
      40 
    </div> 
    <div>
      41 
    </div> 
    <div>
      42 
    </div> 
    <div>
      43 
    </div> 
    <div>
      44 
    </div> 
    <div>
      45 
    </div> 
    <div>
      46 
    </div> 
    <div>
      47 
    </div> 
    <div>
      48 
    </div> 
    <div>
      49 
    </div> 
    <div>
      50 
    </div> 
    <div>
      51 
    </div> 
    <div>
      52 
    </div> 
    <div>
      53 
    </div> 
    <div>
      54 
    </div> 
    <div>
      55 
    </div> 
    <div>
      56 
    </div> 
    <div>
      57 
    </div> 
    <div>
      58 
    </div> 
    <div>
      59 
    </div> 
    <div>
      60 
    </div> 
    <div>
      61 
    </div> 
    <div>
      62 
    </div> 
    <div>
      63 
    </div> 
    <div>
      64 
    </div> 
    <div>
      65 
    </div> 
    <div>
      66 
    </div> 
    <div>
      67 
    </div> 
    <div>
      68 
    </div> 
    <div>
      69 
    </div> 
    <div>
      70 
    </div> 
    <div>
      71 
    </div> 
    <div>
      72 
    </div> 
    <div>
      73 
    </div> 
    <div>
      74 
    </div> 
    <div>
      75 
    </div> 
    <div>
      76 
    </div> 
    <div>
      77 
    </div> 
    <div>
      78 
    </div> 
    <div>
      79 
    </div> 
    <div>
      80 
    </div> 
    <div>
      81 
    </div> 
    <div>
      82 
    </div> 
    <div>
      83 
    </div> 
    <div>
      84 
    </div> 
    <div>
      85 
    </div> 
    <div>
      86 
    </div> 
    <div>
      87 
    </div> 
    <div>
      88 
    </div> 
    <div>
      89 
    </div> 
    <div>
      90 
    </div> 
    <div>
      91 
    </div> 
    <div>
      92 
    </div> 
    <div>
      93 
    </div> 
    <div>
      94 
    </div> 
    <div>
      95 
    </div> 
    <div>
      96 
    </div> 
    <div>
      97 
    </div> 
    <div>
      98 
    </div> 
    <div>
      99 
    </div> 
    <div>
      100 
    </div> 
    <div>
      101 
    </div> 
    <div>
      102 
    </div> 
    <div>
      103 
    </div> 
    <div>
      104 
    </div> 
    <div>
      105 
    </div> 
    <div>
      106 
    </div> 
    <div>
      107 
    </div> 
    <div>
      108 
    </div> 
    <div>
      109 
    </div> 
    <div>
      110 
    </div> 
    <div>
      111 
    </div> 
    <div>
      112 
    </div> 
    <div>
      113 
    </div> 
    <div>
      114 
    </div> 
    <div>
      115 
    </div> 
    <div>
      116 
    </div> 
    <div>
      117 
    </div> 
    <div>
      118 
    </div> 
    <div>
      119 
    </div> 
    <div>
      120 
    </div> 
    <div>
      121 
    </div> 
    <div>
      122 
    </div> 
    <div>
      123 
    </div> 
    <div>
      124 
    </div> 
    <div>
      125 
    </div> 
    <div>
      126 
    </div> 
    <div>
      127 
    </div> 
    <div>
      128 
    </div> 
    <div>
      129 
    </div> 
    <div>
      130 
    </div> 
    <div>
      131 
    </div> 
    <div>
      132 
    </div> 
    <div>
      133 
    </div> 
    <div>
      134 
    </div> 
    <div>
      135 
    </div> 
    <div>
      136 
    </div> 
    <div>
      137 
    </div> 
    <div>
      138 
    </div> 
    <div>
      139 
    </div> 
    <div>
      140 
    </div> 
    <div>
      141 
    </div> 
    <div>
      142 
    </div> 
    <div>
      143 
    </div> 
    <div>
      144 
    </div> 
    <div>
      145 
    </div> 
    <div>
      146 
    </div> 
    <div>
      147 
    </div> 
    <div>
      148 
    </div> 
    <div>
      149 
    </div> 
    <div>
      150 
    </div> 
    <div>
      151 
    </div> 
    <div>
      152 
    </div> 
    <div>
      153 
    </div> 
    <div>
      154 
    </div> 
    <div>
      155 
    </div> 
    <div>
      156 
    </div> 
    <div>
      157 
    </div> 
    <div>
      158 
    </div> 
    <div>
      159 
    </div> 
    <div>
      160 
    </div> 
    <div>
      161 
    </div> 
    <div>
      162 
    </div> 
    <div>
      163 
    </div> 
    <div>
      164 
    </div> 
    <div>
      165 
    </div> 
    <div>
      166 
    </div> 
    <div>
      167 
    </div> 
    <div>
      168 
    </div> 
    <div>
      169 
    </div> 
    <div>
      170 
    </div> 
    <div>
      171 
    </div> 
    <div>
      172 
    </div> 
    <div>
      173 
    </div> 
    <div>
      174 
    </div> 
    <div>
      175 
    </div> 
    <div>
      176 
    </div> 
    <div>
      177 
    </div> 
    <div>
      178 
    </div> 
    <div>
      179 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>[root@localhost /]# mysql -u root -p</code> 
     </div> 
     <div> 
      <code>Enter password:</code> 
     </div> 
     <div> 
      <code>Welcome to the MariaDB monitor.&nbsp; Commands end with ; or \g.</code> 
     </div> 
     <div> 
      <code>Your MariaDB connection id&nbsp;</code> 
      <code>is</code>&nbsp; 
      <code>170786</code> 
     </div> 
     <div> 
      <code>Server version: 5.5.60-MariaDB MariaDB Server</code> 
     </div> 
     <div>
       &nbsp; 
     </div> 
     <div> 
      <code>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.</code> 
     </div> 
     <div>
       &nbsp; 
     </div> 
     <div> 
      <code>Type&nbsp;</code> 
      <code>'help;'</code>&nbsp; 
      <code>or&nbsp;</code> 
      <code>'\h'</code>&nbsp; 
      <code>for</code>&nbsp; 
      <code>help. Type&nbsp;</code> 
      <code>'\c'</code>&nbsp; 
      <code>to clear the current input statement.</code> 
     </div> 
     <div>
       &nbsp; 
     </div> 
     <div> 
      <code>MariaDB [(none)]&gt; show databases;</code> 
     </div> 
     <div> 
      <code>+--------------------+</code> 
     </div> 
     <div> 
      <code>| Database&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>+--------------------+</code> 
     </div> 
     <div> 
      <code>| information_schema |</code> 
     </div> 
     <div> 
      <code>| mysql&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| performance_schema |</code> 
     </div> 
     <div> 
      <code>| test&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| zabbix&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>+--------------------+</code> 
     </div> 
     <div> 
      <code>5 rows&nbsp;</code> 
      <code>in</code>&nbsp; 
      <code>set</code>&nbsp; 
      <code>(0.01 sec)</code> 
     </div> 
     <div>
       &nbsp; 
     </div> 
     <div> 
      <code>MariaDB [(none)]&gt; use zabbix</code> 
     </div> 
     <div> 
      <code>Reading table information&nbsp;</code> 
      <code>for</code>&nbsp; 
      <code>completion of table and column names</code> 
     </div> 
     <div> 
      <code>You can turn off&nbsp;</code> 
      <code>this</code>&nbsp; 
      <code>feature to&nbsp;</code> 
      <code>get</code>&nbsp; 
      <code>a quicker startup with -A</code> 
     </div> 
     <div>
       &nbsp; 
     </div> 
     <div> 
      <code>Database changed</code> 
     </div> 
     <div> 
      <code>MariaDB [zabbix]&gt; show tables;</code> 
     </div> 
     <div> 
      <code>+----------------------------+</code> 
     </div> 
     <div> 
      <code>| Tables_in_zabbix&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>+----------------------------+</code> 
     </div> 
     <div> 
      <code>| acknowledges&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| actions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| alerts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| application_discovery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| application_prototype&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| application_template&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| applications&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| auditlog&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| auditlog_details&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| autoreg_host&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| conditions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| config&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| corr_condition&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| corr_condition_group&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| corr_condition_tag&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| corr_condition_tagpair&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| corr_condition_tagvalue&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| corr_operation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| correlation&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| dashboard&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| dashboard_user&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| dashboard_usrgrp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| dbversion&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| dchecks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| dhosts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| drules&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| dservices&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| escalations&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| event_recovery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| event_suppress&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| event_tag&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| events&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| expressions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| functions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| globalmacro&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| globalvars&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| graph_discovery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| graph_theme&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| graphs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| graphs_items&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| group_discovery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| group_prototype&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| history&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| history_log&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| history_str&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| history_text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| history_uint&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| host_discovery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| host_inventory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| hostmacro&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| hosts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| hosts_groups&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| hosts_templates&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| housekeeper&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| hstgrp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| httpstep&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| httpstep_field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| httpstepitem&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| httptest&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| httptest_field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| httptestitem&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| icon_map&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| icon_mapping&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| ids&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| images&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>|&nbsp;</code> 
      <code>interface</code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
      <code>|</code> 
     </div> 
     <div> 
      <code>| interface_discovery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| item_application_prototype |</code> 
     </div> 
     <div> 
      <code>| item_condition&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| item_discovery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| item_preproc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| items&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| items_applications&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| maintenance_tag&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| maintenances&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| maintenances_groups&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| maintenances_hosts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| maintenances_windows&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| mappings&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| media&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| media_type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| opcommand&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| opcommand_grp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| opcommand_hst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| opconditions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| operations&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| opgroup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| opinventory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| opmessage&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| opmessage_grp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| opmessage_usr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| optemplate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| problem&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| problem_tag&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| profiles&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| proxy_autoreg_host&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| proxy_dhistory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| proxy_history&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| regexps&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| rights&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| screen_user&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| screen_usrgrp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| screens&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| screens_items&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| scripts&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| service_alarms&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| services&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| services_links&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| services_times&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sessions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| slides&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| slideshow_user&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| slideshow_usrgrp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| slideshows&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sysmap_element_trigger&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sysmap_element_url&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sysmap_shape&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sysmap_url&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sysmap_user&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sysmap_usrgrp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sysmaps&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sysmaps_elements&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sysmaps_link_triggers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| sysmaps_links&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| tag_filter&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| task&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| task_acknowledge&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| task_check_now&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| task_close_problem&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| task_remote_command&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| task_remote_command_result |</code> 
     </div> 
     <div> 
      <code>| timeperiods&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| trends&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| trends_uint&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| trigger_depends&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| trigger_discovery&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| trigger_tag&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| triggers&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| users&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| users_groups&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| usrgrp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| valuemaps&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| widget&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>| widget_field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |</code> 
     </div> 
     <div> 
      <code>+----------------------------+</code> 
     </div> 
     <div> 
      <code>144 rows&nbsp;</code> 
      <code>in</code>&nbsp; 
      <code>set</code>&nbsp; 
      <code>(0.00 sec)</code> 
     </div> 
     <div>
       &nbsp; 
     </div> 
     <div> 
      <code>MariaDB [zabbix]&gt;</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

### 2. 查看hosts数据表 ###

![1217531-20190220083142152-1988313905.png][]

### 3. 查看interface数据表 ###

![1217531-20190220083217708-1524069090.png][]

目前zabbix系统监控2台主机：  
![1217531-20190219125143410-507838635.png][]

查看一下hostid 10263 信息：

### 4. 查看items数据表 ###

![1217531-20190220083309400-661701785.png][]

![1217531-20190220083329054-1954096307.png][]

查看当前zabbix系统items数量：

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>select</code>&nbsp; 
      <code>count(*)&nbsp;</code> 
      <code>from</code>&nbsp; 
      <code>interface</code>&nbsp; 
      <code>a inner&nbsp;</code> 
      <code>join</code>&nbsp; 
      <code>hosts b&nbsp;</code> 
      <code>on</code>&nbsp; 
      <code>a.hostid=b.hostid inner&nbsp;</code> 
      <code>join</code>&nbsp; 
      <code>items c&nbsp;</code> 
      <code>on</code>&nbsp; 
      <code>c.hostid=a.hostid&nbsp;</code> 
      <code>where</code>&nbsp; 
      <code>a.hostid=10263 \G;</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

![1217531-20190219130152540-1696442548.png][]

查看当前zabbix系统单台主机key值与cpu相关：

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>select</code>&nbsp; 
      <code>c.key_,b.hostid,a.ip&nbsp;</code> 
      <code>from</code>&nbsp; 
      <code>interface</code>&nbsp; 
      <code>a inner&nbsp;</code> 
      <code>join</code>&nbsp; 
      <code>hosts b&nbsp;</code> 
      <code>on</code>&nbsp; 
      <code>a.hostid=b.hostid inner&nbsp;</code> 
      <code>join</code>&nbsp; 
      <code>items c&nbsp;</code> 
      <code>on</code>&nbsp; 
      <code>c.hostid=a.hostid&nbsp;</code> 
      <code>where</code>&nbsp; 
      <code>a.hostid=</code> 
     </div> 
     <div> 
      <code>10263 and c.key_ like&nbsp;</code> 
      <code>"%cpu%"</code>&nbsp; 
      <code>\G;</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

![1217531-20190219130905612-326592741.png][]

查看一下与主机相关联的模板数：

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>show tables like&nbsp;</code> 
      <code>"%host%"</code> 
      <code>;</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

![1217531-20190219131219331-1126949328.png][]

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>select</code>&nbsp; 
      <code>*&nbsp;</code> 
      <code>from</code>&nbsp; 
      <code>hosts_templates;</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

![1217531-20190219131430338-161355771.png][]

以上显示主机hostid=10263一共关联6个模板，在zabbix页面确认一下：

![1217531-20190219132016384-784992786.png][]

### 5. 查看目前zabbix系统history表： ###

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> </td> 
   <td> 
    <div> 
     <div> 
      <code>select</code>&nbsp; 
      <code>*&nbsp;</code> 
      <code>from</code>&nbsp; 
      <code>history</code> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

![1217531-20190219133145213-1659081446.png][]

![1217531-20190219141055361-417263696.png][]

### 6. 查看目前zabbix系统triggers表： ###

![1217531-20190219141343612-98101025.png][]

![1217531-20190219141547424-2067061454.png][]

# 自学Zabbix之路15.1 Zabbix数据库表结构简单解析-Hosts表、Hosts\_groups表、Interface表 #

说在前面：

*  数据库中的表的名称都是复数，比如存放Host信息的表的名字是Hosts等。
 *  数据库操作有风险，一旦出问题会造成Zabbix crash。需要谨慎操作。
 *  普通的查询可以在备库上进行。两边数据是实时同步的。

概述：

*  Zabbix数据库共有108个表，表的名称都是复数的。
 *  针对Zabbix中的每一个资源，都有一张表与其对应，比如hosts表，items表等。
 *  每一张表中都有一个id字段，如hosts表中的hostid，items中的itemid等。而资源之间的关联关系是通过外键来完成的。
 *  资源之间的关联关系是通过外键来完成的。比如host和item的关联关系，就是在items表中使用hostid与hosts表中的资源进行关联。

### 1. Hosts表 ###

“host”就是一台被监控的对象。

Hosts表结构如下：

![1217531-20180111112608926-1273873299.png][]

*  Hostid：唯一标识Host在Zabbix及数据库中的id。不同表之间的关联也要用id。
 *  Proxy\_hostid：若启用“proxy-server”架构，才会出现被监控机器的proxy\_hostid。
 *  Host：被监控机器的名字。
 *  Dns：DNS的名称。
 *  Useip：是否用ip监控。
 *  Port：监控的端口。
 *  Status：机器目前的状态。“0”为正常监控，“1”为disable。
 *  disable\_util，error，available，errors\_from(ipmi\_disable\_util，ipmi\_error…和 snmp\_disable\_until…都是此类)：这几个都是Zabbix Poller会去修改的值。我看了下poller.c的代码，当poller在第一次取不到值（根据值的类型不同会更新相应的列，Item类型为snmp就会更新snmp\_XXX，默认为“zabbix”类型）的时候，会等15秒（CONFIG\_UNREACHABLE\_DELAY）来重试，并且日志会显示“first network error”，如果15秒后依然取不到值，zabbix会在数据库更新这个host取不到值的信息，即这几列。并且日志里显示“another network error”。 
 *  Lastacess：表示proxy最后一次工作的时间。这里的“工作”指Zabbix Server收到Proxy数据。
 *  Ipmi\*、snmp\*、jmx\*为使用这三种监控方式时的监控记录。
 *  maintenanceid，maintenance\_\*：这是Zabbix另一个机制Maintaince有关，用于使Host 置于维护状态而不会报警。

**简单针对Host的操作：**  
  更新机器的proxy。找到proxy的hostid，更新对用host的proxy\_hostid：   
           select hostid from hosts where host='ProxyA' and ip='0.0.0.0';  -- get hostid: 1234   
           update hosts set proxy\_hostid=1234 where host='Host\_To\_Update\_Proxy';   
   得到更新的Host状态（enable/disable）如下：  
         update hosts set status='0' where host='Host\_To\_Enable';   
         update hosts set status='1' where host='Host\_To\_Disable';

### 2.Hosts\_groups 表 ###

hosts\_groups保存了host（主机）与host groups（主机组）的关联关系。

这部分信息可以在我们自己做一些批量查询，例如查询关联到某个主机组的所有设备的IP 、存活状态等，进一步去查询该批量设备的load、IO、mem等统计信息。

![1217531-20180111114014551-869665676.png][]

### 3.Interface表  ###

Interface表用于存储每一个host的接口信息，此表与hosts表分离，方便了用户修改信息与管理。

![1217531-20180111114113254-1418150279.png][]

# 自学Zabbix之路15.2 Zabbix数据库表结构简单解析-Items表 #

Items表记录了item的所有设置。在Zabbix中，最多的操作就是对items的。如添加监控项、删除监控项、更新监控配置等。

![1217531-20180111114208129-892583294.png][]

**itemid**：item的id

**type**：item的type，和前端见面配置item的type的对应。数据库中，这一列的值是0到17的数字，分别代表不同的类型：

*   0：Zabbix agent 
 *   1：SNMPv1 agent 
 *   2：Zabbix trapper 
 *   3：simple check 
 *   4：SNMPv2 agent 
 *   5：Zabbix internal 
 *   6：SNMPv3 agent 
 *   7：Zabbix agent(active) 
 *   8：Zabbix aggregate  
 *   9：web item 
 *  10：external check 
 *  11：database monitor 
 *  12：IPMI agent 
 *  13：SSH agent 
 *  14：TELNET agent 
 *  15：calculated 
 *  16：JMX agent 
 *  17：SNMP trap

**hostid**：item所在的host的hostid。如果该item是属于template，那么这里显示的是templateid

**name**：item的名字

**key\_**：item的key

**delay**：这里的delay，实际就是在配置item时候配置的“Update Interval”

**trends**：前端配置中的存储trend的时间

**status**：item的状态

*  0：item是enabled状态
 *  1：item是disabled状态
 *  3：numeric unsigned
 *  4：text

**value\_type**：item返回值的类型，配置item时候配置的“Type of Information”

**trapper\_hosts**：当item为trapper类型的时候，记录了也许发送的host

**units**： item配置界面中的‘units’

**multiplier**：针对这个item是否启用了 ’custom multiplier‘

**delta**： item配置界面上的‘store value’

**snmpv3\***： 都是和SNMP3相关的配置

**formula**：页面设置item时候“User custom multiplier”配置的数字

**error**：item的错误信息

**lastlogsize**：针对log和logrt类型的items使用时，记录上衣系读取时日志文件的大小

**logtimefmt**：针对log和logrt有效，配置日志中时间的格式

**templateid**：记录Host上item对应的在template上的item的itemid

**valuemapid**：Item配置界面中选择“valuemap”的id

**delay\_flex**：Item配置界面中选择“Fexible interval”的id

**params**：当需要额外参数item时，记录这些参数的地方

**ipmi\_sensor**：使用IPMI类型的items需要设定的参数

**data\_type**：Item配置界面中‘datatype’ 选择item返回的数据类型

**authtype**：使用SSHI类型的items时有效，选择SSH登陆的类型

**username**：使用SSHI类型的items时有效，选择SSH登陆的用户名

**password**：使用SSHI类型的items时有效，选择SSH登陆的密码

**publickey**：使用SSHI类型的items时有效，但是只有当authtype设置we使用publickey时才有效

**privatekey**：使用SSHI类型的items时有效，但是只有当authtype设置we使用privatekey时才有效

**mtime**：针对log和logrt有效，配置日志文件的修改时间

**flags：**

*  0：表示一个普通的item
 *  4：表示是discover生成的item

**interfaceid**：当使用hosts类型的item时生效，用来选择host上不同的interface

**port**：使用SNMP监控室使用的端口号

**description：**Item配置界面上的“Description”

**inventory\_link：**如果这个item的值要座位host的inventory，这里填写的是对应的inventoied

**state：**当前item的状态

*  0：正常
 *  1：not supported

# 自学Zabbix之路15.3 Zabbix数据库表结构简单解析-Triggers表、Applications表、 Mapplings表 #

** 1.Trigger表**

Trigger是zabbix的重要组成部分，相对应的Trigger表也比较复杂。 主要体现在与其他表的关联关系很强。  
 ![1217531-20180111131843941-206832988.png][]

**2. Applicaion表**

Application表用于存储监控像所属于的应用

![1217531-20180111132220410-309953014.png][]

*  applicationid：为主键编号
 *  hostid：对应与host的id
 *  name：用于存储application的名称
 *  flag：用于存储application的状态。

**3 Mappling表**

Mappings表用于存储的应用状态映射信息，存储数据时会将不同的值、不同的范围对应不同的状态，而用户关心的正是这些状态。

![1217531-20180111132645988-913710342.png][]

# 自学Zabbix之路15.4 Zabbix数据库表结构简单解析-Expressions表、Media表、 Events表  #

** 1.Expressions表**

Expressions表用于判断triggers时需要用到的正则表达式，助于合理的进行triggers判断。

![1217531-20180111133253441-1179333519.png][]

**2.Media表**

media 保存了某个用户的media配置项，即对应的告警方式，如邮件等方式。  
 ![1217531-20180111133338254-239515828.png][]

**3. Events表**

当Zabbix server获取到一个数据，它就会检查跟这个item相关的trigger，然后无论是否触发action，都会生成一个event。  
![1217531-20180111133422957-467569639.png][]

source：event可能由多种源头生成，这里的source就是记录了这个event是由于什么事 件而生成的。

*  0：由trigger生成的event
 *  1：由discovery rule生成的event
 *   2：由agent auto-registration生成的event
 *   3：internal的event

object：这个字段记录了和event关联的Zabbix对象。

*  对于trigger相关的events，这里的值只可能是0
 *  对于discovery相关的event，“1”表示是discovered host，“2”表示是discovered service
 *  对于auto-registration的event，这里值一定是“3”
 *  对于interval的event  
    “0”表示trigger，  
    “4”表示item，  
    “5”表示low-level discovery

objectid：根据前面object里的定义，这里可能为triggerid，也可能是discovered hostid  
ns：在 2.0.0加入这个纳秒的记录的。原因是这样的，如果只有timestamp，那么这个\{ITEM.VALUE\}会发生错乱。  
value：和object字段类似，根据source的不同，这里的值有不同的含义  
       对于trigger类型的event：

*            0：trigger的状态为OK
 *            1：trigger的状态为PROBLEM

对于discovery类型的event：

*  0：host或者service正在工作
 *  1：host或者service停止工作
 *  2：host或者service被侦测到
 *  3：host或者service丢失了

对于internal类型的event：

*   *  0：normal状态
     *  1：unknown或者not supported状态

# 自学Zabbix之路15.5 Zabbix数据库表结构简单解析-其他 表 #

** 1. Actions表**

actions表记录了当触发器触发时，需要采用的动作。

![1217531-20180111133936269-2134359159.png][]

**2.Alerts 表**

alerts 表保存了历史的告警事件，可以从这个表里面去做一些统计分析，例如某个部门、某人、某类时间的告警统计，以及更深入的故障发生、恢复时间

** 3. Config表**![1217531-20180111134019816-1563738418.png][]

config表保存了全局的参数，前端包括后端也是，很多情况下会查询改表的参数的，例如用户的自定义主题、登陆认证类型等，非常重要。

![1217531-20180111134137910-1612348041.png][]

![1217531-20180111134151847-1109635655.png][]

**4. Functions 表**

记录了trigger中使用的表达式，例如max、last、nodata等函数。

**5. graphs\_items 表**![1217531-20180111134316426-2139332813.png][]

graphs\_items保存了属于某个图表的所有的监控项信息。

![1217531-20180111134408457-1935005082.png][]

**6.profiles 表**

profiles 表保存了用户的一些配置项。

![1217531-20180111134454535-1254182271.png][]

**7.sessions 表**

sessions 表很重要，保存了每个用户的sessions,在登陆、注销的时候均会操作该张表的。

![1217531-20180111134540207-88737849.png][]

**8.History**  
 History表用于存储监控所得的原始数据

![1217531-20180111134708941-1300219598.png][]

*  itemid对应与监控项
 *  clock为数据的获取时间，用时间戳表示
 *  value为获取的原始数据
 *  ns表示采集到该数据所用的时间

** 9.History\_str表 **

history\_str表用于存储采集到的数据中需要用字符串记录的数据。

![1217531-20180111134918754-1542812950.png][]

*  temid对应与监控项
 *  clock为数据的获取时间，用时间戳表示
 *  value为获取的原始数据
 *  ns表示采集到该数据所用的时间

** 10.Trends 表**

Trends表用于储存监控的趋势性数据，若将所有历史数据保留将占用大量存储空间，单用户可能仍需要查看监控对像的趋势状态，因此需要用到trends表。

![1217531-20180111135025472-475496022.png][]

** 11.Users 表**

部分用户配置会在该表中，例如auotlogin、autologout、url、theme等信息。

![1217531-20180111135102832-1096408259.png][]

表结构和进程：
    MariaDB [zabbix]> show tables
        -> ;
    +----------------------------+
    | Tables_in_zabbix           |
    +----------------------------+
    | acknowledges               |        ：存储问题原因的表
    | actions                    |        ：存储自动发现动作的表
    | alerts                     |        ：报警的表
    | application_discovery      |        ：应用发现
    | application_prototype      |        ：应用样板
    | application_template       |        ：应用模板
    | applications               |        ：应用
    | auditlog                   |        ：操作日志，就是web页面中的审计日志
    | auditlog_details           |        ：操作日志详细
    | autoreg_host               |        ：自动注册的主机
    | conditions                 |        ：条件，具体没研究，比如触发器的条件，自动注册的条件等
    | config                     |        ：配置，就是web中管理中的一般项目中的所有
    | corr_condition             |
    | corr_condition_group       |
    | corr_condition_tag         |
    | corr_condition_tagpair     |
    | corr_condition_tagvalue    |
    | corr_operation             |
    | correlation                |        ：关联项
    | dashboard                  |
    | dashboard_user             |
    | dashboard_usrgrp           |
    | dbversion                  |        ：数据库的版本
    | dchecks                    |        ：检测  在自动发现中用的 system.uname  d可以理解为discover的缩写
    | dhosts                     |        ：
    | drules                     |
    | dservices                  |
    | escalations                |        ：报警升级
    | event_recovery             |        ：恢复的事件
    | event_suppress             |        ：废弃的事件
    | event_tag                  |        ：事件的标签
    | events                     |        ：事件
    | expressions                |        ：正则表达式  就是web中管理中的一般中的正则表达式
    | functions                  |        ：要跟着triggers 一起看  如下：
    ###########################################################################################
    MariaDB [zabbix]> select * from triggers where triggerid=16255\G;
    *************************** 1. row ***************************
              triggerid: 16255
             expression: {
                            18498}>0
            description: /etc/passwd has been changed on {HOST.NAME}
                    url: 
                 status: 0
                  value: 0
               priority: 2
             lastchange: 0
               comments: 
                  error: 
             templateid: 10016
                   type: 0
                  state: 0
                  flags: 0
          recovery_mode: 0
    recovery_expression: 
       correlation_mode: 0
        correlation_tag: 
           manual_close: 0
                details: 
    1 row in set (0.00 sec)
    
    
    MariaDB [zabbix]> desc functions;
    +------------+---------------------+------+-----+---------+-------+
    | Field      | Type                | Null | Key | Default | Extra |
    +------------+---------------------+------+-----+---------+-------+
    | functionid | bigint(20) unsigned | NO   | PRI | NULL    |       |
    | itemid     | bigint(20) unsigned | NO   | MUL | NULL    |       |
    | triggerid  | bigint(20) unsigned | NO   | MUL | NULL    |       |
    | name       | varchar(12)         | NO   |     |         |       |
    | parameter  | varchar(255)        | NO   |     | 0       |       |
    +------------+---------------------+------+-----+---------+-------+
    5 rows in set (0.01 sec)
    
    MariaDB [zabbix]> select * from functions where functionid=18498\G;
    *************************** 1. row ***************************
    functionid: 18498
        itemid: 29826
     triggerid: 16255
          name: diff
     parameter: 0
    1 row in set (0.00 sec)
    
    
    MariaDB [zabbix]> 
    MariaDB [zabbix]> select * from triggers where triggerid=16250\G;
    *************************** 1. row ***************************
              triggerid: 16250
             expression: {
                            18493}>20
            description: Disk I/O is overloaded on {HOST.NAME}
                    url: 
                 status: 0
                  value: 0
               priority: 2
             lastchange: 0
               comments: OS spends significant time waiting for I/O (input/output) operations. It could be indicator of performance issues with storage system.
                  error: 
             templateid: 13243
                   type: 0
                  state: 0
                  flags: 0
          recovery_mode: 0
    recovery_expression: 
       correlation_mode: 0
        correlation_tag: 
           manual_close: 0
                details: 
    1 row in set (0.00 sec)
    
    ERROR: No query specified
    
    MariaDB [zabbix]> select * from functions where functionid=18493\G;
    *************************** 1. row ***************************
    functionid: 18493
        itemid: 29812
     triggerid: 16250
          name: avg
     parameter: 5m
    1 row in set (0.00 sec)
    
    #################################################################################################
    
    | globalmacro                |        ：全局的宏
    | globalvars                 |        ：全局变量
    | graph_discovery            |        ：图形的发现
    | graph_theme                |        ：图形的主题
    | graphs                     |        ：图形
    | graphs_items               |        ：图形的监控项
    | group_discovery            |        ：
    | group_prototype            |        ：组的模型
    | history                    |        ：存的是浮点数
    | history_log                |        ：存的是日志
    | history_str                |
    | history_text               |
    | history_uint               |        ：存的是无符号的正整数
    | host_discovery             |
    | host_inventory             |        ：资产
    | host_tag                   |        ：
    | hostmacro                  |        ：主机的宏
    | hosts                      |        ：主机
    | hosts_groups               |        ：主机组
    | hosts_templates            |        ：主机模板
    | housekeeper                |        ：定期去清数据库的历史数据
    ####################################################################################################
    [root@zabbix ~]# ps -ef | grep zabbix_server
    zabbix    39375      1  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server -c /etc/zabbix/zabbix_server.conf
    zabbix    39380  39375  0 15:05 ?        00:00:08 /usr/sbin/zabbix_server: configuration syncer [synced configuration in 0.024709 sec, idle 60 sec]
    zabbix    39381  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: housekeeper [deleted 2287 hist/trends, 0 items/triggers, 160 events, 0 sessions, 0 alarms, 0 audit items, 0 records in 0.099492 sec, idle for 1
    zabbix    39382  39375  0 15:05 ?        00:00:01 /usr/sbin/zabbix_server: timer #1 [updated 0 hosts, suppressed 0 events in 0.000923 sec, idle 59 sec]
    zabbix    39383  39375  0 15:05 ?        00:00:01 /usr/sbin/zabbix_server: http poller #1 [got 0 values in 0.000993 sec, idle 5 sec]
    zabbix    39385  39375  0 15:05 ?        00:00:04 /usr/sbin/zabbix_server: discoverer #1 [processed 1 rules in 3.025297 sec, performing discovery]
    zabbix    39387  39375  0 15:05 ?        00:00:02 /usr/sbin/zabbix_server: history syncer #1 [processed 0 values, 0 triggers in 0.000024 sec, idle 1 sec]
    zabbix    39388  39375  0 15:05 ?        00:00:02 /usr/sbin/zabbix_server: history syncer #2 [processed 0 values, 0 triggers in 0.000093 sec, idle 1 sec]
    zabbix    39389  39375  0 15:05 ?        00:00:02 /usr/sbin/zabbix_server: history syncer #3 [processed 0 values, 0 triggers in 0.000016 sec, idle 1 sec]
    zabbix    39390  39375  0 15:05 ?        00:00:02 /usr/sbin/zabbix_server: history syncer #4 [processed 1 values, 0 triggers in 0.002126 sec, idle 1 sec]
    zabbix    39391  39375  0 15:05 ?        00:00:02 /usr/sbin/zabbix_server: escalator #1 [processed 0 escalations in 0.001176 sec, idle 3 sec]
    zabbix    39392  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: proxy poller #1 [exchanged data with 0 proxies in 0.000069 sec, idle 5 sec]
    zabbix    39393  39375  0 15:05 ?        00:00:01 /usr/sbin/zabbix_server: self-monitoring [processed data in 0.000015 sec, idle 1 sec]
    zabbix    39394  39375  0 15:05 ?        00:00:01 /usr/sbin/zabbix_server: task manager [processed 0 task(s) in 0.000318 sec, idle 5 sec]
    zabbix    39395  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: poller #1 [got 0 values in 0.000010 sec, idle 5 sec]
    zabbix    39396  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: poller #2 [got 0 values in 0.000020 sec, idle 5 sec]
    zabbix    39397  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: poller #3 [got 0 values in 0.000010 sec, idle 5 sec]
    zabbix    39398  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: poller #4 [got 0 values in 0.000032 sec, idle 5 sec]
    zabbix    39399  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: poller #5 [got 0 values in 0.000039 sec, idle 5 sec]
    zabbix    39400  39375  0 15:05 ?        00:00:03 /usr/sbin/zabbix_server: unreachable poller #1 [got 0 values in 0.000043 sec, idle 5 sec]
    zabbix    39408  39375  0 15:05 ?        00:00:02 /usr/sbin/zabbix_server: trapper #1 [processed data in 0.000346 sec, waiting for connection]
    zabbix    39409  39375  0 15:05 ?        00:00:02 /usr/sbin/zabbix_server: trapper #2 [processed data in 0.000768 sec, waiting for connection]
    zabbix    39410  39375  0 15:05 ?        00:00:02 /usr/sbin/zabbix_server: trapper #3 [processed data in 0.000767 sec, waiting for connection]
    zabbix    39411  39375  0 15:05 ?        00:00:02 /usr/sbin/zabbix_server: trapper #4 [processed data in 0.000578 sec, waiting for connection]
    zabbix    39412  39375  0 15:05 ?        00:00:02 /usr/sbin/zabbix_server: trapper #5 [processed data in 0.001200 sec, waiting for connection]
    zabbix    39413  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: icmp pinger #1 [got 0 values in 0.000029 sec, idle 5 sec]
    zabbix    39414  39375  0 15:05 ?        00:00:03 /usr/sbin/zabbix_server: alert manager #1 [sent 0, failed 0 alerts, idle 5.008432 sec during 5.008528 sec]
    zabbix    39415  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: alerter #1 started
    zabbix    39416  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: alerter #2 started
    zabbix    39417  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: alerter #3 started
    zabbix    39418  39375  0 15:05 ?        00:00:01 /usr/sbin/zabbix_server: preprocessing manager #1 [queued 0, processed 0 values, idle 5.005733 sec during 5.006085 sec]
    zabbix    39419  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: preprocessing worker #1 started
    zabbix    39425  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: preprocessing worker #2 started
    zabbix    39426  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: preprocessing worker #3 started
    zabbix    39427  39375  0 15:05 ?        00:00:01 /usr/sbin/zabbix_server: lld manager #1 [processed 0 LLD rules during 5.008159 sec]
    zabbix    39428  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: lld worker #1 [processed 1 LLD rules, idle 750.002220 sec during 750.031470 sec]
    zabbix    39429  39375  0 15:05 ?        00:00:00 /usr/sbin/zabbix_server: lld worker #2 [processed 1 LLD rules, idle 748.993248 sec during 749.006637 sec]
    #####################################################################################################################
    
    | hstgrp                     |        ：主机群组
    | httpstep                   |        ：
    | httpstep_field             |
    | httpstepitem               |
    | httptest                   |
    | httptest_field             |
    | httptestitem               |
    | icon_map                   |        ：图标
    | icon_mapping               |        ：
    | ids                        |        ：
    | images                     |
    | interface                  |        ：接口
    | interface_discovery        |
    | item_application_prototype |
    | item_condition             |
    | item_discovery             |
    | item_preproc               |
    | items                      |        ：监控项
    | items_applications         |
    | lld_macro_path             |
    | maintenance_tag            |
    | maintenances               |
    | maintenances_groups        |
    | maintenances_hosts         |
    | maintenances_windows       |
    | mappings                   |        ：映射值
    | media                      |        ：媒体
    | media_type                 |        ：媒体类型
    | opcommand                  |
    | opcommand_grp              |
    | opcommand_hst              |
    | opconditions               |
    | operations                 |
    | opgroup                    |
    | opinventory                |
    | opmessage                  |
    | opmessage_grp              |
    | opmessage_usr              |
    | optemplate                 |
    | problem                    |
    | problem_tag                |
    | profiles                   |
    | proxy_autoreg_host         |
    | proxy_dhistory             |
    | proxy_history              |
    | regexps                    |
    | rights                     |
    | screen_user                |
    | screen_usrgrp              |
    | screens                    |
    | screens_items              |
    | scripts                    |
    | service_alarms             |        ：就是跟99.99%相关的
    | services                   |
    | services_links             |
    | services_times             |
    | sessions                   |
    | slides                     |
    | slideshow_user             |
    | slideshow_usrgrp           |
    | slideshows                 |
    | sysmap_element_trigger     |        ：系统图
    | sysmap_element_url         |
    | sysmap_shape               |
    | sysmap_url                 |
    | sysmap_user                |
    | sysmap_usrgrp              |
    | sysmaps                    |
    | sysmaps_elements           |
    | sysmaps_link_triggers      |
    | sysmaps_links              |
    | tag_filter                 |
    | task                       |
    | task_acknowledge           |
    | task_check_now             |
    | task_close_problem         |
    | task_remote_command        |
    | task_remote_command_result |
    | timeperiods                |
    | trends                     |        ：趋势图
    | trends_uint                |
    | trigger_depends            |        ：触发器依赖
    | trigger_discovery          |
    | trigger_tag                |
    | triggers                   |
    | users                      |
    | users_groups               |
    | usrgrp                     |
    | valuemaps                  |
    | widget                     |
    | widget_field               |
    +----------------------------+
    146 rows in set (0.01 sec)
    
    MariaDB [zabbix]> select * from acknowledges;
    +---------------+--------+---------+------------+-----------------+--------+--------------+--------------+
    | acknowledgeid | userid | eventid | clock      | message         | action | old_severity | new_severity |
    +---------------+--------+---------+------------+-----------------+--------+--------------+--------------+
    |             1 |      1 |    5405 | 1566893083 | 主机不存在      |      4 |            0 |            0 |
    +---------------+--------+---------+------------+-----------------+--------+--------------+--------------+

转载于:https://www.cnblogs.com/xuefy/p/11422104.html

[https_www.cnblogs.com_yaoyaojcy_p_10367945.html]: https://www.cnblogs.com/yaoyaojcy/p/10367945.html
[1217531-20190219105351401-1683704274.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219105351401-1683704274.png
[1217531-20190219105445568-1702915736.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219105445568-1702915736.png
[1217531-20190219120730899-1905293498.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219120730899-1905293498.png
[1217531-20190219120847206-1719410239.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219120847206-1719410239.png
[1217531-20190220083142152-1988313905.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190220083142152-1988313905.png
[1217531-20190220083217708-1524069090.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190220083217708-1524069090.png
[1217531-20190219125143410-507838635.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219125143410-507838635.png
[1217531-20190220083309400-661701785.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190220083309400-661701785.png
[1217531-20190220083329054-1954096307.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190220083329054-1954096307.png
[1217531-20190219130152540-1696442548.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219130152540-1696442548.png
[1217531-20190219130905612-326592741.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219130905612-326592741.png
[1217531-20190219131219331-1126949328.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219131219331-1126949328.png
[1217531-20190219131430338-161355771.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219131430338-161355771.png
[1217531-20190219132016384-784992786.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219132016384-784992786.png
[1217531-20190219133145213-1659081446.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219133145213-1659081446.png
[1217531-20190219141055361-417263696.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219141055361-417263696.png
[1217531-20190219141343612-98101025.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219141343612-98101025.png
[1217531-20190219141547424-2067061454.png]: https://img2018.cnblogs.com/blog/1217531/201902/1217531-20190219141547424-2067061454.png
[1217531-20180111112608926-1273873299.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111112608926-1273873299.png
[1217531-20180111114014551-869665676.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111114014551-869665676.png
[1217531-20180111114113254-1418150279.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111114113254-1418150279.png
[1217531-20180111114208129-892583294.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111114208129-892583294.png
[1217531-20180111131843941-206832988.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111131843941-206832988.png
[1217531-20180111132220410-309953014.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111132220410-309953014.png
[1217531-20180111132645988-913710342.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111132645988-913710342.png
[1217531-20180111133253441-1179333519.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111133253441-1179333519.png
[1217531-20180111133338254-239515828.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111133338254-239515828.png
[1217531-20180111133422957-467569639.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111133422957-467569639.png
[1217531-20180111133936269-2134359159.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111133936269-2134359159.png
[1217531-20180111134019816-1563738418.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111134019816-1563738418.png
[1217531-20180111134137910-1612348041.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111134137910-1612348041.png
[1217531-20180111134151847-1109635655.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111134151847-1109635655.png
[1217531-20180111134316426-2139332813.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111134316426-2139332813.png
[1217531-20180111134408457-1935005082.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111134408457-1935005082.png
[1217531-20180111134454535-1254182271.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111134454535-1254182271.png
[1217531-20180111134540207-88737849.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111134540207-88737849.png
[1217531-20180111134708941-1300219598.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111134708941-1300219598.png
[1217531-20180111134918754-1542812950.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111134918754-1542812950.png
[1217531-20180111135025472-475496022.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111135025472-475496022.png
[1217531-20180111135102832-1096408259.png]: https://images2017.cnblogs.com/blog/1217531/201801/1217531-20180111135102832-1096408259.png