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.