Logstash jdbc plugin: SELECT count(*) on startup

Elastic Stack Logstash
1

I have a table on MySQL server that I want to push to ES.

I can accomplish this with the jdbc plugin, but I found it a little heavy on the mysql server, each time it starts it run a

SELECT count(*) AS `count` FROM (:statement)

where statement is the parameter i put in config file logstash.conf, why logstash needs to retrieve this count of records? Is it mandatory or we can skip this?

thanks in advance

1 Like
2

Same problem here.

I believe that the problem is with the JDBC plugin, not the Logstash itself. But I don't know how to stop this count(*) from happening.