7,166
edits
Sensu influxDB Grafana cheat sheet: Difference between revisions
→influxDB
| Line 32: | Line 32: | ||
== influxDB == | == influxDB == | ||
*メンテナンス | |||
[https://github.com/phstc/influxdb-cli Ruby CLI for InfluxDB] | |||
[http://influxdb.com/docs/v0.7/api/query_language.html InfluxDB Query Language] | |||
<pre> | |||
db.get_database_list | |||
db.database | |||
use sensu | |||
db.database | |||
SELECT * FROM /.*/ LIMIT 1 | |||
db.query('SELECT * FROM /.*/ LIMIT 1').keys | |||
DELETE FROM /cpu_cpu0_.*/ | |||
SELECT * FROM * WHERE host=production | |||
SELECT * FROM /cpu_.*/ WHERE host=production | |||
SELECT * FROM * WHERE host=production | |||
SELECT * FROM /cpu_.*/ WHERE host=production | |||
DELETE FROM /cpu_.*/ WHERE time < now() - 24h | |||
DELETE FROM /memory_.*/ WHERE time < now() - 24h | |||
</pre> | |||
== Grafana == | == Grafana == | ||
*influxdb query で複数のホストから任意のホストのメトリックスを抽出 | *influxdb query で複数のホストから任意のホストのメトリックスを抽出 | ||