JDBC input scheduling issue - is it possible to run query a minute after the previous query finished

Elastic Stack Logstash
1

I'm using the Jdbc input to retrieve data from MS SQL database once a minute.
Usually it works fine. But as we know database performance is not very reliable thing and sometime it's take longer than one minute to the query to return. Sometime event 5 minutes.
But the Jdbc scheduler still run a query once a minute so there situations when multiple queries run at the same time. This creates additional pressure on a database and after some time there are 20 almost same queries run at the same time.

I assume I'm not the first person which encounter this problem. I'm sure there is some way to make Jdbc to run query a minute after the previous once is finished. Am I right?

1 Like
2

10 days without single comment. Great support here from Logstash team

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.