title: Logstash JDBC Input plugin : Migrate data from mysql in batch count
body: <p>I have a table of 20GB data having 50 million rows. Need to migrate to ElasticSearch using logstash jdbc input plugin. I have tried all basic implementation but need help in migrating data in batch i.e only 10,000 rows at a time. I am not sure how and where to specify this count and how to update it the next time i run logstash. Please help me solve this issue</p>
  
  <p>This is what i have:</p>
  
  <pre><code>input {
      jdbc {
          jdbc_driver_library =&gt; "mysql-connector-java-5.1.12-bin.jar"
          jdbc_driver_class =&gt; "com.mysql.jdbc.Driver"
          jdbc_connection_string =&gt; "jdbc:mysql://localhost/db"
          jdbc_validate_connection =&gt; true
          jdbc_user =&gt; "root"
          jdbc_password =&gt; "root"
          clean_run =&gt; true
          record_last_run =&gt; true
          use_column_value =&gt; true
          jdbc_paging_enabled =&gt; true
          jdbc_page_size =&gt; 5
          tracking_column =&gt; id
          statement =&gt; "select * from employee"
      }
  }
  </code></pre>
  
  <p>Thanks in advance.</p>