Zabbix mysql.status items Unsupported

[vitS]

Hi,

UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/root /usr/local/bin/mysql -N | awk '{print $$2}'

As I can see all our mysql.status items are not working with message like:
(example on Bytes sent)

Preprocessing failed for:
1. Failed: cannot calculate delta (speed per second) for value of type "string": cannot convert value to numeric type

Preprocessing step in zabbix:

1:	Change per second	227081

Item test:

• Result
  Result converted to Numeric (unsigned)502875

In command line:

zabbix_agentd -t mysql.status[Bytes_sent]
mysql.status[Bytes_sent] [t|1981513171928]

I checked our zabbix user - tried recreate UserParameter with it - No success:

UserParameter=mysql.status[*],echo "show global status where Variable_name='Bytes_sent';" | HOME=/root /usr/local/bin/mysql -N -uuser -ppassword | awk '{print $$2}'

zabbix_agentd -t mysql.status[Bytes_sent]
mysql.status[Bytes_sent] [t|mysql: [Warning] Using a password on the command line interface can be insecure.
1981673304348

And te same message in UI.

Could someone help me how to avoid it?

Thank You,

[vitS]

Hi,

Ok, I guess it is fixed by:

UserParameter=mysql.status[*],echo "show global status where Variable_name='$1';" | HOME=/root /usr/local/bin/mysql 2>/dev/null -N -uuser -ppassword | awk '{print $$2}'

Zabbix 5.0.3.

And as I heard from my colleagues started after migration

Maybe it will help someone

Thanks,