Real-time synchronization between ElasticSearch and mysql databases

I know a tool named ElasticSearch-jdbc. I also read the official documentation and wrote a test according to the official documentation (for the command, see the bottom), but it cannot be synchronized in real time, it will be updated in about one minute. I don't know where the problem is. Please let us know before you go! Command: {& quot; type & quot;: & quot; jdbc & quot;, & quot; jdbc & quot ;:{ & quot; url & quot ;:& quot; jdbc: mysql: xxx. xxx. xxx. xxx: 3306 world & quot;, & quot; user & synchronize mysqlelastic search

I know a tool named ElasticSearch-jdbc. I also read the official documentation and wrote a test according to the official documentation (for the command, see the bottom), but it cannot be synchronized in real time, it will be updated in about one minute. I don't know where the problem is. Please let us know before you go!
Command:
{
"Type": "jdbc ",
"Jdbc ":{
"Url": "jdbc: mysql: // xxx. xxx: 3306/world ",
"User": "root ",
"Password": "xxxxxx ",
"Schedule": "*/5 ****? ",
"Locale": "en_US ",
"SQL ":[
{
"Statement": "select \" world \ "as _ index, \" city \ "as _ type, ID as _ id, Name as \" Name \", countryCode as \ "CountryCode \", District as \ "District \", Population as \ "Population \" from city where \ "mytimestamp \">? ",
"Parameter": ["$ metrics. lastexecutionstart"]
},
{
"Statement": "delete from city where \" _ job \ "=? ",
"Parameter": ["$ job"]
}
],
"Statefile": "statefile. json ",
"Elasticsearch ":{
"Cluster": "my_cluster_name1 ",
"Host": "localhost ",
Port: 9300
},
"Index": "world ",
"Type": "city ",
"Index_settings ":{
"Index ":{
"Number_of_shards": 1
}
}
}
}