zabbix-templates/mysql_tpl.xml in zabbix-ruby-client-0.0.13 vs zabbix-templates/mysql_tpl.xml in zabbix-ruby-client-0.0.14
- old
+ new
@@ -1,9 +1,9 @@
<?xml version="1.0" encoding="UTF-8"?>
<zabbix_export>
<version>2.0</version>
- <date>2013-10-04T10:13:53Z</date>
+ <date>2013-10-11T05:38:53Z</date>
<groups>
<group>
<name>3. Service db</name>
</group>
<group>
@@ -45,11 +45,11 @@
<history>30</history>
<trends>365</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
- <units>qps</units>
+ <units>rps</units>
<delta>1</delta>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authpassphrase/>
<snmpv3_privpassphrase/>
@@ -162,11 +162,11 @@
<history>30</history>
<trends>365</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
- <units>qps</units>
+ <units>rps</units>
<delta>1</delta>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authpassphrase/>
<snmpv3_privpassphrase/>
@@ -201,11 +201,11 @@
<history>30</history>
<trends>365</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
- <units>qps</units>
+ <units>rps</units>
<delta>1</delta>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authpassphrase/>
<snmpv3_privpassphrase/>
@@ -240,11 +240,11 @@
<history>30</history>
<trends>365</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
- <units>qps</units>
+ <units>rps</units>
<delta>1</delta>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authpassphrase/>
<snmpv3_privpassphrase/>
@@ -318,11 +318,11 @@
<history>30</history>
<trends>365</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
- <units>qps</units>
+ <units>rps</units>
<delta>1</delta>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authpassphrase/>
<snmpv3_privpassphrase/>
@@ -357,11 +357,11 @@
<history>30</history>
<trends>365</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
- <units>qps</units>
+ <units>rps</units>
<delta>1</delta>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authpassphrase/>
<snmpv3_privpassphrase/>
@@ -641,11 +641,11 @@
<height>200</height>
<yaxismin>0.0000</yaxismin>
<yaxismax>100.0000</yaxismax>
<show_work_period>1</show_work_period>
<show_triggers>1</show_triggers>
- <type>0</type>
+ <type>1</type>
<show_legend>1</show_legend>
<show_3d>0</show_3d>
<percent_left>0.0000</percent_left>
<percent_right>0.0000</percent_right>
<ymin_type_1>0</ymin_type_1>
@@ -654,11 +654,11 @@
<ymax_item_1>0</ymax_item_1>
<graph_items>
<graph_item>
<sortorder>0</sortorder>
<drawtype>0</drawtype>
- <color>C8C800</color>
+ <color>006400</color>
<yaxisside>0</yaxisside>
<calc_fnc>2</calc_fnc>
<type>0</type>
<item>
<host>Mysql</host>
@@ -666,21 +666,21 @@
</item>
</graph_item>
<graph_item>
<sortorder>1</sortorder>
<drawtype>0</drawtype>
- <color>006400</color>
+ <color>A0CE58</color>
<yaxisside>0</yaxisside>
<calc_fnc>2</calc_fnc>
<type>0</type>
<item>
<host>Mysql</host>
<key>mysql.status[Com_commit]</key>
</item>
</graph_item>
<graph_item>
- <sortorder>2</sortorder>
+ <sortorder>3</sortorder>
<drawtype>0</drawtype>
<color>C80000</color>
<yaxisside>0</yaxisside>
<calc_fnc>2</calc_fnc>
<type>0</type>
@@ -688,23 +688,23 @@
<host>Mysql</host>
<key>mysql.status[Com_delete]</key>
</item>
</graph_item>
<graph_item>
- <sortorder>3</sortorder>
+ <sortorder>4</sortorder>
<drawtype>0</drawtype>
- <color>0000EE</color>
+ <color>99CCFF</color>
<yaxisside>0</yaxisside>
<calc_fnc>2</calc_fnc>
<type>0</type>
<item>
<host>Mysql</host>
<key>mysql.status[Com_insert]</key>
</item>
</graph_item>
<graph_item>
- <sortorder>4</sortorder>
+ <sortorder>2</sortorder>
<drawtype>0</drawtype>
<color>640000</color>
<yaxisside>0</yaxisside>
<calc_fnc>2</calc_fnc>
<type>0</type>
@@ -712,25 +712,25 @@
<host>Mysql</host>
<key>mysql.status[Com_rollback]</key>
</item>
</graph_item>
<graph_item>
- <sortorder>5</sortorder>
+ <sortorder>6</sortorder>
<drawtype>0</drawtype>
- <color>00C800</color>
+ <color>66DD66</color>
<yaxisside>0</yaxisside>
<calc_fnc>2</calc_fnc>
<type>0</type>
<item>
<host>Mysql</host>
<key>mysql.status[Com_select]</key>
</item>
</graph_item>
<graph_item>
- <sortorder>6</sortorder>
+ <sortorder>5</sortorder>
<drawtype>0</drawtype>
- <color>C800C8</color>
+ <color>6666CC</color>
<yaxisside>0</yaxisside>
<calc_fnc>2</calc_fnc>
<type>0</type>
<item>
<host>Mysql</host>
@@ -777,9 +777,113 @@
<calc_fnc>2</calc_fnc>
<type>0</type>
<item>
<host>Mysql</host>
<key>mysql.status[Bytes_sent]</key>
+ </item>
+ </graph_item>
+ </graph_items>
+ </graph>
+ <graph>
+ <name>s. MySQL operations</name>
+ <width>900</width>
+ <height>200</height>
+ <yaxismin>0.0000</yaxismin>
+ <yaxismax>100.0000</yaxismax>
+ <show_work_period>1</show_work_period>
+ <show_triggers>0</show_triggers>
+ <type>1</type>
+ <show_legend>0</show_legend>
+ <show_3d>0</show_3d>
+ <percent_left>0.0000</percent_left>
+ <percent_right>0.0000</percent_right>
+ <ymin_type_1>0</ymin_type_1>
+ <ymax_type_1>0</ymax_type_1>
+ <ymin_item_1>0</ymin_item_1>
+ <ymax_item_1>0</ymax_item_1>
+ <graph_items>
+ <graph_item>
+ <sortorder>0</sortorder>
+ <drawtype>0</drawtype>
+ <color>006400</color>
+ <yaxisside>0</yaxisside>
+ <calc_fnc>2</calc_fnc>
+ <type>0</type>
+ <item>
+ <host>Mysql</host>
+ <key>mysql.status[Com_begin]</key>
+ </item>
+ </graph_item>
+ <graph_item>
+ <sortorder>1</sortorder>
+ <drawtype>0</drawtype>
+ <color>A0CE58</color>
+ <yaxisside>0</yaxisside>
+ <calc_fnc>2</calc_fnc>
+ <type>0</type>
+ <item>
+ <host>Mysql</host>
+ <key>mysql.status[Com_commit]</key>
+ </item>
+ </graph_item>
+ <graph_item>
+ <sortorder>3</sortorder>
+ <drawtype>0</drawtype>
+ <color>C80000</color>
+ <yaxisside>0</yaxisside>
+ <calc_fnc>2</calc_fnc>
+ <type>0</type>
+ <item>
+ <host>Mysql</host>
+ <key>mysql.status[Com_delete]</key>
+ </item>
+ </graph_item>
+ <graph_item>
+ <sortorder>4</sortorder>
+ <drawtype>0</drawtype>
+ <color>99CCFF</color>
+ <yaxisside>0</yaxisside>
+ <calc_fnc>2</calc_fnc>
+ <type>0</type>
+ <item>
+ <host>Mysql</host>
+ <key>mysql.status[Com_insert]</key>
+ </item>
+ </graph_item>
+ <graph_item>
+ <sortorder>2</sortorder>
+ <drawtype>0</drawtype>
+ <color>640000</color>
+ <yaxisside>0</yaxisside>
+ <calc_fnc>2</calc_fnc>
+ <type>0</type>
+ <item>
+ <host>Mysql</host>
+ <key>mysql.status[Com_rollback]</key>
+ </item>
+ </graph_item>
+ <graph_item>
+ <sortorder>6</sortorder>
+ <drawtype>0</drawtype>
+ <color>66DD66</color>
+ <yaxisside>0</yaxisside>
+ <calc_fnc>2</calc_fnc>
+ <type>0</type>
+ <item>
+ <host>Mysql</host>
+ <key>mysql.status[Com_select]</key>
+ </item>
+ </graph_item>
+ <graph_item>
+ <sortorder>5</sortorder>
+ <drawtype>0</drawtype>
+ <color>6666CC</color>
+ <yaxisside>0</yaxisside>
+ <calc_fnc>2</calc_fnc>
+ <type>0</type>
+ <item>
+ <host>Mysql</host>
+ <key>mysql.status[Com_update]</key>
</item>
</graph_item>
</graph_items>
</graph>
</graphs>