It takes lots of time initializing the query when using logstash-input-jdbc

Elastic Stack Logstash
1

Hi,
I'm using logstash-input-jdbc and I got some errors.
There are about 5 million records in my db(MySQL) and I want to put them into es. And there is lots of 'join' operations like
"select * from table1
left join table2 on xxx
left join table3 on xxx
left join table4 on xxx
....
....
...."
when I start logstash I got it takes lots of time of waiting for the operation in logstash like that:
SELECT count(*) AS count FROM (my select sql) AS t1 LIMIT 1;

how could I decrease the time or could I jump over the step?
Thanks.

2

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