# Packetbeat missing some data

**URL:** <https://discuss.elastic.co/t/packetbeat-missing-some-data/180090>\
**Category:** Beats\
**Tags:** packetbeat\
**Created:** [May 8, 2019, 4:09am UTC](https://discuss.elastic.co/t/packetbeat-missing-some-data/180090 "2019-05-08T04:09:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shantanuo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shantanuo/32/10141_2.png) [@shantanuo](https://discuss.elastic.co/u/shantanuo)\
**Post date:** [May 8, 2019, 4:09am UTC](https://discuss.elastic.co/t/packetbeat-missing-some-data/180090/1 "2019-05-08T04:09:30Z")

</div>

Is there a limit of 10 seconds for logging queries using packetbeat? For e.g. The first query in the following example got logged correctly as expected. But the second query does not show up in elastic.

MySQL [test]\> select sleep(9.9);  
+------------+  
| sleep(9.9) |  
+------------+  
| 0 |  
+------------+  
1 row in set (9.91 sec)

MySQL [test]\> select sleep(10);  
+-----------+  
| sleep(10) |  
+-----------+  
| 0 |  
+-----------+  
1 row in set (10.00 sec)  
I guess it is related to refresh\_topology\_freq parameter that is set to 10 seconds by default. Is there any way to change this?

I need the second query above to be logged as well.

---

<div class="post-metadata">

**Author:** ![adrisr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adrisr/32/25423_2.png) [@adrisr](https://discuss.elastic.co/u/adrisr)\
**Post date:** [May 14, 2019, 2:04pm UTC](https://discuss.elastic.co/t/packetbeat-missing-some-data/180090/2 "2019-05-14T14:04:21Z")

</div>

Hi,

This must be caused by `transaction_timeout` being 10 seconds by default.

Try setting it to a higher value:

```auto
 - type: mysql
   ports: [3306, 3307]
   [...]
   transaction_timeout: 1m

```

---

<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:** [June 11, 2019, 2:04pm UTC](https://discuss.elastic.co/t/packetbeat-missing-some-data/180090/3 "2019-06-11T14:04:29Z")

</div>

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