i am displaying the records from mysql to elastic search through logstash and GUI kibana
In logstash config file code as follows
input {
jdbc {
jdbc_driver_library => "D:\mysql-connector-java-5.1.44\mysql-connector-java-5.1.44\mysql-connector-java-5.1.44-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/sample"
jdbc_user => "root"
jdbc_password => "root"
jdbc_fetch_size => 5000
schedule => "* * * * *"
statement => "select * from patdetails order by mrno asc limit 15"
codec => "json"
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "testingsample"
document_id => "%{mrno }" }
stdout { codec => rubydebug }
}
in kibana GUI displaying only 8 records
inkibana discover tab shows 8 hits and kibana GUI also displaying 8 records only but in logstash config file i written code as select * from patdetails order by mrno asc limit 15
display 15 reords
when i see the elastic search log file shows message as follows
[INFO ] [high disk watermark exceeded on one or more nodes]
[WARN] high disk watermark [90%] exceeded on shards will be relocated away from this node
INFO and WARN. why 15 records is not displaying in Kibana GUI.
how to solve this problem please let me know.