Grafana，InfluxDB，两个标签和一个量。或如何计算子组的总和？

• 阿帕奇
• 加特林
• 负载运行企业
• Yandex.Tank

共有三个选项：

1. 只是按类型标签分组的金额
2. 格拉法纳路。我们使用一堆价值观
3. 子查询的最高总和

一切如何开始

[outputs.influxdb]
  urls = ["http://influxdb_server:8086"]
  database = "telegraf"
  username = "login-InfluxDb"
  password = "*****"
  retention_policy = "month"
  influx_uint_support = false

[agent]
  collection_jitter = "2s"
  interval = "2s"
  precision = "s"

[[inputs.jolokia2_agent]]
  username = "login-Jolokia"
  password = "*****"
  urls = ["http://127.0.0.1:7777/jvm-service"]

[[inputs.jolokia2_agent.metric]]
  paths = ["Usage","PeakUsage","CollectionUsage","Type"]
  name = "java_memory_pool"
  mbean = "java.lang:name=*,type=MemoryPool"
  tag_keys = ["name"]

[[processors.converter]]
  [processors.converter.fields]
    integer = ["CollectionUsage.*", "PeakUsage.*", "Usage.*"]
    tag = ["Type"]

SELECT max("Usage.committed")
FROM "telegraf"."month"."java_memory_pool"
WHERE
    host =~ /^${host:regex}$/ AND
    jolokia_agent_url =~ /^${jolokia:regex}$/ AND
    $timeFilter
GROUP BY
    "Type", "name", time($granularity)

SELECT max("Usage.committed")
FROM "telegraf"."month"."java_memory_pool"
WHERE
    host =~ /^serverName$/ AND
    jolokia_agent_url =~ /^http:\/\/127\.0\.0\.1:7777\/jvm-service$/ AND
    time >= 1583834400000ms and time <= 1583877600000ms
GROUP BY
    "Type", "name", time(1m)

请记住，在时间间隔（12小时）和分组步骤（1分钟）中，721是在当前设置下响应InfluxDB的请求的预期点数。

请记住20:00的值：NON_HEAP池172.5 MiB和HEAP池128 MiB。未来我们将专注于这些价值观。

问题仍然存在：如何获得为所有HEAP池和所有NON_HEAP池分配的总大小？

1.仅按类型标签分组的金额

1.1。按标签分组的总和

SELECT sum("Usage.committed")
FROM "telegraf"."month"."java_memory_pool"
WHERE
    host =~ /^${host:regex}$/ AND
    jolokia_agent_url =~ /^${jolokia:regex}$/ AND
    $timeFilter
GROUP BY
    "Type"

1.2。每分钟按标签分组的数量

1.3。标签每秒分组

2.格拉法纳路。我们使用一堆价值观

2.1。仅使悬停工具提示/累积值：累积

1. 添加系列覆盖 / HEAP / 堆栈：A
2. 添加系列覆盖 / NON_HEAP / 堆栈：B

1. 堆叠与空值 / 堆叠：开
2. 悬停工具提示 / 累计值：累计
3. 悬停工具提示 / 模式：单

• Stack A B Stacking & Null value / Stack: On, ;
• Hover tooltip / Mode , Single, Hover tooltip .

2.2。累加值：累积且隐藏中间行

1. 将具有不同名称和值0的新指标添加到结果中。
2. 将新的指标添加到堆栈A和堆栈B到堆栈顶部。
3. 从显示隐藏-的原线HEAP和NON_HEAP。

3.子查询的最高和

3.1最大值的累积和的增量之和

SELECT sum("U") FROM (
        SELECT non_negative_difference(cumulative_sum(max("Usage.committed"))) AS "U" 
        FROM "month"."java_memory_pool" 
        WHERE 
            (
                "host" =~ /^${host:regex}$/ AND 
                "jolokia_agent_url" =~ /^${jolokia:regex}$/
            ) AND 
            $timeFilter 
        GROUP BY time($granularity), "Type", "name"
)
GROUP BY "Type", time($granularity)

3.2分组级别发生变化的最高和

SELECT sum("A")
FROM (
    SELECT max("Usage.committed") as "A"
    FROM "month"."java_memory_pool" 
    WHERE
            (
                "host" =~ /^${host:regex}$/ AND 
                "jolokia_agent_url" =~ /^${jolokia:regex}$/
            ) AND 
            $timeFilter
    GROUP BY time($granularity), "Type", "name"
)
WHERE $timeFilter
GROUP BY time($granularity), "Type"

参考（代替参考）

• 格拉法纳（6.5.0）
• influxdb（1.7.9）
• telegraf（1.13.3）
• jolokia-jvm-1.6.2-agent.jar（1.6.2）