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?