logstash input-jdbc 分页性能优化问题
原因
logstash 自带分页查询,竟然是查处所有数据再计数的。
1 | SELECT count(*) AS `count` FROM (SELECT * FROM ip_bundle_data_20190813) AS `t1` LIMIT 1 |
logstash 自带分页查询,竟然是查处所有数据再计数的。
1 | SELECT count(*) AS `count` FROM (SELECT * FROM ip_bundle_data_20190813) AS `t1` LIMIT 1 |