# ES doesn't update from MySql

**URL:** <https://discuss.elastic.co/t/es-doesnt-update-from-mysql/13352>\
**Category:** Elasticsearch\
**Created:** [August 27, 2013, 4:48pm UTC](https://discuss.elastic.co/t/es-doesnt-update-from-mysql/13352 "2013-08-27T16:48:01Z")\
**Posts on this page:** 3\
**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:48pm UTC](https://discuss.elastic.co/t/es-doesnt-update-from-mysql/13352/1 "2013-08-27T16:48:01Z")

</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

[https://lh4.googleusercontent.com/-6Zm0t73yX4U/UhzYKpRZUEI/AAAAAAAAAok/-cPkup8iv9A/s1600/Screenshot.png](https://lh4.googleusercontent.com/-6Zm0t73yX4U/UhzYKpRZUEI/AAAAAAAAAok/-cPkup8iv9A/s1600/Screenshot.png)

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [August 27, 2013, 7:11pm UTC](https://discuss.elastic.co/t/es-doesnt-update-from-mysql/13352/2 "2013-08-27T19:11:57Z")

</div>

For streaming large result sets, the MySQL JDBC driver connection must not  
be set to autocommit: true.

Jörg

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<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/13352/3 "2017-07-06T02:19:25Z")

</div>