zabbix_get mysql.bytes_sent.rate - doesnt work

[marquez]

Hello,
I adeed to my linux client 10.10.10.91 mysql template.
And below are working (I run those commands on zbx server 10.10.10.253):
zabbix_get -s 10.10.10.91 -k 'system.cpu.util'
zabbix_get -s 10.10.10.91 -k 'proc.mem[php-fpm,,,,pmem]'
zabbix_get -s 10.10.10.91 -k 'system.sw.os'

but this doesn't work:
zabbix_get -s 10.10.10.91 -k 'mysql.bytes_sent.rate'
ZBX_NOTSUPPORTED: Unsupported item key.

zabbix_get -s 10.10.10.91 -k 'mysql.bytes_received.rate'
ZBX_NOTSUPPORTED: Unsupported item key.

But latest data are:

MySQL: Bytes received

55s

120.5158 Bps

MySQL: Bytes sent

25s

388.3916 Bps

So I dont understand why zabbix_get doesnt show correct value,

[Atsushi]

Check the settings of the template you are using. When I check it in my environment, the item with the item key "mysql.bytes_sent.rate" or "mysql.bytes_received.rate" is not fetched directly from the agent, but the item "MySQL: Get status variables". It seems that the acquired item is processed by preprocessing and acquired. In other words, if you want to check with zabbix_get, please check the result of getting "mysql.get_status_variables" by specifying the host and port number.