Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
24 lines (16 sloc) 587 Bytes

SQL-to-Graphite

A tool to easily send the results of SQL queries to Graphite!

Installation

pip install sql-to-graphite

Running

export S2G_DSN="mysq://username:password@host/db"
cat queries.sql | sql-to-graphite --graphite-host graphite.example.com --graphite-prefix db.metrics

The queries piped in should be a single query per line returning 2 columns. If there are more columns they will be ignored. The first column returned should be the metric name (minus the --graphite-prefix option) and the value.

SELECT "metric", 1+1;
SELECT "now", NOW();
Jump to Line
Something went wrong with that request. Please try again.