Mysql module in metricbeats is displaying negative values

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

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.

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

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