Can Metricbeat gather "waiting MySQL queries"?


(Wanderer) #1

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?


(ruflin) #2

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


(Wanderer) #3

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?


(ruflin) #4

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?


(Wanderer) #5

See screenshot from test box.


(system) #6

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