logstach同步mysql测试数据时(一百万条),到了8w条之后sql_last_value的值不再变化
我的配置如下:
input {
jdbc {
jdbc_driver_library => "/usr/local/logstash-7.8.0/bin/mysql-connector-java-5.1.46/mysql-connector-java-5.1.46.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://127.0.0.1:3306/nacos?characterEncoding=UTF-8&useSSL=false&autoReconnect=true"
jdbc_user => "root"
jdbc_password => "Jt123456."
jdbc_default_timezone => "Asia/Shanghai"
schedule => "* * * * *"
statement => "SELECT * FROM users_copy1 where id > :sql_last_value limit 10000"
use_column_value => true
tracking_column_type => "numeric"
tracking_column => "id"
last_run_metadata_path => "syncpoint_table"
}
}
output {
elasticsearch {
hosts => ["http://localhost:9200"]
index => "users_copy-%{+YYYY.MM.dd}"
document_type => "_doc"
document_id => "%{id}"
}
}
运行结果及报错内容