åè¿Zabbixçåå¦é½ç¥éï¼Zabbixéè¿ä¸ç¨çAgentæè
SNMPæ¶éç¸å
³ççæ§æ°æ®ï¼ç¶ååå¨å°æ°æ®åºéé¢å®æ¶å¨åå°å±ç¤ºãZabbixçæ§æ°æ®ä¸»è¦å为以ä¸ä¸¤ç±»ï¼
ããåå²æ°æ®ï¼historyç¸å
³è¡¨,ä»history_uint表éé¢å¯ä»¥æ¥è¯¢å°è®¾å¤çæ§é¡¹ç®çæ大ï¼æå°åå¹³åå¼,å³åå¨çæ§æ°æ®çåå§æ°æ®ã
ããè¶å¿æ°æ®ï¼trendsç¸å
³è¡¨,è¶å¿æ°æ®æ¯ç»è¿Zabbix计ç®çæ°æ®ï¼æ°æ®æ¯ä»history_uintéé¢æ±æ»çï¼ä»trends_uintå¯ä»¥æ¥çå°çæ§æ°æ®æ¯å°æ¶æ大ï¼æå°åå¹³åå¼ï¼å³åå¨çæ§æ°æ®çæ±æ»æ°æ®ã
ããZabbixå¯ä»¥éè¿ä¸¤ç§æ¹å¼è·ååå²æ°æ®ï¼
ãã1.éè¿Zabbixåå°è·ååå²æ°æ®
ããéè¿Zabbixåå°æ¥çåå²æ°æ®é常ç®åï¼å¯ä»¥éè¿Monitoring->Lastest dataçæ¹å¼æ¥çãä¹å¯ä»¥ç¹å»å³ä¸è§çAs plain testæé®ä¿åæææ¬æ件ã
ãã2.éè¿åå°è·åçæ°æ®è¿è¡å¤çåäºæ¬¡æ¥è¯¢æå¾å¤éå¶ï¼å æ¤å¯ä»¥éè¿SQLè¯å¥ç´æ¥ä»åå°DBæ¥è¯¢æ°æ®ã
ããé¦å
大家åºè¯¥çæSQLè¯å¥Select 常ç¨ç¨æ³ï¼
ããSELECT [ALL | DISTINCT] Select_List [INTO [New_Table_name]
FROM { Table_name | View_name} [ [,{table2_name | view2_name}
[,â¦] ]
[ WHERE Serch_conditions ]
[ GROUP BY Group_by_list ]
[ HAVING Serch_conditions ]
[ ORDER BY Order_list [ASC| DEsC] ]
ãã说æï¼
ãã1)SELECTåå¥æå®è¦æ¥è¯¢çç¹å®è¡¨ä¸çåï¼å®å¯ä»¥æ¯*ï¼è¡¨è¾¾å¼ï¼å表çã
ãã2)INTOåå¥æå®è¦çææ°ç表ã
ãã3)FROMåå¥æå®è¦æ¥è¯¢ç表æè
è§å¾ã
ãã4)WHEREåå¥ç¨æ¥éå®æ¥è¯¢çèå´åæ¡ä»¶ã
ãã5)GROUP BYåå¥æå®åç»æ¥è¯¢åå¥ã
ãã6)HAVINGåå¥ç¨äºæå®åç»åå¥çæ¡ä»¶ã
ãã7)ORDER BYå¯ä»¥æ ¹æ®ä¸ä¸ªæè
å¤ä¸ªåæ¥æåºæ¥è¯¢ç»æï¼å¨è¯¥åå¥ä¸ï¼æ¢å¯ä»¥ä½¿ç¨ååï¼ä¹å¯ä»¥ä½¿ç¨ç¸å¯¹åå·ï¼ASC表示ååºï¼DESC表示éåºã
ãã8ï¼mysqlèåå½æ°ï¼sum()ï¼count()ï¼avg()ï¼max()ï¼avg()çé½æ¯èåå½æ°ï¼å½æ们å¨ç¨èåå½æ°çæ¶åï¼ä¸è¬é½è¦ç¨å°GROUP BY å
è¿è¡åç»ï¼ç¶ååè¿è¡èåå½æ°çè¿ç®ãè¿ç®å®åå°±è¦ç¨å°Havingåå¥è¿è¡å¤æäº,ä¾å¦èåå½æ°çå¼æ¯å¦å¤§äºæä¸ä¸ªå¼ççã
温馨提示:答案为网友推荐,仅供参考