# Can Metricbeat gather "waiting MySQL queries"?

**URL:** <https://discuss.elastic.co/t/can-metricbeat-gather-waiting-mysql-queries/103453>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [October 11, 2017, 12:31am UTC](https://discuss.elastic.co/t/can-metricbeat-gather-waiting-mysql-queries/103453 "2017-10-11T00:31:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Wanderer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wanderer/32/55140_2.png) [@Wanderer](https://discuss.elastic.co/u/Wanderer)\
**Post date:** [October 11, 2017, 12:31am UTC](https://discuss.elastic.co/t/can-metricbeat-gather-waiting-mysql-queries/103453/1 "2017-10-11T00:31:05Z")

</div>

We are troubleshooting an issue and would like to see "waiting MySQL queries" but did not see a metric for this. Is this in the MySQL module?

---

<div class="post-metadata">

**Author:** ![ruflin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ruflin/32/3116_2.png) [@ruflin](https://discuss.elastic.co/u/ruflin)\
**Post date:** [October 12, 2017, 11:02am UTC](https://discuss.elastic.co/t/can-metricbeat-gather-waiting-mysql-queries/103453/2 "2017-10-12T11:02:49Z")

</div>

Could you link / name the exact metric your are looking for? Here is a good overview: [https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html](https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html)

---

<div class="post-metadata">

**Author:** ![Wanderer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wanderer/32/55140_2.png) [@Wanderer](https://discuss.elastic.co/u/Wanderer)\
**Post date:** [October 12, 2017, 2:51pm UTC](https://discuss.elastic.co/t/can-metricbeat-gather-waiting-mysql-queries/103453/3 "2017-10-12T14:51:31Z")

</div>

Thank you for the reply. I have some more information.

The command that was run is 'mysqladmin pr'

It returned a table like this:

| 111637 |username | servername | username | Sleep | 0 | | | 0.000 |  
| 112065 | username | servername | username | Sleep | 6 | | | 0.000 |  
| 112071 | username | servername | username | Sleep | 0 | | | 0.000 |

Is it possible to visualize this?

---

<div class="post-metadata">

**Author:** ![ruflin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ruflin/32/3116_2.png) [@ruflin](https://discuss.elastic.co/u/ruflin)\
**Post date:** [October 13, 2017, 8:11am UTC](https://discuss.elastic.co/t/can-metricbeat-gather-waiting-mysql-queries/103453/4 "2017-10-13T08:11:04Z")

</div>

Unfortunately I don't really know what the values above are? It seems the only value with a major difference to before is 6. Does this column have a header name which indicates which variable it is?

---

<div class="post-metadata">

**Author:** ![Wanderer](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wanderer/32/55140_2.png) [@Wanderer](https://discuss.elastic.co/u/Wanderer)\
**Post date:** [October 17, 2017, 4:31pm UTC](https://discuss.elastic.co/t/can-metricbeat-gather-waiting-mysql-queries/103453/5 "2017-10-17T16:31:18Z")

</div>

See screenshot from test box.

 ![Capture](https://us1.discourse-cdn.com/elastic/original/3X/c/5/c57b99f82ef4316f7bc0121df7b8b1a80ae46aab.JPG)

---

<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 14, 2017, 4:31pm UTC](https://discuss.elastic.co/t/can-metricbeat-gather-waiting-mysql-queries/103453/6 "2017-11-14T16:31:31Z")

</div>

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