# ES doesn't update from MySql

**URL:** <https://discuss.elastic.co/t/es-doesnt-update-from-mysql/13351>\
**Category:** Elasticsearch\
**Created:** [August 27, 2013, 4:42pm UTC](https://discuss.elastic.co/t/es-doesnt-update-from-mysql/13351 "2013-08-27T16:42:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sakuragi](https://avatars.discourse-cdn.com/v4/letter/s/b38774/32.png) [@sakuragi](https://discuss.elastic.co/u/sakuragi)\
**Post date:** [August 27, 2013, 4:42pm UTC](https://discuss.elastic.co/t/es-doesnt-update-from-mysql/13351/1 "2013-08-27T16:42:49Z")

</div>

Hi everyone,  
I've a MySql database with 17727677 rows. I've created a jdbc river to connect it to ElasticSearch cluster composed by 11 nodes (1 master and 10 slaves). This is my river.

curl -XGET '[http://localhost:9200/\_river/airplanethreey/\_meta](http://localhost:9200/_river/airplanethreey/_meta)'  
{"\_index":"\_river","\_type":"airplanethreey","\_id":"\_meta","\_version":1,"exists":true, "\_source" : {  
"type" : "jdbc",  
"jdbc" : {  
"driver" : "com.mysql.jdbc.Driver",  
"url" : "jdbc:mysql://localhost:3306/airplanethreey",  
"user" : "root",  
"password" : "pass",  
"sql" : "SELECT ID as \_id, _and the other fields_",  
"poll" : "1m",  
"strategy" : "simple",  
"autocommit" : "true"  
},  
"index" : {  
"index" : "airplanethreey",  
"type" : "flight"  
}  
}}

With a smaller dataset it works and there is the update in ElasticSearch, with the big one no: in the terminal of master node of ES there is "always" this situation : the computing never ends  
\<nabble\_img src="Screenshot.png" border="0"/\>

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 2:19am UTC](https://discuss.elastic.co/t/es-doesnt-update-from-mysql/13351/2 "2017-07-06T02:19:30Z")

</div>