Documentation
Table of Contents
1 §¶§å§ß§Ü§è?? Foreach
§°§Ô§Ý§ñ§Õ
§¶§å§ß§Ü§è?? foreach §Ó§Ú§Ü§à§â§Ú§ã§ä§à§Ó§å§ð§ä§î§ã§ñ §Ó §ã§å§Ü§å§á§ß§Ú§ç §à§Ò§é§Ú§ã§Ý§Ö§ß§ß§ñ§ç, §ë§à§Ò §á§à§Ó§Ö§â§ß§å§ä§Ú §à§Õ§ß§Ö §ã§å§Ü§å§á§ß§Ö §Ù§ß§Ñ§é§Ö§ß§ß§ñ §Õ§Ý§ñ §Ü§à§Ø§ß§à§Ô§à §Ö§Ý§Ö§Þ§Ö§ß§ä§Ñ, §Ó§Ú§Ò§â§Ñ§ß§à§Ô§à §Ó§Ú§Ü§à§â§Ú§ã§ä§Ñ§ß§Ú§Þ item filter.
§¯§Ñ§á§â§Ú§Ü§Ý§Ñ§Õ, §æ§å§ß§Ü§è?§ñ avg_foreach §á§à§Ó§Ö§â§ß§Ö §ã§Ö§â§Ö§Õ§ß? §Ù§ß§Ñ§é§Ö§ß§ß§ñ §Ù ?§ã§ä§à§â?? §Ü§à§Ø§ß§à§Ô§à §Ó§Ú§Ò§â§Ñ§ß§à§Ô§à §Ö§Ý§Ö§Þ§Ö§ß§ä§Ñ §á§â§à§ä§ñ§Ô§à§Þ §å§Ü§Ñ§Ù§Ñ§ß§à§Ô§à ?§ß§ä§Ö§â§Ó§Ñ§Ý§å §é§Ñ§ã§å.
§¶?§Ý§î§ä§â §Ö§Ý§Ö§Þ§Ö§ß§ä?§Ó ? §é§Ñ§ã§ä§Ú§ß§à§ð §ã§Ú§ß§ä§Ñ§Ü§ã§Ú§ã§å, §ñ§Ü§Ú§Û §Ó§Ú§Ü§à§â§Ú§ã§ä§à§Ó§å?§ä§î§ã§ñ §æ§å§ß§Ü§è?§ñ§Þ§Ú foreach. §µ §æ?§Ý§î§ä§â? §Ö§Ý§Ö§Þ§Ö§ß§ä?§Ó §á?§Õ§ä§â§Ú§Þ§å?§ä§î§ã§ñ §Ó§Ú§Ü§à§â§Ú§ã§ä§Ñ§ß§ß§ñ §ã§Ú§Þ§Ó§à§Ý?§Ó §á?§Õ§ã§ä§Ñ§ß§à§Ó§Ü§Ú, §ä§à§Þ§å §á§à§ä§â?§Ò§ß? §Ö§Ý§Ö§Þ§Ö§ß§ä§Ú §Þ§à§Ø§ß§Ñ §Ó§Ú§Ò§Ú§â§Ñ§ä§Ú §Õ§à§ã§Ú§ä§î §Ô§ß§å§é§Ü§à.
Supported functions
| Function | Description |
|---|---|
| avg_foreach | Returns the average value for each item. |
| bucket_rate_foreach | Returns pairs (bucket upper bound, rate value) suitable for use in the histogram_quantile() function, where "bucket upper bound" is the value of item key parameter defined by the <parameter number> parameter. |
| count_foreach | Returns the number of values for each item.. |
| exists_foreach | Returns the number of currently enabled items. |
| last_foreach | Returns the last value for each item. |
| max_foreach | Returns the maximum value for each item. |
| min_foreach | Returns the minimum value for each item. |
| sum_foreach | Returns the sum of values for each item. |
§³§Ú§ß§ä§Ñ§Ü§ã§Ú§ã §æ§å§ß§Ü§è??
§¶§å§ß§Ü§è?? foreach §á?§Õ§ä§â§Ú§Þ§å§ð§ä§î §Õ§Ó§Ñ §Ù§Ñ§Ô§Ñ§Ý§î§ß? §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ú: item filter (§Õ§Ö§ä§Ñ§Ý? §Õ§Ú§Ó. §ß§Ú§Ø§é§Ö) ? time period:
§¯§Ñ§á§â§Ú§Ü§Ý§Ñ§Õ:
avg_foreach(/*/mysql.qps?[group="MySQL Servers"],5m)
§á§à§Ó§Ö§â§ß§Ö §á¡¯§ñ§ä§Ú§ç§Ó§Ú§Ý§Ú§ß§ß§Ö §ã§Ö§â§Ö§Õ§ß? §Ù§ß§Ñ§é§Ö§ß§ß§ñ §Ü§à§Ø§ß§à§Ô§à §Ö§Ý§Ö§Þ§Ö§ß§ä§Ñ ?mysql.qps? §å §Ô§â§å§á? §ã§Ö§â§Ó§Ö§â§Ñ MySQL.
§©§Ñ§å§Ó§Ñ§Ø§ä§Ö, §ë§à §Õ§Ö§ñ§Ü? §æ§å§ß§Ü§è?? §á?§Õ§ä§â§Ú§Þ§å§ð§ä§î §Õ§à§Õ§Ñ§ä§Ü§à§Ó? §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ú.
Item filter
The first parameter allows to filter the items we are interested in. A complex filter may be used, referencing the item key, host group and tags, as illustrated by the examples:
| Syntax example | Description |
|---|---|
| /host/key[abc,*] | Matches similar items on this host. |
| /*/key | Matches the same item of any host. |
| /*/key?[group="ABC" and tag="tagname:value"] | Matches the same item of any host from the ABC group having 'tagname:value' tags. |
| /*/key[a,*,c]?[(group="ABC" and tag="Tag1") or (group="DEF" and (tag="Tag2" or tag="Tag3:value"))] | Matches similar items of any host from the ABC or DEF group with the respective tags. |
All referenced items must exist and collect data. Only enabled items on enabled hosts are included in the calculations.
If the item key of a referenced item is changed, the filter must be updated manually.
Specifying a parent host group includes the parent group and all nested host groups with their items.
§±§Ö§â?§à§Õ §é§Ñ§ã§å
§¥§â§å§Ô§Ú§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â §Õ§à§Ù§Ó§à§Ý§ñ? §Ó§Ü§Ñ§Ù§Ñ§ä§Ú §á§Ö§â?§à§Õ §é§Ñ§ã§å §Õ§Ý§ñ §Ñ§Ô§â§Ö§Ô§Ñ§è??. §±§Ö§â?§à§Õ §é§Ñ§ã§å §Þ§à§Ø§ß§Ñ §Ó§Ú§â§Ñ§Ù§Ú§ä§Ú §Ý§Ú§ê§Ö §ñ§Ü §é§Ñ§ã, §Ü?§Ý§î§Ü?§ã§ä§î §Ù§ß§Ñ§é§Ö§ß§î (§Ù §á§â§Ö§æ?§Ü§ã§à§Þ #) §ß§Ö §á?§Õ§ä§â§Ú§Þ§å?§ä§î§ã§ñ.
§±?§Õ§ä§â§Ú§Þ§å§Ó§Ñ§ß? §à§Õ§Ú§ß§Ú§è? §Ó§Ú§Þ?§â§ð§Ó§Ñ§ß§ß§ñ §Þ§à§Ø§ß§Ñ §Ó§Ú§Ü§à§â§Ú§ã§ä§à§Ó§å§Ó§Ñ§ä§Ú §Ó §è§î§à§Þ§å §á§Ñ§â§Ñ§Þ§Ö§ä§â? §Õ§Ý§ñ §Ù§â§å§é§ß§à§ã§ä?, §ß§Ñ§á§â§Ú§Ü§Ý§Ñ§Õ, ?5m? (§á¡¯§ñ§ä§î §ç§Ó§Ú§Ý§Ú§ß) §Ù§Ñ§Þ?§ã§ä§î ?300s? (300 §ã§Ö§Ü§å§ß§Õ) §Ñ§Ò§à ?1d? (§à§Õ§Ú§ß §Õ§Ö§ß§î) §Ù§Ñ§Þ?§ã§ä§î ?86400? (86400 §ã§Ö§Ü§å§ß§Õ).
§±§Ö§â?§à§Õ §é§Ñ§ã§å ?§Ô§ß§à§â§å?§ä§î§ã§ñ §ã§Ö§â§Ó§Ö§â§à§Þ, §ñ§Ü§ë§à §Ó?§ß §á§Ö§â§Ö§Õ§Ñ?§ä§î§ã§ñ §Ù§Ñ §Õ§à§á§à§Þ§à§Ô§à§ð §æ§å§ß§Ü§è?? last_foreach, §ä§à§Þ§å §Û§à§Ô§à §Þ§à§Ø§ß§Ñ §á§â§à§á§å§ã§ä§Ú§ä§Ú:
§±§Ö§â?§à§Õ §é§Ñ§ã§å §ß§Ö §á?§Õ§ä§â§Ú§Þ§å?§ä§î§ã§ñ §æ§å§ß§Ü§è??§ð exists_foreach.
§¥§à§Õ§Ñ§ä§Ü§à§Ó? §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ú
§´§â§Ö§ä?§Û §Õ§à§Õ§Ñ§ä§Ü§à§Ó§Ú§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â §á?§Õ§ä§â§Ú§Þ§å?§ä§î§ã§ñ §æ§å§ß§Ü§è??§ð bucket_rate_foreach:
bucket_rate_foreach(§æ?§Ý§î§ä§â §Ö§Ý§Ö§Þ§Ö§ß§ä?§Ó,§á§Ö§â?§à§Õ §é§Ñ§ã§å,<§ß§à§Þ§Ö§â §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ñ>)§Õ§Ö <§ß§à§Þ§Ö§â §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ñ> ¡ª §è§Ö §á§à§Ù§Ú§è?§ñ §Ù§ß§Ñ§é§Ö§ß§ß§ñ ?§Ó?§Õ§â§Ñ? §Ó §Ü§Ý§ð§é? §Ö§Ý§Ö§Þ§Ö§ß§ä§Ñ. §¯§Ñ§á§â§Ú§Ü§Ý§Ñ§Õ, §ñ§Ü§ë§à §Ù§ß§Ñ§é§Ö§ß§ß§ñ ?§Ó?§Õ§â§Ñ? §Ó myItem[aaa,0.2] §Õ§à§â?§Ó§ß§ð? ?0.2?, §ä§à §Û§à§Ô§à §á§à§Ù§Ú§è?§ñ §Õ§à§â?§Ó§ß§ð? 2.
§©§ß§Ñ§é§Ö§ß§ß§ñ §Ù§Ñ §Ù§Ñ§Þ§à§Ó§é§å§Ó§Ñ§ß§ß§ñ§Þ <§ß§à§Þ§Ö§â §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ñ> ¡ª ?1?.
§±§Ö§â§Ö§Ô§Ý§ñ§ß§î§ä§Ö §ã§å§Ü§å§á§ß? §à§Ò§é§Ú§ã§Ý§Ö§ß§ß§ñ, §ë§à§Ò §à§ä§â§Ú§Þ§Ñ§ä§Ú §Õ§à§Õ§Ñ§ä§Ü§à§Ó? §Ó?§Õ§à§Þ§à§ã§ä? §ä§Ñ §á§â§Ú§Ü§Ý§Ñ§Õ§Ú §Ó§Ú§Ü§à§â§Ú§ã§ä§Ñ§ß§ß§ñ §æ§å§ß§Ü§è?§Û foreach.
Behavior depending on availability
The following table illustrates how each function behaves in cases of limited availability of host/item and history data.
| Function | Disabled host | Unavailable host with data | Unavailable host without data | Disabled item | Unsupported item | Data retrieval error (SQL) |
|---|---|---|---|---|---|---|
| avg_foreach | ignore | return avg | ignore | ignore | ignore | ignore |
| bucket_rate_foreach | ignore | return bucket rate | ignore | ignore | ignore | ignore |
| count_foreach | ignore | return count | 0 | ignore | ignore | ignore |
| exists_foreach | ignore | 1 | 1 | ignore | 1 | n/a |
| last_foreach | ignore | return last | ignore | ignore | ignore | ignore |
| max_foreach | ignore | return max | ignore | ignore | ignore | ignore |
| min_foreach | ignore | return min | ignore | ignore | ignore | ignore |
| sum_foreach | ignore | return sum | ignore | ignore | ignore | ignore |
If the item is ignored, nothing is added to the aggregation.