# Sql\_last\_value Start from First Execution

**URL:** <https://discuss.elastic.co/t/sql-last-value-start-from-first-execution/151269>\
**Category:** Logstash\
**Created:** [October 5, 2018, 6:16pm UTC](https://discuss.elastic.co/t/sql-last-value-start-from-first-execution/151269 "2018-10-05T18:16:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![stevenmarrocco](https://avatars.discourse-cdn.com/v4/letter/s/9d8465/32.png) [@stevenmarrocco](https://discuss.elastic.co/u/stevenmarrocco)\
**Post date:** [October 5, 2018, 6:16pm UTC](https://discuss.elastic.co/t/sql-last-value-start-from-first-execution/151269/1 "2018-10-05T18:16:11Z")

</div>

Hello,

Is there a way to set the value of sql\_last\_value to when the logstash service starts?

We have a very large database and when we run our logstash service it affects the application the database is connected to.

We want to be able to set the value of the sql\_last\_value variable to be when the logstash service starts so it does not retrieve historical data.

Thank you

---

<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:** [November 2, 2018, 6:16pm UTC](https://discuss.elastic.co/t/sql-last-value-start-from-first-execution/151269/2 "2018-11-02T18:16:12Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.