Comments (1)
Hi @NicoForce, thank you for sharing your problem and suggestion. Let's try to find a solution for your needs.
The thing with Prometheus is that by design it's intended to perform synchronous metric scrapes. So following this design "SQL Exporter" doesn't automatically make any DB requests. Whenever Prometheus sends a request to SQL Exporter, it sends a respective request to the DB and returns a formatted response. You can find a bit more details in the Why it exists section.
That is why we also can't add scrape intervals per query - we simply do not control scraping here.
However, in Prometheus you can configure separate jobs
and set parameters like scrape_interval
, scrape_timeout
for each. While scrape_interval
parameter can be used to run calls on at a given schedule, scrape_timeout
value will be passed to SQL Exporter via the X-Prometheus-Scrape-Timeout-Seconds
header to determine scrape timeout.
Also, on the SQL Exporter side, you can configure separate jobs
too. They can hit different targets with different queries. With min_interval
you can add minimum interval between query executions, i.e. scrapes will be cached to prevent unnecessary pressure on DB. Take a look at this config for a hint.
I'd say, try things out and let me know. It could be that having two sql exporter instances in your case is easier.
from sql_exporter.
Related Issues (20)
- Context Deadline Exceeded HOT 9
- Support for MSSQL named pipe (np:) and shared memory (lpc:) DSNs HOT 16
- `up` metric to show that database connection was successful HOT 5
- parameter to set log file location HOT 8
- Add custom metrics to expose MSSQL server hostname HOT 1
- can we have the Postgres collector yml file example
- Is it possible to distinguish between the sql exporter process status and the target database? HOT 3
- Scrape each job separately HOT 2
- [helm] Support getting data-source-name from an existing secret HOT 12
- Ignore no rows returned HOT 6
- Better handling of NULL return values in certain cases HOT 6
- Environment variable substitution for DSN's HOT 3
- Cache Mechanism for sql exporter HOT 2
- clickhouse `context deadline exceeded` HOT 1
- Helm chart improvement: additionalContainers HOT 5
- Can it support the collection of cloud databases HOT 1
- unable to use -web.listen.address flag HOT 4
- SIGHUP config reload HOT 4
- Clickhouse requests dosn't work after upgrade clickhouse driver to v2 HOT 6
- Scrape errors not clearing without restart HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql_exporter.