Mysql module in metricbeats is displaying negative values

Elastic Stack Beats
1

I am seeing negative values for some of the fields. Please see attached screenshots. This happened when I stopped the MySQL database for some time. My version:

yum list | grep metricbeat
metricbeat.x86_64 5.4.0-1 @elasticsearch-5.x
metricbeat.i686 5.4.0-1 elasticsearch-5.x

Screen Shot 2017-05-29 at 6.47.50 PM.png1404×725 67.5 KB

Screen Shot 2017-05-29 at 6.48.01 PM.png1222×313 13.9 KB

2

I suspect that's because Timelion displays a derivative of the counter, and the MySQL restart set the counter to zero, causing a brief drop in the derivative value. You can edit the dashboard and add .if(operator="lt", if=0, then=0) to ignore the negative values.

3

We should also add that to our dashboards, can you open a Github ticket, please?