Vladimir Rusinov avatar Vladimir Rusinov committed 904cbe4

mysql template graphs fixes

Comments (0)

Files changed (1)

templates/Template_app_MySQL.xml

 <?xml version="1.0" encoding="UTF-8"?>
-<zabbix_export version="1.0" date="01.09.10" time="16.24">
+<zabbix_export version="1.0" date="03.10.10" time="21.30">
 	<hosts>
 		<host name="Template_app_MySQL">
 			<proxy_hostid>0</proxy_hostid>
 					<percent_left>0.0000</percent_left>
 					<percent_right>0.0000</percent_right>
 					<graph_elements>
-						<graph_element item="Template_app_MySQL:mysql.status[Connections]">
+						<graph_element item="Template_app_MySQL:mysql.status[aborted_connects]">
 							<drawtype>0</drawtype>
 							<sortorder>1</sortorder>
-							<color>0000BB</color>
+							<color>000000</color>
 							<yaxisside>0</yaxisside>
 							<calc_fnc>2</calc_fnc>
 							<type>0</type>
 							<periods_cnt>5</periods_cnt>
 						</graph_element>
-						<graph_element item="Template_app_MySQL:mysql.status[aborted_connects]">
+						<graph_element item="Template_app_MySQL:mysql.status[queries]">
+							<drawtype>0</drawtype>
+							<sortorder>2</sortorder>
+							<color>EE0000</color>
+							<yaxisside>0</yaxisside>
+							<calc_fnc>2</calc_fnc>
+							<type>0</type>
+							<periods_cnt>5</periods_cnt>
+						</graph_element>
+						<graph_element item="Template_app_MySQL:mysql.status[Connections]">
 							<drawtype>0</drawtype>
 							<sortorder>1</sortorder>
-							<color>000000</color>
+							<color>0000BB</color>
 							<yaxisside>0</yaxisside>
 							<calc_fnc>2</calc_fnc>
 							<type>0</type>
 							<type>0</type>
 							<periods_cnt>5</periods_cnt>
 						</graph_element>
-						<graph_element item="Template_app_MySQL:mysql.status[queries]">
-							<drawtype>0</drawtype>
-							<sortorder>2</sortorder>
-							<color>EE0000</color>
-							<yaxisside>0</yaxisside>
-							<calc_fnc>2</calc_fnc>
-							<type>0</type>
-							<periods_cnt>5</periods_cnt>
-						</graph_element>
 					</graph_elements>
 				</graph>
-				<graph name="Mysql: queries" width="900" height="200">
-					<ymin_type>2</ymin_type>
-					<ymax_type>2</ymax_type>
+				<graph name="Mysql: connections" width="900" height="200">
+					<ymin_type>1</ymin_type>
+					<ymax_type>0</ymax_type>
 					<ymin_item_key></ymin_item_key>
 					<ymax_item_key></ymax_item_key>
 					<show_work_period>0</show_work_period>
 					<percent_left>0.0000</percent_left>
 					<percent_right>0.0000</percent_right>
 					<graph_elements>
-						<graph_element item="Template_app_MySQL:mysql.status[questions]">
+						<graph_element item="Template_app_MySQL:mysql.status[Connections]">
+							<drawtype>0</drawtype>
+							<sortorder>1</sortorder>
+							<color>EE0000</color>
+							<yaxisside>1</yaxisside>
+							<calc_fnc>2</calc_fnc>
+							<type>0</type>
+							<periods_cnt>5</periods_cnt>
+						</graph_element>
+						<graph_element item="Template_app_MySQL:mysql.status[aborted_connects]">
+							<drawtype>2</drawtype>
+							<sortorder>2</sortorder>
+							<color>CC00CC</color>
+							<yaxisside>1</yaxisside>
+							<calc_fnc>2</calc_fnc>
+							<type>0</type>
+							<periods_cnt>5</periods_cnt>
+						</graph_element>
+						<graph_element item="Template_app_MySQL:mysql.status[Threads_connected]">
 							<drawtype>2</drawtype>
 							<sortorder>0</sortorder>
-							<color>00DDDD</color>
+							<color>009900</color>
+							<yaxisside>0</yaxisside>
+							<calc_fnc>2</calc_fnc>
+							<type>0</type>
+							<periods_cnt>5</periods_cnt>
+						</graph_element>
+					</graph_elements>
+				</graph>
+				<graph name="Mysql: queries" width="900" height="200">
+					<ymin_type>1</ymin_type>
+					<ymax_type>0</ymax_type>
+					<ymin_item_key></ymin_item_key>
+					<ymax_item_key></ymax_item_key>
+					<show_work_period>0</show_work_period>
+					<show_triggers>0</show_triggers>
+					<graphtype>0</graphtype>
+					<yaxismin>0.0000</yaxismin>
+					<yaxismax>100.0000</yaxismax>
+					<show_legend>0</show_legend>
+					<show_3d>0</show_3d>
+					<percent_left>0.0000</percent_left>
+					<percent_right>0.0000</percent_right>
+					<graph_elements>
+						<graph_element item="Template_app_MySQL:mysql.status[qcache_hits]">
+							<drawtype>2</drawtype>
+							<sortorder>2</sortorder>
+							<color>00EE00</color>
 							<yaxisside>0</yaxisside>
 							<calc_fnc>2</calc_fnc>
 							<type>0</type>
 						</graph_element>
 						<graph_element item="Template_app_MySQL:mysql.status[slow_queries]">
 							<drawtype>2</drawtype>
-							<sortorder>0</sortorder>
+							<sortorder>3</sortorder>
 							<color>EE0000</color>
 							<yaxisside>0</yaxisside>
 							<calc_fnc>2</calc_fnc>
 							<type>0</type>
 							<periods_cnt>5</periods_cnt>
 						</graph_element>
-						<graph_element item="Template_app_MySQL:mysql.status[qcache_hits]">
+						<graph_element item="Template_app_MySQL:mysql.status[questions]">
 							<drawtype>2</drawtype>
-							<sortorder>0</sortorder>
-							<color>00EE00</color>
+							<sortorder>1</sortorder>
+							<color>00DDDD</color>
 							<yaxisside>0</yaxisside>
 							<calc_fnc>2</calc_fnc>
 							<type>0</type>
 					</graph_elements>
 				</graph>
 				<graph name="Mysql: table cache" width="900" height="200">
-					<ymin_type>0</ymin_type>
+					<ymin_type>1</ymin_type>
 					<ymax_type>0</ymax_type>
 					<ymin_item_key></ymin_item_key>
 					<ymax_item_key></ymax_item_key>
 					<graph_elements>
 						<graph_element item="Template_app_MySQL:mysql.status[open_tables]">
 							<drawtype>0</drawtype>
-							<sortorder>0</sortorder>
+							<sortorder>1</sortorder>
 							<color>009900</color>
 							<yaxisside>0</yaxisside>
 							<calc_fnc>2</calc_fnc>
 						</graph_element>
 					</graph_elements>
 				</graph>
-				<graph name="Mysql: connections" width="900" height="200">
-					<ymin_type>0</ymin_type>
+				<graph name="Mysql: aborted..." width="900" height="200">
+					<ymin_type>1</ymin_type>
 					<ymax_type>0</ymax_type>
 					<ymin_item_key></ymin_item_key>
 					<ymax_item_key></ymax_item_key>
 					<show_work_period>0</show_work_period>
 					<show_triggers>0</show_triggers>
-					<graphtype>0</graphtype>
-					<yaxismin>0.0000</yaxismin>
-					<yaxismax>100.0000</yaxismax>
-					<show_legend>0</show_legend>
-					<show_3d>0</show_3d>
-					<percent_left>0.0000</percent_left>
-					<percent_right>0.0000</percent_right>
-					<graph_elements>
-						<graph_element item="Template_app_MySQL:mysql.status[Connections]">
-							<drawtype>0</drawtype>
-							<sortorder>0</sortorder>
-							<color>EE0000</color>
-							<yaxisside>1</yaxisside>
-							<calc_fnc>2</calc_fnc>
-							<type>0</type>
-							<periods_cnt>5</periods_cnt>
-						</graph_element>
-						<graph_element item="Template_app_MySQL:mysql.status[Threads_connected]">
-							<drawtype>2</drawtype>
-							<sortorder>0</sortorder>
-							<color>009900</color>
-							<yaxisside>0</yaxisside>
-							<calc_fnc>2</calc_fnc>
-							<type>0</type>
-							<periods_cnt>5</periods_cnt>
-						</graph_element>
-						<graph_element item="Template_app_MySQL:mysql.status[aborted_connects]">
-							<drawtype>2</drawtype>
-							<sortorder>0</sortorder>
-							<color>CC00CC</color>
-							<yaxisside>1</yaxisside>
-							<calc_fnc>2</calc_fnc>
-							<type>0</type>
-							<periods_cnt>5</periods_cnt>
-						</graph_element>
-					</graph_elements>
-				</graph>
-				<graph name="Mysql: aborted..." width="900" height="200">
-					<ymin_type>2</ymin_type>
-					<ymax_type>2</ymax_type>
-					<ymin_item_key></ymin_item_key>
-					<ymax_item_key></ymax_item_key>
-					<show_work_period>0</show_work_period>
-					<show_triggers>0</show_triggers>
 					<graphtype>1</graphtype>
 					<yaxismin>0.0000</yaxismin>
 					<yaxismax>100.0000</yaxismax>
 					<graph_elements>
 						<graph_element item="Template_app_MySQL:mysql.status[aborted_connects]">
 							<drawtype>1</drawtype>
-							<sortorder>0</sortorder>
+							<sortorder>1</sortorder>
 							<color>CC00CC</color>
 							<yaxisside>0</yaxisside>
 							<calc_fnc>2</calc_fnc>
 					<percent_left>0.0000</percent_left>
 					<percent_right>0.0000</percent_right>
 					<graph_elements>
+						<graph_element item="Template_app_MySQL:mysql.status[select_full_join]">
+							<drawtype>0</drawtype>
+							<sortorder>2</sortorder>
+							<color>009900</color>
+							<yaxisside>0</yaxisside>
+							<calc_fnc>2</calc_fnc>
+							<type>0</type>
+							<periods_cnt>5</periods_cnt>
+						</graph_element>
 						<graph_element item="Template_app_MySQL:mysql.status[select_scan]">
 							<drawtype>0</drawtype>
 							<sortorder>0</sortorder>
 							<type>0</type>
 							<periods_cnt>5</periods_cnt>
 						</graph_element>
-						<graph_element item="Template_app_MySQL:mysql.status[select_full_join]">
-							<drawtype>0</drawtype>
-							<sortorder>2</sortorder>
-							<color>009900</color>
-							<yaxisside>0</yaxisside>
-							<calc_fnc>2</calc_fnc>
-							<type>0</type>
-							<periods_cnt>5</periods_cnt>
-						</graph_element>
 					</graph_elements>
 				</graph>
 			</graphs>
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.