Mysql module in metricbeats is displaying negative values

(SB) #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

(Tudor Golubenco) #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.

(Tudor Golubenco) #3

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

(system) #4

This topic was automatically closed after 21 days. New replies are no longer allowed.