How to install sql-to-graphite
- Download and install ActivePython
- Open Command Prompt
- Type
pypm install sql-to-graphite
Lastest release
# 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 at least 2 columns. The first column returned should be the metric name (minus the --graphite-prefix option) and the value.
` SELECT "metric", 1+1; SELECT "now", NOW(); `