InfluxDB-telegraf-CEPH-RGW-Flux查询语句

1. RGW缓存命中次数

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.cache_hit" or r["type_instance"] == "rgw.cache_miss")
  |> filter(fn: (r) => r["cluster_name"] == "横扫饥饿做回自己")
  |> filter(fn: (r) => r["host"] == "node4")

  |> derivative(unit: 10s, nonNegative: true, columns: ["_value"], timeColumn: "_time")

2. RGW失败请求数

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.failed_req")
  |> filter(fn: (r) => r["cluster_name"] == "横扫饥饿做回自己")
  |> filter(fn: (r) => r["host"] == "node4")
  
  |> derivative(unit: 1s, nonNegative: true, columns: ["_value"], timeColumn: "_time")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

3. RGW GC对象速率

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.gc_retire_object")
  |> filter(fn: (r) => r["cluster_name"] == "横扫饥饿做回自己")
  |> filter(fn: (r) => r["host"] == "node4")
  |> derivative(unit: 1s, nonNegative: true, columns: ["_value"], timeColumn: "_time")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

4. RGW GET请求数

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.get")
  |> filter(fn: (r) => r["cluster_name"] == "横扫饥饿做回自己")
  |> filter(fn: (r) => r["host"] == "node4")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

5. RGW PUT请求数

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.put")
  |> filter(fn: (r) => r["cluster_name"] == "横扫饥饿做回自己")
  |> filter(fn: (r) => r["host"] == "node4")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

6. RGW GET请求字节数

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.get_b")
  |> filter(fn: (r) => r["cluster_name"] == "横扫饥饿做回自己")
  |> filter(fn: (r) => r["host"] == "node4")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

7. RGW PUT请求字节数

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.put_b")
  |> filter(fn: (r) => r["cluster_name"] == "横扫饥饿做回自己")
  |> filter(fn: (r) => r["host"] == "node4")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

8.RGW GET请求初始化延时

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.get_initial_lat")
  |> filter(fn: (r) => r["cluster_name"] == "横扫饥饿做回自己")
  |> filter(fn: (r) => r["host"] == "node4")
  |> derivative(unit: 1s, nonNegative: true, columns: ["_value"], timeColumn: "_time")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

8.RGW PUT请求初始化延时

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.put_initial_lat")
  |> filter(fn: (r) => r["cluster_name"] == "横扫饥饿做回自己")
  |> filter(fn: (r) => r["host"] == "node4")
  |> derivative(unit: 1s, nonNegative: true, columns: ["_value"], timeColumn: "_time")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

9. RGW活跃的请求队列数量

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.qactive")
  |> filter(fn: (r) => r["cluster_name"] == "${cluster}")
  |> filter(fn: (r) => r["host"] == "${node}")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")

9. RGW请求队列长度

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "ceph_daemon_stats")
  |> filter(fn: (r) => r["type_instance"] == "rgw.qlen")
  |> filter(fn: (r) => r["cluster_name"] == "${cluster}")
  |> filter(fn: (r) => r["host"] == "${node}")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  |> yield(name: "mean")